{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-08-20","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":18,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1264,1267,1286,1287,1942,1308,1314,1312,1289,1866,1273","block_room_bookings":[{"confirmation_number":"SJ12671058055","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1264"},{"confirmation_number":"SJ12689590611","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJ12666914941","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1286"},{"confirmation_number":"SJ12666333757","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1287"},{"confirmation_number":"SJ12654973362","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1942"},{"confirmation_number":"SJ12615872599","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJ12634550760","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1314"},{"confirmation_number":"SJ12611739992","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJ12672568481","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1289"},{"confirmation_number":"SJ12647916543","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1866"},{"confirmation_number":"SJ12646427749","room_stay_from":"2021-08-13","room_stay_to":"2021-08-23","bundle_room":"0","product_id":"1273"}],"bundle_block_count":"1267,1268,1269,1270,1304,1305,1307,1308,1302,1303,1271,1272,1309,1310,1262,1263,1311,1312,1260,1261,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12649746188","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12665344166","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12637847979","room_stay_from":"2021-08-19","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12625734802","room_stay_from":"2021-08-19","room_stay_to":"2021-08-21","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12671583054","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","bundle_room":"1","product_id":"1330"},{"confirmation_number":"SJB12612904344","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12690952593","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12676600359","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12670998181","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12620777661","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12682017133","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12633656526","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12630740888","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12641238538","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12655865910","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","bundle_room":"1","product_id":"1714"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3301424","reservation_id":"120772","confirmation_number":"SJ12649344650","room_stay_from":"2021-08-17","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"207.27,207.27,207.27,270.27","nightly_discount":"0,0,0,0","subtotal":"892.08","grand_total":"1003.59","paid_amount":"1003.59","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-2539227838","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":"128152","customer_id":"128152","source_of_creation":"Booking.com","reservation_created_date":"2021-08-05 13:53:34","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"178.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"270.27","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304515","reservation_id":"119513","confirmation_number":"SJ12645942614","room_stay_from":"2021-08-19","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.48,236.88","nightly_discount":"0,0","subtotal":"423.36","grand_total":"476.28","paid_amount":"476.28","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-2105469925","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":"126666","customer_id":"126666","source_of_creation":"Booking.com","reservation_created_date":"2021-07-17 16:38:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"85.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"236.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305464","reservation_id":"121580","confirmation_number":"SJ12618453427","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.74","nightly_discount":"0","subtotal":"228.74","grand_total":"257.34","paid_amount":"257.34","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2648473162","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":"129068","customer_id":"129068","source_of_creation":"Booking.com","reservation_created_date":"2021-08-20 18:12:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"45.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"228.74","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272513","reservation_id":"117719","confirmation_number":"SJ12631500137","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,239.20","nightly_discount":"0,0","subtotal":"478.40","grand_total":"538.20","paid_amount":"538.20","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-2142491518","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":"124695","customer_id":"124695","source_of_creation":"Booking.com","reservation_created_date":"2021-06-20 21:37:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"95.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3295914","reservation_id":"118654","confirmation_number":"SJ12613221044","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"239.57,286.82,286.82","nightly_discount":"0,0,0","subtotal":"813.21","grand_total":"914.86","paid_amount":"914.86","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-2234460041","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":"125732","customer_id":"125732","source_of_creation":"Booking.com","reservation_created_date":"2021-07-04 14:28:22","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"286.82","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304366","reservation_id":"121439","confirmation_number":"SJ12611860526","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.63,232.63","nightly_discount":"0,0","subtotal":"465.26","grand_total":"523.41","paid_amount":"523.41","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3244400761","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":"128916","customer_id":"128916","source_of_creation":"Booking.com","reservation_created_date":"2021-08-18 23:49:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"92.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"232.63","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305168","reservation_id":"121506","confirmation_number":"SJ12663862019","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"307.20,307.20","nightly_discount":"0,0","subtotal":"614.40","grand_total":"691.20","paid_amount":"691.20","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2746828092","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":"128987","customer_id":"128987","source_of_creation":"Booking.com","reservation_created_date":"2021-08-19 17:46:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"119.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"307.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305437","reservation_id":"121576","confirmation_number":"SJ12625817643","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,239.20","nightly_discount":"0,0","subtotal":"478.40","grand_total":"538.20","paid_amount":"538.20","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3943632330","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":"129066","customer_id":"129066","source_of_creation":"Booking.com","reservation_created_date":"2021-08-20 17:33:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"95.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"239.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3238914","reservation_id":"111215","confirmation_number":"SJ12624482451","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"101.49,101.49,135.51,135.51,101.49","nightly_discount":"0,0,0,0,0","subtotal":"575.49","grand_total":"647.42","paid_amount":"647.42","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2282879312","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":"117746","customer_id":"117746","source_of_creation":"Booking.com","reservation_created_date":"2021-03-24 23:08:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"264.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"135.51","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3238917","reservation_id":"111215","confirmation_number":"SJ12685471986","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"115.67,115.67,149.69,149.69,115.67","nightly_discount":"0,0,0,0,0","subtotal":"646.39","grand_total":"727.19","paid_amount":"727.19","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2282879312","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":"117746","customer_id":"117746","source_of_creation":"Booking.com","reservation_created_date":"2021-03-24 23:08:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"264.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"149.69","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304551","reservation_id":"121418","confirmation_number":"SJ12660975173","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,171.75","nightly_discount":"0,0,0","subtotal":"665.25","grand_total":"748.40","paid_amount":"748.40","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-2469631891","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":"128891","customer_id":"128891","source_of_creation":"Booking.com","reservation_created_date":"2021-08-18 19:59:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305834","reservation_id":"121613","confirmation_number":"SJ12640639749","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0,0","subtotal":"941.50","grand_total":"1059.19","paid_amount":"1059.19","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3010268276","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":"129114","customer_id":"129114","source_of_creation":"Booking.com","reservation_created_date":"2021-08-20 22:28:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3293904","reservation_id":"120488","confirmation_number":"SJ12678815947","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.30,300.30,230.30,230.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1752.10","grand_total":"1971.12","paid_amount":"1971.12","room_type_id":"319","product_id":"1943","siteminder_id":"BDC-3035373619","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":"127802","customer_id":"127802","source_of_creation":"Booking.com","reservation_created_date":"2021-07-31 20:58:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"300.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305289","reservation_id":"119746","confirmation_number":"SJ12690436774","room_stay_from":"2022-05-01","room_stay_to":"2022-05-05","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.37,125.37,125.37,125.37","nightly_discount":"0,0,0,0","subtotal":"501.48","grand_total":"564.16","paid_amount":"141.04","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2255959139","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":"126939","customer_id":"126939","source_of_creation":"Booking.com","reservation_created_date":"2021-07-20 21:12:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"108.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3304972","reservation_id":"113356","confirmation_number":"SJ12634933985","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,201.75,201.75","nightly_discount":"0.00,0.00,0.00","subtotal":"552.75","grand_total":"621.85","paid_amount":"621.85","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1761284054","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":"119948","customer_id":"119948","source_of_creation":"Expedia","reservation_created_date":"2021-04-19 11:23:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"201.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305170","reservation_id":"121472","confirmation_number":"SJ12625989993","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"192.56,192.56","nightly_discount":"0,0","subtotal":"385.12","grand_total":"433.26","paid_amount":"433.26","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1818364208","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128955","customer_id":"128955","source_of_creation":"Expedia","reservation_created_date":"2021-08-19 14:03:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"192.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305461","reservation_id":"120105","confirmation_number":"SJ12652611482","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"210.56,210.56","nightly_discount":"0.00,0.00","subtotal":"421.12","grand_total":"473.76","paid_amount":"473.76","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1806946227","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":"127355","customer_id":"127355","source_of_creation":"Expedia","reservation_created_date":"2021-07-26 14:40:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 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":"126","currentDayPrice":"210.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305471","reservation_id":"112593","confirmation_number":"SJ12665719773","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.96,152.96","nightly_discount":"0,0","subtotal":"305.92","grand_total":"344.16","paid_amount":"344.16","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1758003732","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":"119173","customer_id":"119173","source_of_creation":"Expedia","reservation_created_date":"2021-04-10 14:34:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"152.96","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304545","reservation_id":"121421","confirmation_number":"SJ12681712746","room_stay_from":"2021-08-19","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.32,138.32,138.32,96.32","nightly_discount":"0,0,0,0","subtotal":"469.28","grand_total":"527.94","paid_amount":"527.94","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1818064860","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":"128893","customer_id":"128893","source_of_creation":"Expedia","reservation_created_date":"2021-08-18 20:43:26","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"138.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3290719","reservation_id":"120151","confirmation_number":"SJ12654695827","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.66,202.66","nightly_discount":"0,0","subtotal":"405.32","grand_total":"455.99","paid_amount":"455.99","room_type_id":"413","product_id":"1265","siteminder_id":"GAM-R2688961532","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":"127408","customer_id":"127408","source_of_creation":"Getaroom.com","reservation_created_date":"2021-07-26 22:06:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","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":"126","group_rooms":null,"currentDayPrice":"202.66","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3304757","reservation_id":"121022","confirmation_number":"SJ12699601572","room_stay_from":"2021-08-19","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"390.01,385.06","nightly_discount":"0.00,0.00","subtotal":"775.07","grand_total":"913.48","paid_amount":"913.48","room_type_id":"320","product_id":"1329","siteminder_id":"ABB-HMKJ5WJQST","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"780.26","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128439","customer_id":"128439","source_of_creation":"Airbnb","reservation_created_date":"2021-08-10 14:43:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"25.89","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"385.06","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3305368","reservation_id":"118012","confirmation_number":"SJ12643087510","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"8","room_stay_child_count":"0","nightly_price":"414.08,407.91","nightly_discount":"0.00,0.00","subtotal":"821.99","grand_total":"983.15","paid_amount":"983.15","room_type_id":"320","product_id":"1910","siteminder_id":"ABB-HMNRBF8RBX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"828.16","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125002","customer_id":"125002","source_of_creation":"Airbnb","reservation_created_date":"2021-06-24 22:50:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"30.24","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"414.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3305350","reservation_id":"121204","confirmation_number":"SJ12636106363","room_stay_from":"2021-08-20","room_stay_to":"2021-08-24","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"256.02,256.02,256.02,249.88","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1017.94","grand_total":"1179.65","paid_amount":"1179.65","room_type_id":"319","product_id":"1306","siteminder_id":"ABB-HMSKWNXWXH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1024.08","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128672","customer_id":"128672","source_of_creation":"Airbnb","reservation_created_date":"2021-08-14 23:40:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"30.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"256.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3286800","reservation_id":"119523","confirmation_number":"SJ12617496589","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.90,300.90","nightly_discount":"0.00,0.00","subtotal":"601.80","grand_total":"677.03","paid_amount":"677.03","room_type_id":"412","product_id":"1315","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":"126684","customer_id":"126684","source_of_creation":"FE","reservation_created_date":"2021-07-17 18:36:04","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"300.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304626","reservation_id":"116886","confirmation_number":"SJ12640066234","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"224.25,246.75,246.75","nightly_discount":"11.21,12.34,12.34","subtotal":"717.75","grand_total":"767.09","paid_amount":"767.09","room_type_id":"319","product_id":"1318","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":"115615","customer_id":"115615","source_of_creation":"FE","reservation_created_date":"2021-06-09 17:57:39","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"12.34","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3305391","reservation_id":"121564","confirmation_number":"SJ12610107443","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00","nightly_discount":"0.00","subtotal":"160.00","grand_total":"180.00","paid_amount":"180.00","room_type_id":"412","product_id":"1294","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":"129052","customer_id":"129052","source_of_creation":"PMS","reservation_created_date":"2021-08-20 15:12:27","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"160.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305571","reservation_id":"121595","confirmation_number":"SJ12696714800","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"254.00","nightly_discount":"0.00","subtotal":"254.00","grand_total":"285.75","paid_amount":"285.75","room_type_id":"319","product_id":"1917","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":"129090","customer_id":"129090","source_of_creation":"PMS","reservation_created_date":"2021-08-20 20:21:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"254.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305622","reservation_id":"121568","confirmation_number":"SJ12620737266","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.00","nightly_discount":"0.00","subtotal":"299.00","grand_total":"336.38","paid_amount":"336.38","room_type_id":"319","product_id":"1307","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":"129057","customer_id":"129057","source_of_creation":"PMS","reservation_created_date":"2021-08-20 15:48:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"299.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305180","reservation_id":"121537","confirmation_number":"SJ12673157955","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"322.15,407.15,407.15","nightly_discount":"0.00,0.00,0.00","subtotal":"1136.45","grand_total":"1278.50","paid_amount":"1278.50","room_type_id":"320","product_id":"1324","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":"128808","customer_id":"128808","source_of_creation":"PMS","reservation_created_date":"2021-08-19 23:08:17","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1271,1272","currentDayPrice":"407.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305539","reservation_id":"121516","confirmation_number":"SJ12691668368","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.15,305.15","nightly_discount":"15.26,15.26","subtotal":"610.30","grand_total":"652.25","paid_amount":"652.25","room_type_id":"413","product_id":"1262","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":"128997","customer_id":"128997","source_of_creation":"PMS","reservation_created_date":"2021-08-19 19:13:46","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","currentDayPrice":"305.15","currentDayDiscount":"15.26","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3283829","reservation_id":"117634","confirmation_number":"SJ12673504589","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.00,176.00,176.00,176.00,176.00","nightly_discount":"17.60,17.60,17.60,17.60,17.60","subtotal":"880.00","grand_total":"891.00","paid_amount":"891.00","room_type_id":"319","product_id":"1319","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":"74162","customer_id":"74162","source_of_creation":"PMS","reservation_created_date":"2021-06-19 17:49:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"176.00","currentDayDiscount":"17.60","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[{"room_stay_id":"3305303","reservation_id":"116608","confirmation_number":"SJ12698046361","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-06-05 19:26:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3298415","reservation_id":"115356","confirmation_number":"SJ12610691787","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-16 23:19:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3251044","reservation_id":"114477","confirmation_number":"SJ12668182506","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.28,102.28,102.28,102.28,102.28,102.28,102.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.00","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-05-04 01:37:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"102.28","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3298281","reservation_id":"113213","confirmation_number":"SJ12692519805","room_stay_from":"2021-08-14","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-17 17:29:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3302187","reservation_id":"112038","confirmation_number":"SJ12610466219","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1268","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-03 23:35:24","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3303695","reservation_id":"111004","confirmation_number":"SJ12672478703","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1270","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-22 19:55:00","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304262","reservation_id":"112039","confirmation_number":"SJ12614181084","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-03 23:37:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 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":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304466","reservation_id":"113231","confirmation_number":"SJ12614838393","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-17 18:12:03","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3303710","reservation_id":"110722","confirmation_number":"SJ12634040187","room_stay_from":"2021-08-17","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-19 15:56:01","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3298525","reservation_id":"116282","confirmation_number":"SJ12622209707","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-31 21:52:25","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3298621","reservation_id":"116769","confirmation_number":"SJ12628264167","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-06-08 00:18:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3304760","reservation_id":"121022","confirmation_number":"SJ12692739707","room_confirmation_number":"SJ12699601572","room_stay_from":"2021-08-19","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"100.59","paid_amount":"100.59","product_id":"1777","service_quantity":"1","customer_traveller_id":"128439","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-19 16:11:47","reservation_modified_date_time":"2021-08-19 16:11:47","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128439","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3273141","reservation_id":"118012","confirmation_number":"SJ12655932889","room_confirmation_number":"SJ12643087510","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"100,100","nightly_discount":"0.00,0.00","subtotal":"200.00","grand_total":"201.20","paid_amount":"201.20","product_id":"1777","service_quantity":"1","customer_traveller_id":"125002","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-06-24 22:50:08","reservation_modified_date_time":"2021-06-24 22:50:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125002","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","sub_hotel_id":"126","currentDayPrice":"100","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.60","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3295917","reservation_id":"118654","confirmation_number":"SJ12682244626","room_confirmation_number":"SJ12613221044","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"125732","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-03 20:43:13","reservation_modified_date_time":"2021-08-03 20:43:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125732","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305171","reservation_id":"121472","confirmation_number":"SJ12640081403","room_confirmation_number":"SJ12625989993","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"128955","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-19 23:00:57","reservation_modified_date_time":"2021-08-19 23:00:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128955","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305462","reservation_id":"120105","confirmation_number":"SJ12614630052","room_confirmation_number":"SJ12652611482","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"127355","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-20 18:09:47","reservation_modified_date_time":"2021-08-20 18:09:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127355","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3298280","reservation_id":"113213","confirmation_number":"SJ12648448656","room_confirmation_number":"SJ12692519805","room_stay_from":"2021-08-14","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 17:29:15","reservation_modified_date_time":"2021-08-05 19:57:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3301425","reservation_id":"120772","confirmation_number":"SJ12634017792","room_confirmation_number":"SJ12649344650","room_stay_from":"2021-08-17","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"128152","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-05 13:53:34","reservation_modified_date_time":"2021-08-11 18:48:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128152","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3302188","reservation_id":"112038","confirmation_number":"SJ12667044850","room_confirmation_number":"SJ12610466219","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118607","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 23:35:24","reservation_modified_date_time":"2021-08-13 17:05:43","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3303697","reservation_id":"111004","confirmation_number":"SJ12682381025","room_confirmation_number":"SJ12672478703","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117544","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 19:55:00","reservation_modified_date_time":"2021-08-17 13:21:48","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304263","reservation_id":"112039","confirmation_number":"SJ12631745655","room_confirmation_number":"SJ12614181084","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118608","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 23:37:08","reservation_modified_date_time":"2021-08-18 19:12:44","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304467","reservation_id":"113231","confirmation_number":"SJ12647680094","room_confirmation_number":"SJ12614838393","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119821","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 18:12:03","reservation_modified_date_time":"2021-08-19 01:51:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304516","reservation_id":"119513","confirmation_number":"SJ12694389890","room_confirmation_number":"SJ12645942614","room_stay_from":"2021-08-19","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"126666","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-17 16:38:10","reservation_modified_date_time":"2021-08-19 11:23:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126666","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304761","reservation_id":"121022","confirmation_number":"SJ12673770549","room_confirmation_number":"SJ12699601572","room_stay_from":"2021-08-19","room_stay_to":"2021-08-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":"1776","service_quantity":"1","customer_traveller_id":"128439","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-10 14:43:10","reservation_modified_date_time":"2021-08-19 16:11:48","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128439","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3305392","reservation_id":"121564","confirmation_number":"SJ12636678572","room_confirmation_number":"SJ12610107443","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129052","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 15:12:27","reservation_modified_date_time":"2021-08-20 15:20:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129052","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305400","reservation_id":"121566","confirmation_number":"SJ12696620652","room_confirmation_number":"SJ12654420184","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129055","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 15:31:51","reservation_modified_date_time":"2021-08-20 15:34:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129055","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305465","reservation_id":"121580","confirmation_number":"SJ12673638386","room_confirmation_number":"SJ12618453427","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"129068","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 18:12:13","reservation_modified_date_time":"2021-08-20 18:12:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129068","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305572","reservation_id":"121595","confirmation_number":"SJ12615561431","room_confirmation_number":"SJ12696714800","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"129090","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 20:21:29","reservation_modified_date_time":"2021-08-20 20:39:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129090","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305624","reservation_id":"121568","confirmation_number":"SJ12675956500","room_confirmation_number":"SJ12620737266","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"129057","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 15:48:14","reservation_modified_date_time":"2021-08-20 21:27:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129057","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272514","reservation_id":"117719","confirmation_number":"SJ12640627413","room_confirmation_number":"SJ12631500137","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"124695","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-20 21:37:07","reservation_modified_date_time":"2021-06-23 22:43:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124695","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3286801","reservation_id":"119523","confirmation_number":"SJ12670348455","room_confirmation_number":"SJ12617496589","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"126684","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-17 18:36:04","reservation_modified_date_time":"2021-07-19 21:32:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126684","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3290720","reservation_id":"120151","confirmation_number":"SJ12679995090","room_confirmation_number":"SJ12654695827","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"127408","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-26 22:06:07","reservation_modified_date_time":"2021-07-26 22:06:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127408","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3295918","reservation_id":"118654","confirmation_number":"SJ12694022882","room_confirmation_number":"SJ12613221044","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"125732","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-04 14:28:22","reservation_modified_date_time":"2021-08-03 20:43:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125732","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3303713","reservation_id":"110722","confirmation_number":"SJ12668281685","room_confirmation_number":"SJ12634040187","room_stay_from":"2021-08-17","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117233","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 15:56:01","reservation_modified_date_time":"2021-08-17 13:26:03","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304367","reservation_id":"121439","confirmation_number":"SJ12698679274","room_confirmation_number":"SJ12611860526","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"128916","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 23:49:12","reservation_modified_date_time":"2021-08-18 23:49:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128916","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304627","reservation_id":"116886","confirmation_number":"SJ12644919479","room_confirmation_number":"SJ12640066234","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"115615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-09 17:57:39","reservation_modified_date_time":"2021-08-19 14:03:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115615","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304973","reservation_id":"113356","confirmation_number":"SJ12636004971","room_confirmation_number":"SJ12634933985","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"119948","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-19 11:23:11","reservation_modified_date_time":"2021-08-19 20:05:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119948","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305169","reservation_id":"121506","confirmation_number":"SJ12612010379","room_confirmation_number":"SJ12663862019","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"128987","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-19 17:46:11","reservation_modified_date_time":"2021-08-19 22:58:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128987","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305172","reservation_id":"121472","confirmation_number":"SJ12655563220","room_confirmation_number":"SJ12625989993","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"128955","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-19 14:03:10","reservation_modified_date_time":"2021-08-19 23:00:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128955","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305371","reservation_id":"118012","confirmation_number":"SJ12653815004","room_confirmation_number":"SJ12643087510","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","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":"1776","service_quantity":"1","customer_traveller_id":"125002","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 22:50:08","reservation_modified_date_time":"2021-08-20 14:11:15","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125002","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3305438","reservation_id":"121576","confirmation_number":"SJ12641925919","room_confirmation_number":"SJ12625817643","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"129066","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 17:33:11","reservation_modified_date_time":"2021-08-20 17:33:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129066","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305463","reservation_id":"120105","confirmation_number":"SJ12681363728","room_confirmation_number":"SJ12652611482","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"127355","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-26 14:40:10","reservation_modified_date_time":"2021-08-20 18:09:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127355","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305473","reservation_id":"112593","confirmation_number":"SJ12694614355","room_confirmation_number":"SJ12665719773","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"119173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 14:34:14","reservation_modified_date_time":"2021-08-20 18:22:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119173","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305540","reservation_id":"121516","confirmation_number":"SJ12690337014","room_confirmation_number":"SJ12691668368","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"128997","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-19 19:13:46","reservation_modified_date_time":"2021-08-20 19:50:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128997","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3238916","reservation_id":"111215","confirmation_number":"SJ12637118153","room_confirmation_number":"SJ12624482451","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"117746","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 23:08:12","reservation_modified_date_time":"2021-04-21 17:30:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117746","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3238918","reservation_id":"111215","confirmation_number":"SJ12615909474","room_confirmation_number":"SJ12685471986","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"117746","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 23:08:17","reservation_modified_date_time":"2021-04-21 17:30:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117746","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3283830","reservation_id":"117634","confirmation_number":"SJ12688788733","room_confirmation_number":"SJ12673504589","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"10.00,10.00,10.00,10.00,10.00","subtotal":"125.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"74162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-19 17:49:30","reservation_modified_date_time":"2021-07-14 13:52:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74162","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"10.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3298524","reservation_id":"116282","confirmation_number":"SJ12657282565","room_confirmation_number":"SJ12622209707","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123143","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-31 21:52:25","reservation_modified_date_time":"2021-08-05 19:57:04","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3298620","reservation_id":"116769","confirmation_number":"SJ12695341156","room_confirmation_number":"SJ12628264167","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123677","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-08 00:18:36","reservation_modified_date_time":"2021-08-05 19:57:06","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304544","reservation_id":"121421","confirmation_number":"SJ12646688544","room_confirmation_number":"SJ12681712746","room_stay_from":"2021-08-19","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"128893","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 20:43:26","reservation_modified_date_time":"2021-08-19 11:47:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128893","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304550","reservation_id":"121418","confirmation_number":"SJ12688869451","room_confirmation_number":"SJ12660975173","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"128891","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 19:59:19","reservation_modified_date_time":"2021-08-19 11:50:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128891","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305351","reservation_id":"121204","confirmation_number":"SJ12646847638","room_confirmation_number":"SJ12636106363","room_stay_from":"2021-08-20","room_stay_to":"2021-08-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"128672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-14 23:40:16","reservation_modified_date_time":"2021-08-20 14:10:30","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128672","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3298414","reservation_id":"115356","confirmation_number":"SJ12636431603","room_confirmation_number":"SJ12610691787","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122082","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-16 23:19:12","reservation_modified_date_time":"2021-08-05 19:57:02","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305304","reservation_id":"116608","confirmation_number":"SJ12641874173","room_confirmation_number":"SJ12698046361","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123498","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-05 19:26:07","reservation_modified_date_time":"2021-08-20 12:57:54","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305833","reservation_id":"121613","confirmation_number":"SJ12658838639","room_confirmation_number":"SJ12640639749","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"129114","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 22:28:37","reservation_modified_date_time":"2021-08-21 01:22:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129114","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3251043","reservation_id":"114477","confirmation_number":"SJ12616665124","room_confirmation_number":"SJ12668182506","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 01:37:16","reservation_modified_date_time":"2021-05-12 22:47:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3293903","reservation_id":"120488","confirmation_number":"SJ12648395364","room_confirmation_number":"SJ12678815947","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"127802","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-31 20:58:37","reservation_modified_date_time":"2021-07-31 22:30:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127802","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305292","reservation_id":"119746","confirmation_number":"SJ12683395636","room_confirmation_number":"SJ12690436774","room_stay_from":"2022-05-01","room_stay_to":"2022-05-05","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126939","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-20 21:12:10","reservation_modified_date_time":"2021-08-20 12:49:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126939","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3305400","reservation_id":"121566","confirmation_number":"SJ12696620652","room_confirmation_number":"SJ12654420184","room_stay_from":"2021-08-20","room_stay_to":"2021-08-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129055","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 15:31:51","reservation_modified_date_time":"2021-08-20 15:34:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129055","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]}],"gift_shop_taxable":[],"gift_shop_non_taxable":[{"room_stay_id":"3305517","reservation_id":"121418","confirmation_number":"SJ12670475718","room_confirmation_number":"SJ12660975173","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"75.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-20 19:35:13","reservation_modified_date_time":"2021-08-20 19:35:13","customer_id":"128891","parentCustTravId":"128891","customer_traveller_id":"128891","static_pos_type":"petfee","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-08-20","sub_hotel_id":"126","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3293762","reservation_id":"120488","confirmation_number":"SJ12658362105","room_confirmation_number":"SJ12678815947","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"225.00","paid_amount":"0.00","product_id":"1704","service_quantity":"3","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-07-31 21:12:54","reservation_modified_date_time":"2021-07-31 21:12:54","customer_id":"127802","parentCustTravId":"127802","customer_traveller_id":"127802","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-20 20:53:26","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-08-20","sub_hotel_id":"126","deltaChange":-225,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}