{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-02","total_rooms_exist":"1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1281,1282,1286,1287,1288,1289,1291,1293,1294,1296,1297,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1318,1319,1711,1756,1866,1913,1915,1916,1917,1918,1919,1920,1921,1922,1923,1942,1943","departureCount":22,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1923,1276,1313,1920,1922,1921,1293,1919,1918,1262,1917,1270","block_room_bookings":[{"confirmation_number":"SJ12693730510","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12680256650","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","bundle_room":"0"},{"confirmation_number":"SJ12673593636","room_stay_from":"2019-11-09","room_stay_to":"2019-11-20","bundle_room":"0"},{"confirmation_number":"SJ12665324838","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12657221101","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12648030950","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12641902825","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","bundle_room":"0"},{"confirmation_number":"SJ12638549225","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12632903645","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12630741987","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","bundle_room":"0"},{"confirmation_number":"SJ12613532835","room_stay_from":"2019-12-18","room_stay_to":"2021-01-01","bundle_room":"0"}],"bundle_block_count":"1267,1268,1309,1260,1261,1310,1303,1307,1308,1291,1711,1302,1304,1305,1262,1263,1311,1312,1271,1272","bundle_block_bookings":[{"confirmation_number":"SJB12695849679","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","bundle_room":"1"},{"confirmation_number":"SJB12691655942","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","bundle_room":"0"},{"confirmation_number":"SJB12691361813","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","bundle_room":"1"},{"confirmation_number":"SJB12686562499","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","bundle_room":"0"},{"confirmation_number":"SJB12682412619","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","bundle_room":"0"},{"confirmation_number":"SJB12673999660","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","bundle_room":"0"},{"confirmation_number":"SJB12663354235","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","bundle_room":"0"},{"confirmation_number":"SJB12643052222","room_stay_from":"2019-12-31","room_stay_to":"2020-01-04","bundle_room":"1"},{"confirmation_number":"SJB12636624313","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","bundle_room":"0"},{"confirmation_number":"SJB12633357121","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","bundle_room":"1"},{"confirmation_number":"SJB12626138867","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","bundle_room":"1"},{"confirmation_number":"SJB12617776520","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","bundle_room":"1"},{"confirmation_number":"SJB12613531836","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3032663","reservation_id":"86280","confirmation_number":"SJ12682810692","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"417.6,417.6,255.6,255.6","nightly_discount":"0,0,0,0","subtotal":"1346.40","grand_total":"1514.70","paid_amount":"1514.70","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2238673054","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93083","customer_id":"93083","source_of_creation":"Booking.com","reservation_created_date":"2019-10-26 15:10:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"242.35","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"255.6","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":"3048859","reservation_id":"88486","confirmation_number":"SJ12664889463","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,234.00,234.00","nightly_discount":"0,0,0,0","subtotal":"1130.40","grand_total":"1271.70","paid_amount":"1271.70","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3907414660","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":"94700","customer_id":"94700","source_of_creation":"Booking.com","reservation_created_date":"2019-12-20 12:09:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"203.47","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"234.00","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":"3049191","reservation_id":"88522","confirmation_number":"SJ12647612717","room_stay_from":"2019-12-27","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,331.20,234.00,234.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2124.00","grand_total":"2389.50","paid_amount":"2389.50","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3164254978","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":"94725","customer_id":"94725","source_of_creation":"Booking.com","reservation_created_date":"2019-12-21 18:50:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"382.32","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"234.00","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":"3049808","reservation_id":"86294","confirmation_number":"SJ12656153696","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,234.00,234.00","nightly_discount":"0,0,0,0,0,0","subtotal":"1792.80","grand_total":"2016.90","paid_amount":"2016.90","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3428744582","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":"93092","customer_id":"93092","source_of_creation":"Booking.com","reservation_created_date":"2019-10-26 20:17:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"322.70","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"234.00","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":"3050979","reservation_id":"88755","confirmation_number":"SJ12656597895","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,277.00,266.00","nightly_discount":"0,0,0,0,0,0","subtotal":"1867.80","grand_total":"2101.28","paid_amount":"2101.28","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-3253543532","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":"94910","customer_id":"94910","source_of_creation":"Booking.com","reservation_created_date":"2019-12-27 04:17:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 332","ota_service_fee_amount":"0","commision_charges":"168.10","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"266.00","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":"3052432","reservation_id":"89003","confirmation_number":"SJ12677398271","room_stay_from":"2019-12-31","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,277.00,266.00","nightly_discount":"0,0,0","subtotal":"874.20","grand_total":"983.48","paid_amount":"983.48","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-2541612412","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":"95084","customer_id":"95084","source_of_creation":"Booking.com","reservation_created_date":"2019-12-31 13:00:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"157.36","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"266.00","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":"3052666","reservation_id":"88402","confirmation_number":"SJ12616371713","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"464.00,464.00,464.00,464.00,284.00,302.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2442.72","grand_total":"2748.06","paid_amount":"2748.06","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-3690288488","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"300.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94632","customer_id":"94632","source_of_creation":"Booking.com","reservation_created_date":"2019-12-16 22:15:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"436.32","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"302.72","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":"3044082","reservation_id":"87293","confirmation_number":"SJ12661009186","room_stay_from":"2019-12-27","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,331.20,234.00,234.00,266.00","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"2390.00","grand_total":"2688.75","paid_amount":"2688.75","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3182555039","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":"93850","customer_id":"93850","source_of_creation":"Booking.com","reservation_created_date":"2019-11-18 22:46:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"430.20","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"234.00","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":"3052352","reservation_id":"89017","confirmation_number":"SJ12613765356","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"261.90,310.50","nightly_discount":"0,0","subtotal":"572.40","grand_total":"643.95","paid_amount":"643.95","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-2507994203","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95095","customer_id":"95095","source_of_creation":"Booking.com","reservation_created_date":"2019-12-31 17:42:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"103.03","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"261.90","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":"3052706","reservation_id":"87885","confirmation_number":"SJ12659179510","room_stay_from":"2020-01-01","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"234,234,266","nightly_discount":"0,0,0","subtotal":"734.00","grand_total":"825.75","paid_amount":"825.75","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-3071748734","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94316","customer_id":"94316","source_of_creation":"Booking.com","reservation_created_date":"2019-12-05 18:14:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"145.62","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"234","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":"3053027","reservation_id":"88730","confirmation_number":"SJ12676704963","room_stay_from":"2019-12-31","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,277.00,266.00,266.00","nightly_discount":"0,0,0,0","subtotal":"1140.20","grand_total":"1282.73","paid_amount":"1282.73","room_type_id":"319","product_id":"1711","siteminder_id":"BDC-3527014960","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":"94890","customer_id":"94890","source_of_creation":"Booking.com","reservation_created_date":"2019-12-26 19:38:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"157.36","resv_is_no_show":"0","is_bundle":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"266.00","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":"3053082","reservation_id":"89140","confirmation_number":"SJ12627123288","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.00,191.20","nightly_discount":"0,0","subtotal":"457.20","grand_total":"514.35","paid_amount":"514.35","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-3855090424","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":"95190","customer_id":"95190","source_of_creation":"Booking.com","reservation_created_date":"2020-01-02 20:20:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"82.30","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"266.00","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":"3053072","reservation_id":"89129","confirmation_number":"SJ12654604335","room_stay_from":"2020-01-02","room_stay_to":"2020-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.00,191.20,162.52","nightly_discount":"0,0,0","subtotal":"619.72","grand_total":"697.19","paid_amount":"697.19","room_type_id":"319","product_id":"1942","siteminder_id":"BDC-2911679772","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":"95182","customer_id":"95182","source_of_creation":"Booking.com","reservation_created_date":"2020-01-02 17:26:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"116.43","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"266.00","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":"3053584","reservation_id":"85788","confirmation_number":"SJ12680896953","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,234.00,234.00","nightly_discount":"0,0,0,0,0,0","subtotal":"1792.80","grand_total":"2016.90","paid_amount":"2016.90","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-2554870856","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":"92804","customer_id":"92804","source_of_creation":"Booking.com","reservation_created_date":"2019-10-17 13:44:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"322.70","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"234.00","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":"3053593","reservation_id":"89133","confirmation_number":"SJ12690852516","room_stay_from":"2020-01-01","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.94","nightly_discount":"0","subtotal":"181.94","grand_total":"204.69","paid_amount":"204.69","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1616219722","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":"95184","customer_id":"95184","source_of_creation":"Expedia","reservation_created_date":"2020-01-02 19:02:11","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","changedComment":"Reservation created for complete past date","deltaChange":"181.94","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"}]},{"room_stay_id":"3023169","reservation_id":"82961","confirmation_number":"SJ12693833332","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"375.20,375.20,227.20,227.20","nightly_discount":"0,0,0,0","subtotal":"1204.80","grand_total":"1355.40","paid_amount":"1355.40","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1325872167","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":"90434","customer_id":"90434","source_of_creation":"Expedia","reservation_created_date":"2019-08-20 16:27:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"227.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":"3045144","reservation_id":"87996","confirmation_number":"SJ12673757283","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"324.00,291.00","nightly_discount":"0,0","subtotal":"615.00","grand_total":"691.88","paid_amount":"691.88","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1388932832","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94370","customer_id":"94370","source_of_creation":"Expedia","reservation_created_date":"2019-12-07 18:43:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"291.00","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":"3048729","reservation_id":"88477","confirmation_number":"SJ12679108464","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,212.80","nightly_discount":"0,0","subtotal":"452.00","grand_total":"508.50","paid_amount":"508.50","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1390616404","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":"94692","customer_id":"94692","source_of_creation":"Expedia","reservation_created_date":"2019-12-19 19:22:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"212.80","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":"3051457","reservation_id":"87326","confirmation_number":"SJ12623662349","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"309.60,309.60","nightly_discount":"0,0","subtotal":"619.20","grand_total":"696.60","paid_amount":"696.60","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1382983284","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":"93880","customer_id":"93880","source_of_creation":"Expedia","reservation_created_date":"2019-11-19 19:08:06","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","currentDayPrice":"309.60","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":"3052565","reservation_id":"89059","confirmation_number":"SJ12652185064","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"199.04","nightly_discount":"0","subtotal":"199.04","grand_total":"223.92","paid_amount":"223.92","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1615633403","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":"95121","customer_id":"95121","source_of_creation":"Expedia","reservation_created_date":"2020-01-01 16:12:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"199.04","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":"3052691","reservation_id":"87481","confirmation_number":"SJ12618123140","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"279.20,252.80","nightly_discount":"0,0","subtotal":"532.00","grand_total":"598.50","paid_amount":"598.50","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1601211984","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94009","customer_id":"94009","source_of_creation":"Expedia","reservation_created_date":"2019-11-24 20:13:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"252.80","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":"3052906","reservation_id":"88548","confirmation_number":"SJ12618790529","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.00,266.00","nightly_discount":"0,0","subtotal":"565.00","grand_total":"635.63","paid_amount":"635.63","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1611158825","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":"94746","customer_id":"94746","source_of_creation":"Expedia","reservation_created_date":"2019-12-22 15:47:09","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","currentDayPrice":"266.00","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":"3052953","reservation_id":"89121","confirmation_number":"SJ12693875437","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.94","nightly_discount":"0","subtotal":"181.94","grand_total":"204.69","paid_amount":"204.69","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1616123804","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":"95175","customer_id":"95175","source_of_creation":"Expedia","reservation_created_date":"2020-01-02 15:52:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"181.94","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":"3052959","reservation_id":"89122","confirmation_number":"SJ12682452719","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.94","nightly_discount":"0","subtotal":"181.94","grand_total":"204.69","paid_amount":"204.69","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1616124624","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":"95176","customer_id":"95176","source_of_creation":"Expedia","reservation_created_date":"2020-01-02 15:57:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"181.94","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":"3053148","reservation_id":"89153","confirmation_number":"SJ12641599270","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"216.14","nightly_discount":"0","subtotal":"216.14","grand_total":"243.16","paid_amount":"243.16","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1616303125","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":"95201","customer_id":"95201","source_of_creation":"Expedia","reservation_created_date":"2020-01-02 21:37:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"216.14","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":"3051454","reservation_id":"87496","confirmation_number":"SJ12627682458","room_stay_from":"2020-01-01","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20,187.20,212.80","nightly_discount":"0,0,0","subtotal":"587.20","grand_total":"660.60","paid_amount":"660.60","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1601346654","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":"94021","customer_id":"94021","source_of_creation":"Expedia","reservation_created_date":"2019-11-25 11:29:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"187.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":"3052703","reservation_id":"86516","confirmation_number":"SJ12689517597","room_stay_from":"2020-01-01","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20,187.20,212.80","nightly_discount":"0,0,0","subtotal":"587.20","grand_total":"660.60","paid_amount":"660.60","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1372194858","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":"93255","customer_id":"93255","source_of_creation":"Expedia","reservation_created_date":"2019-11-01 02:01:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"187.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":"3052738","reservation_id":"89079","confirmation_number":"SJ12648700480","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.94,218.88","nightly_discount":"0,0","subtotal":"400.82","grand_total":"450.92","paid_amount":"450.92","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1391405248","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":"95136","customer_id":"95136","source_of_creation":"Expedia","reservation_created_date":"2020-01-01 19:52:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"181.94","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":"3053145","reservation_id":"89132","confirmation_number":"SJ12641949906","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"181.94,163.48","nightly_discount":"0.00,0.00","subtotal":"345.42","grand_total":"388.60","paid_amount":"388.60","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1616199613","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":"95183","customer_id":"95183","source_of_creation":"Expedia","reservation_created_date":"2020-01-02 18:22:06","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","currentDayPrice":"181.94","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":"3053876","reservation_id":"88437","confirmation_number":"SJ12644793438","room_stay_from":"2019-12-27","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"363.20,363.20,355.20,355.20,355.20,207.20,207.20,465.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2672.00","grand_total":"3006.00","paid_amount":"3259.13","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1609223218","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":"94659","customer_id":"94659","source_of_creation":"Expedia","reservation_created_date":"2019-12-18 01:47:10","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","currentDayPrice":"207.20","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":"3052538","reservation_id":"87811","confirmation_number":"SJ12628331656","room_stay_from":"2020-01-01","room_stay_to":"2020-01-05","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"207.20,207.20,232.80,232.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"990.00","paid_amount":"990.00","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1603903700","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":"94251","customer_id":"94251","source_of_creation":"Expedia","reservation_created_date":"2019-12-03 16:58:07","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","currentDayPrice":"207.20","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":"3051253","reservation_id":"88622","confirmation_number":"SJ12616636737","room_stay_from":"2020-01-01","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.52,210.52,210.52,178.94,102.71,102.71","nightly_discount":"0,0,0,0,0,0","subtotal":"1015.92","grand_total":"1142.91","paid_amount":"1142.91","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1611696185","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":"94813","customer_id":"94813","source_of_creation":"Expedia","reservation_created_date":"2019-12-23 21:07:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"210.52","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":[{"room_stay_id":"3052567","reservation_id":"89060","confirmation_number":"SJ12659669641","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.60,176.68","nightly_discount":"0,0","subtotal":"375.28","grand_total":"422.19","paid_amount":"422.19","room_type_id":"319","product_id":"1311","siteminder_id":"HTN-113692738-AHNZG3","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":"95122","customer_id":"95122","source_of_creation":"HotelTonight","reservation_created_date":"2020-01-01 16:21:10","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","currentDayPrice":"176.68","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":"3052237","reservation_id":"88995","confirmation_number":"SJ12689985696","room_stay_from":"2020-01-01","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.60,176.68,212.54","nightly_discount":"0,0,0","subtotal":"587.82","grand_total":"661.30","paid_amount":"661.30","room_type_id":"319","product_id":"1274","siteminder_id":"HTN-113505898-4C9WNY","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":"95077","customer_id":"95077","source_of_creation":"HotelTonight","reservation_created_date":"2019-12-31 03:18:08","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","currentDayPrice":"176.68","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3041541","reservation_id":"87518","confirmation_number":"SJ12654113315","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.21,284.21","nightly_discount":"0,0","subtotal":"568.42","grand_total":"733.96","paid_amount":"733.96","room_type_id":"413","product_id":"1264","siteminder_id":"ABB-HMAEAQ8M9X","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"568.42","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94035","customer_id":"94035","source_of_creation":"Airbnb","reservation_created_date":"2019-11-25 20:10:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 211","ota_service_fee_amount":"75.59","commision_charges":"17.58","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"284.21","currentDayDiscount":"0","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":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3052684","reservation_id":"89018","confirmation_number":"SJ12638657362","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"413","product_id":"1266","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":"95096","customer_id":"95096","source_of_creation":"PMS","reservation_created_date":"2019-12-31 18:18:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"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":"3052949","reservation_id":"89124","confirmation_number":"SJ12692167423","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"478.00","nightly_discount":"0.00","subtotal":"478.00","grand_total":"537.75","paid_amount":"537.75","room_type_id":"320","product_id":"1330","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":"95178","customer_id":"95178","source_of_creation":"PMS","reservation_created_date":"2020-01-02 16:09:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","currentDayPrice":"478.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":"3053121","reservation_id":"89144","confirmation_number":"SJ12656587159","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"478.00","nightly_discount":"0.00","subtotal":"478.00","grand_total":"537.75","paid_amount":"537.75","room_type_id":"320","product_id":"1910","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":"95193","customer_id":"95193","source_of_creation":"PMS","reservation_created_date":"2020-01-02 20:47:47","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","currentDayPrice":"478.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":"3053294","reservation_id":"89173","confirmation_number":"SJ12687516044","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.03","nightly_discount":"0.00","subtotal":"245.03","grand_total":"275.66","paid_amount":"275.66","room_type_id":"319","product_id":"1301","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":"95211","customer_id":"95211","source_of_creation":"PMS","reservation_created_date":"2020-01-02 23:40:50","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","currentDayPrice":"245.03","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":"3053872","reservation_id":"89089","confirmation_number":"SJ12638856599","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,245.00","nightly_discount":"0.00,0.00","subtotal":"490.00","grand_total":"551.25","paid_amount":"551.25","room_type_id":"319","product_id":"1943","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":"95144","customer_id":"95144","source_of_creation":"PMS","reservation_created_date":"2020-01-01 22:52:54","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","currentDayPrice":"245.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":"3055353","reservation_id":"89165","confirmation_number":"SJ12664118467","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"318","product_id":"1281","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":"95207","customer_id":"95207","source_of_creation":"PMS","reservation_created_date":"2020-01-02 23:12:39","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"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":"3053595","reservation_id":"89174","confirmation_number":"SJ12657301039","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.00,202.00","nightly_discount":"0.00,0.00","subtotal":"404.00","grand_total":"454.50","paid_amount":"454.50","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":"95213","customer_id":"95213","source_of_creation":"PMS","reservation_created_date":"2020-01-02 23:50:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"202.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":"3053171","reservation_id":"89157","confirmation_number":"SJ12691842391","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"596.00","grand_total":"670.50","paid_amount":"670.50","room_type_id":"412","product_id":"1316","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":"95445","customer_id":"95445","source_of_creation":"PMS","reservation_created_date":"2020-01-02 22:30:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"149.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":"3053178","reservation_id":"89159","confirmation_number":"SJ12612707124","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"596.00","grand_total":"670.50","paid_amount":"670.50","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":"95204","customer_id":"95204","source_of_creation":"PMS","reservation_created_date":"2020-01-02 22:40:15","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","currentDayPrice":"149.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":"3053709","reservation_id":"89146","confirmation_number":"SJ12689725409","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"596.00","grand_total":"670.50","paid_amount":"670.50","room_type_id":"319","product_id":"1312","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":"88729","customer_id":"88729","source_of_creation":"PMS","reservation_created_date":"2020-01-02 20:57:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"149.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"}]}],"pms_non_taxable":[{"room_stay_id":"3045890","reservation_id":"88120","confirmation_number":"SJ12650189523","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","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","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-10 16:40:33","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","currentDayPrice":"0.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":"3045896","reservation_id":"88123","confirmation_number":"SJ12684287534","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","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","room_type_id":"319","product_id":"1278","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-10 16:46:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"0.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":"3048812","reservation_id":"82955","confirmation_number":"SJ12650065124","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","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","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82876","customer_id":"82876","source_of_creation":"PMS","reservation_created_date":"2019-08-20 12:58:07","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","currentDayPrice":"0.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":"3053263","reservation_id":"88121","confirmation_number":"SJ12631884314","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","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","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-10 16:42:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"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"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3032664","reservation_id":"86280","confirmation_number":"SJ12641677526","room_confirmation_number":"SJ12682810692","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"93083","product_attribute_values":"extra_person#.00","reservation_created_date":"2019-10-26 15:10:09","reservation_modified_date_time":"2019-10-26 15:10:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93083","canceled_nights_data":"","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":"3045145","reservation_id":"87996","confirmation_number":"SJ12671768349","room_confirmation_number":"SJ12673757283","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","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":"1777","service_quantity":"1","customer_traveller_id":"94370","product_attribute_values":"extra_person#.00","reservation_created_date":"2019-12-07 18:43:10","reservation_modified_date_time":"2019-12-07 18:43:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94370","canceled_nights_data":"","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":"3052707","reservation_id":"87885","confirmation_number":"SJ12623505998","room_confirmation_number":"SJ12659179510","room_stay_from":"2020-01-01","room_stay_to":"2020-01-04","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"94316","product_attribute_values":"extra_person#","reservation_created_date":"2020-01-01 20:02:03","reservation_modified_date_time":"2020-01-01 20:02:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94316","canceled_nights_data":"","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":"3052539","reservation_id":"87811","confirmation_number":"SJ12688184938","room_confirmation_number":"SJ12628331656","room_stay_from":"2020-01-01","room_stay_to":"2020-01-05","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":"1777","service_quantity":"1","customer_traveller_id":"94251","product_attribute_values":"extra_person#","reservation_created_date":"2019-12-31 01:11:45","reservation_modified_date_time":"2020-01-01 12:13:34","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94251","canceled_nights_data":"","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3023171","reservation_id":"82961","confirmation_number":"SJ12689879704","room_confirmation_number":"SJ12693833332","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","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":"90434","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-20 16:27:10","reservation_modified_date_time":"2019-08-20 16:27:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90434","canceled_nights_data":"","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":"3032665","reservation_id":"86280","confirmation_number":"SJ12648689328","room_confirmation_number":"SJ12682810692","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","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":"93083","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-10-26 15:10:09","reservation_modified_date_time":"2019-10-26 15:10:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93083","canceled_nights_data":"","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":"3045146","reservation_id":"87996","confirmation_number":"SJ12652922930","room_confirmation_number":"SJ12673757283","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","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":"94370","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-07 18:43:10","reservation_modified_date_time":"2019-12-07 18:43:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94370","canceled_nights_data":"","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":"3048730","reservation_id":"88477","confirmation_number":"SJ12626763768","room_confirmation_number":"SJ12679108464","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","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":"94692","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-19 19:22:10","reservation_modified_date_time":"2019-12-19 19:22:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94692","canceled_nights_data":"","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":"3048860","reservation_id":"88486","confirmation_number":"SJ12685512698","room_confirmation_number":"SJ12664889463","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","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":"94700","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-20 12:09:11","reservation_modified_date_time":"2019-12-20 12:09:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94700","canceled_nights_data":"","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":"3049192","reservation_id":"88522","confirmation_number":"SJ12653532097","room_confirmation_number":"SJ12647612717","room_stay_from":"2019-12-27","room_stay_to":"2020-01-03","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":"94725","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-21 18:50:12","reservation_modified_date_time":"2019-12-21 18:50:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94725","canceled_nights_data":"","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":"3049810","reservation_id":"86294","confirmation_number":"SJ12639755061","room_confirmation_number":"SJ12656153696","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Active","nightly_price":"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","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"93092","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-10-26 20:17:10","reservation_modified_date_time":"2019-10-26 20:17:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93092","canceled_nights_data":"","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":"3050980","reservation_id":"88755","confirmation_number":"SJ12623671972","room_confirmation_number":"SJ12656597895","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"94910","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-27 04:17:06","reservation_modified_date_time":"2019-12-27 04:17:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94910","canceled_nights_data":"","currentDayPrice":"25.00","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":"3051460","reservation_id":"87326","confirmation_number":"SJ12694918851","room_confirmation_number":"SJ12623662349","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","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":"93880","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-19 19:08:06","reservation_modified_date_time":"2019-11-19 19:08:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93880","canceled_nights_data":"","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":"3052433","reservation_id":"89003","confirmation_number":"SJ12613260899","room_confirmation_number":"SJ12677398271","room_stay_from":"2019-12-31","room_stay_to":"2020-01-03","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":"95084","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-31 13:00:10","reservation_modified_date_time":"2019-12-31 13:00:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95084","canceled_nights_data":"","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":"3052566","reservation_id":"89059","confirmation_number":"SJ12618714013","room_confirmation_number":"SJ12652185064","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","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":"95121","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-01 16:12:07","reservation_modified_date_time":"2020-01-01 16:12:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95121","canceled_nights_data":"","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":"3052568","reservation_id":"89060","confirmation_number":"SJ12653574594","room_confirmation_number":"SJ12659669641","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","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":"95122","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-01 16:21:10","reservation_modified_date_time":"2020-01-01 16:21:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95122","canceled_nights_data":"","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":"3052668","reservation_id":"88402","confirmation_number":"SJ12634696965","room_confirmation_number":"SJ12616371713","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Active","nightly_price":"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","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"94632","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-16 22:15:07","reservation_modified_date_time":"2020-01-01 19:03:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94632","canceled_nights_data":"","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":"3052685","reservation_id":"89018","confirmation_number":"SJ12620543776","room_confirmation_number":"SJ12638657362","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"25.00,25.00","subtotal":"50.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"95096","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-31 18:18:32","reservation_modified_date_time":"2019-12-31 18:18:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95096","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"25.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":"3052693","reservation_id":"87481","confirmation_number":"SJ12686229450","room_confirmation_number":"SJ12618123140","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","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":"94009","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-24 20:13:09","reservation_modified_date_time":"2019-11-24 20:13:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94009","canceled_nights_data":"","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":"3052907","reservation_id":"88548","confirmation_number":"SJ12691600657","room_confirmation_number":"SJ12618790529","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","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":"94746","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-22 15:47:09","reservation_modified_date_time":"2019-12-22 15:47:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94746","canceled_nights_data":"","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":"3052950","reservation_id":"89124","confirmation_number":"SJ12693137080","room_confirmation_number":"SJ12692167423","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","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":"95178","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 16:09:14","reservation_modified_date_time":"2020-01-02 16:09:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95178","canceled_nights_data":"","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":"3052954","reservation_id":"89121","confirmation_number":"SJ12672561343","room_confirmation_number":"SJ12693875437","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","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":"95175","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 15:52:07","reservation_modified_date_time":"2020-01-02 15:52:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95175","canceled_nights_data":"","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":"3052960","reservation_id":"89122","confirmation_number":"SJ12641145642","room_confirmation_number":"SJ12682452719","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","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":"95176","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 15:57:10","reservation_modified_date_time":"2020-01-02 15:57:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95176","canceled_nights_data":"","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":"3053122","reservation_id":"89144","confirmation_number":"SJ12688009038","room_confirmation_number":"SJ12656587159","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","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":"95193","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 20:47:47","reservation_modified_date_time":"2020-01-02 20:47:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95193","canceled_nights_data":"","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":"3053149","reservation_id":"89153","confirmation_number":"SJ12650669355","room_confirmation_number":"SJ12641599270","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","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":"95201","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 21:37:08","reservation_modified_date_time":"2020-01-02 21:37:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95201","canceled_nights_data":"","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":"3053295","reservation_id":"89173","confirmation_number":"SJ12691398649","room_confirmation_number":"SJ12687516044","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","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":"95211","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 23:40:50","reservation_modified_date_time":"2020-01-03 02:10:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95211","canceled_nights_data":"","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":"3053873","reservation_id":"89089","confirmation_number":"SJ12677380247","room_confirmation_number":"SJ12638856599","room_stay_from":"2020-01-01","room_stay_to":"2020-01-03","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":"95144","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-01 22:52:54","reservation_modified_date_time":"2020-01-01 22:52:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95144","canceled_nights_data":"","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":"3055354","reservation_id":"89165","confirmation_number":"SJ12696107296","room_confirmation_number":"SJ12664118467","room_stay_from":"2020-01-02","room_stay_to":"2020-01-03","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":"95207","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 23:12:39","reservation_modified_date_time":"2020-01-08 19:10:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95207","canceled_nights_data":"","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":"3041542","reservation_id":"87518","confirmation_number":"SJ12623012790","room_confirmation_number":"SJ12654113315","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","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":"94035","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-25 20:10:08","reservation_modified_date_time":"2019-11-25 20:10:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94035","canceled_nights_data":"","currentDayPrice":"25.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":"3044083","reservation_id":"87293","confirmation_number":"SJ12663327431","room_confirmation_number":"SJ12661009186","room_stay_from":"2019-12-27","room_stay_to":"2020-01-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"93850","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-18 22:46:09","reservation_modified_date_time":"2019-11-18 22:46:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93850","canceled_nights_data":"","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":"3045891","reservation_id":"88120","confirmation_number":"SJ12693557735","room_confirmation_number":"SJ12650189523","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","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":"94452","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-10 16:40:33","reservation_modified_date_time":"2019-12-10 16:40:33","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","canceled_nights_data":"","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":"3045897","reservation_id":"88123","confirmation_number":"SJ12644793982","room_confirmation_number":"SJ12684287534","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","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":"94455","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-10 16:46:18","reservation_modified_date_time":"2019-12-10 16:46:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","canceled_nights_data":"","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":"3048813","reservation_id":"82955","confirmation_number":"SJ12698240518","room_confirmation_number":"SJ12650065124","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","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":"90428","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-20 12:58:07","reservation_modified_date_time":"2019-08-20 12:58:07","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82876","canceled_nights_data":"","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":"3051456","reservation_id":"87496","confirmation_number":"SJ12685455176","room_confirmation_number":"SJ12627682458","room_stay_from":"2020-01-01","room_stay_to":"2020-01-04","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":"94021","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-25 11:29:09","reservation_modified_date_time":"2019-11-25 11:29:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94021","canceled_nights_data":"","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":"3052238","reservation_id":"88995","confirmation_number":"SJ12673608589","room_confirmation_number":"SJ12689985696","room_stay_from":"2020-01-01","room_stay_to":"2020-01-04","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":"95077","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-31 03:18:08","reservation_modified_date_time":"2019-12-31 03:18:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95077","canceled_nights_data":"","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":"3052354","reservation_id":"89017","confirmation_number":"SJ12677826161","room_confirmation_number":"SJ12613765356","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","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":"95095","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-31 17:42:09","reservation_modified_date_time":"2019-12-31 17:42:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95095","canceled_nights_data":"","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":"3052705","reservation_id":"86516","confirmation_number":"SJ12676281205","room_confirmation_number":"SJ12689517597","room_stay_from":"2020-01-01","room_stay_to":"2020-01-04","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":"93255","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-01 02:01:09","reservation_modified_date_time":"2019-11-01 02:01:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93255","canceled_nights_data":"","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":"3052708","reservation_id":"87885","confirmation_number":"SJ12660640697","room_confirmation_number":"SJ12659179510","room_stay_from":"2020-01-01","room_stay_to":"2020-01-04","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":"94316","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-05 18:14:10","reservation_modified_date_time":"2019-12-05 18:14:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94316","canceled_nights_data":"","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":"3052739","reservation_id":"89079","confirmation_number":"SJ12620380680","room_confirmation_number":"SJ12648700480","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","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":"95136","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-01 19:52:08","reservation_modified_date_time":"2020-01-01 19:52:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95136","canceled_nights_data":"","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":"3053029","reservation_id":"88730","confirmation_number":"SJ12671136847","room_confirmation_number":"SJ12676704963","room_stay_from":"2019-12-31","room_stay_to":"2020-01-04","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":"94890","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-26 19:38:08","reservation_modified_date_time":"2019-12-26 19:38:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94890","canceled_nights_data":"","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":"3053083","reservation_id":"89140","confirmation_number":"SJ12647155539","room_confirmation_number":"SJ12627123288","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","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":"95190","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 20:20:08","reservation_modified_date_time":"2020-01-02 20:20:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95190","canceled_nights_data":"","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":"3053147","reservation_id":"89132","confirmation_number":"SJ12620597309","room_confirmation_number":"SJ12641949906","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","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":"95183","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 18:22:06","reservation_modified_date_time":"2020-01-02 21:29:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95183","canceled_nights_data":"","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":"3053596","reservation_id":"89174","confirmation_number":"SJ12654883048","room_confirmation_number":"SJ12657301039","room_stay_from":"2020-01-02","room_stay_to":"2020-01-04","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":"95213","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 23:50:04","reservation_modified_date_time":"2020-01-02 23:50:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95213","canceled_nights_data":"","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":"3053878","reservation_id":"88437","confirmation_number":"SJ12626448934","room_confirmation_number":"SJ12644793438","room_stay_from":"2019-12-27","room_stay_to":"2020-01-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"94659","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-18 01:47:10","reservation_modified_date_time":"2020-01-04 12:37:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94659","canceled_nights_data":"","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":"3052540","reservation_id":"87811","confirmation_number":"SJ12647822003","room_confirmation_number":"SJ12628331656","room_stay_from":"2020-01-01","room_stay_to":"2020-01-05","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":"94251","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-03 16:58:07","reservation_modified_date_time":"2020-01-01 12:13:34","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94251","canceled_nights_data":"","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":"3053073","reservation_id":"89129","confirmation_number":"SJ12664804017","room_confirmation_number":"SJ12654604335","room_stay_from":"2020-01-02","room_stay_to":"2020-01-05","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":"95182","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 17:26:12","reservation_modified_date_time":"2020-01-02 17:26:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95182","canceled_nights_data":"","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":"3053172","reservation_id":"89157","confirmation_number":"SJ12656012919","room_confirmation_number":"SJ12691842391","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","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":"95445","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 22:30:25","reservation_modified_date_time":"2020-01-02 22:30:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95445","canceled_nights_data":"","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":"3053179","reservation_id":"89159","confirmation_number":"SJ12681093402","room_confirmation_number":"SJ12612707124","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","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":"95204","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 22:40:15","reservation_modified_date_time":"2020-01-02 22:40:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95204","canceled_nights_data":"","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":"3053711","reservation_id":"89146","confirmation_number":"SJ12632672800","room_confirmation_number":"SJ12689725409","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","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":"88729","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 20:57:22","reservation_modified_date_time":"2020-01-02 20:57:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88729","canceled_nights_data":"","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":"3051254","reservation_id":"88622","confirmation_number":"SJ12698437495","room_confirmation_number":"SJ12616636737","room_stay_from":"2020-01-01","room_stay_to":"2020-01-07","room_stay_status":"Active","nightly_price":"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","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"94813","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-23 21:07:05","reservation_modified_date_time":"2019-12-23 21:07:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94813","canceled_nights_data":"","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":"3053594","reservation_id":"89133","confirmation_number":"SJ12635063913","room_confirmation_number":"SJ12690852516","room_stay_from":"2020-01-01","room_stay_to":"2020-01-02","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":"95184","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 19:02:11","reservation_modified_date_time":"2020-01-02 19:02:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95184","canceled_nights_data":"","changedComment":"Reservation created for complete past date","deltaChange":"25.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"}]},{"room_stay_id":"3053585","reservation_id":"85788","confirmation_number":"SJ12644502837","room_confirmation_number":"SJ12680896953","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Active","nightly_price":"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","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"94947","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-10-17 13:44:09","reservation_modified_date_time":"2019-10-17 13:44:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92804","canceled_nights_data":"","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3052915","reservation_id":"89115","confirmation_number":"SJ12612933131","room_confirmation_number":"SJ12677862108","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"43.00","paid_amount":"43.00","product_id":null,"service_quantity":"1","product_name":"UV Shirts with/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 12:49:58","reservation_modified_date_time":"2020-01-02 12:49:58","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3053158","reservation_id":"89156","confirmation_number":"SJ12624012569","room_confirmation_number":"SJ12622791594","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"2","product_name":"Coconut","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:14:18","reservation_modified_date_time":"2020-01-02 22:14:18","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"11.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053259","reservation_id":"89183","confirmation_number":"SJ12690203100","room_confirmation_number":"SJ12672589457","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Coconut","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 01:03:37","reservation_modified_date_time":"2020-01-03 01:03:37","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3053154","reservation_id":"89155","confirmation_number":"SJ12660480839","room_confirmation_number":"SJ12672501835","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.00","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cori Hasty","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:11:10","reservation_modified_date_time":"2020-01-02 22:11:10","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3053157","reservation_id":"89156","confirmation_number":"SJ12666531573","room_confirmation_number":"SJ12622791594","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.00","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cori Hasty","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:14:18","reservation_modified_date_time":"2020-01-02 22:14:18","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3053174","reservation_id":"89158","confirmation_number":"SJ12625876139","room_confirmation_number":"SJ12678516047","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.00","grand_total":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cori Hasty","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:35:41","reservation_modified_date_time":"2020-01-02 22:35:41","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"9.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3053181","reservation_id":"89160","confirmation_number":"SJ12696120150","room_confirmation_number":"SJ12675055101","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.00","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cori Hasty","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:47:46","reservation_modified_date_time":"2020-01-02 22:47:46","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3053216","reservation_id":"89169","confirmation_number":"SJ12610956122","room_confirmation_number":"SJ12613117626","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.00","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cori Hasty","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 23:38:43","reservation_modified_date_time":"2020-01-02 23:38:43","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3053241","reservation_id":"89178","confirmation_number":"SJ12635046217","room_confirmation_number":"SJ12664636262","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.00","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cori Hasty","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 00:22:10","reservation_modified_date_time":"2020-01-03 00:22:10","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3053277","reservation_id":"89188","confirmation_number":"SJ12694445028","room_confirmation_number":"SJ12660113271","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.00","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cori Hasty","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 01:36:57","reservation_modified_date_time":"2020-01-03 01:36:57","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3053281","reservation_id":"89189","confirmation_number":"SJ12678944108","room_confirmation_number":"SJ12666416356","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.00","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cori Hasty","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 01:40:15","reservation_modified_date_time":"2020-01-03 01:40:15","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3053304","reservation_id":"89195","confirmation_number":"SJ12693260552","room_confirmation_number":"SJ12639726666","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.00","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cori Hasty","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 02:19:34","reservation_modified_date_time":"2020-01-03 02:19:34","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3053329","reservation_id":"89198","confirmation_number":"SJ12696450645","room_confirmation_number":"SJ12680081974","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.00","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Customer Tip for Cori Hasty","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 02:54:28","reservation_modified_date_time":"2020-01-03 02:54:28","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[{"room_stay_id":"3053080","reservation_id":"89139","confirmation_number":"SJ12671347902","room_confirmation_number":"SJ12616611233","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"House Rum","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 20:10:18","reservation_modified_date_time":"2020-01-02 20:10:18","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053081","reservation_id":"89139","confirmation_number":"SJ12699998661","room_confirmation_number":"SJ12616611233","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Virgin Daiquiri","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 20:10:18","reservation_modified_date_time":"2020-01-02 20:10:18","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053155","reservation_id":"89155","confirmation_number":"SJ12695118081","room_confirmation_number":"SJ12672501835","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"Hendriks","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:11:10","reservation_modified_date_time":"2020-01-02 22:11:10","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053175","reservation_id":"89158","confirmation_number":"SJ12659896725","room_confirmation_number":"SJ12678516047","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"2","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:35:41","reservation_modified_date_time":"2020-01-02 22:35:41","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053176","reservation_id":"89158","confirmation_number":"SJ12675113108","room_confirmation_number":"SJ12678516047","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Shock Top Draft","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:35:41","reservation_modified_date_time":"2020-01-02 22:35:41","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053177","reservation_id":"89158","confirmation_number":"SJ12640874961","room_confirmation_number":"SJ12678516047","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"5.56","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"1","product_name":"Jose Cuervo Gold","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:35:41","reservation_modified_date_time":"2020-01-02 22:35:41","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053182","reservation_id":"89160","confirmation_number":"SJ12619673284","room_confirmation_number":"SJ12675055101","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:47:46","reservation_modified_date_time":"2020-01-02 22:47:46","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053183","reservation_id":"89160","confirmation_number":"SJ12667690712","room_confirmation_number":"SJ12675055101","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"3","product_name":"Shock Top Draft","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:47:46","reservation_modified_date_time":"2020-01-02 22:47:46","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"13.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053187","reservation_id":"89162","confirmation_number":"SJ12694540628","room_confirmation_number":"SJ12665431759","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 22:56:02","reservation_modified_date_time":"2020-01-02 22:56:02","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053189","reservation_id":"89163","confirmation_number":"SJ12619610392","room_confirmation_number":"SJ12635693873","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.34","grand_total":"9.00","paid_amount":"9.00","product_id":null,"service_quantity":"1","product_name":"Johnny Walker Black","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 23:06:08","reservation_modified_date_time":"2020-01-02 23:06:08","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"8.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053217","reservation_id":"89169","confirmation_number":"SJ12689046233","room_confirmation_number":"SJ12613117626","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"House Rum","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-02 23:38:43","reservation_modified_date_time":"2020-01-02 23:38:43","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053236","reservation_id":"89176","confirmation_number":"SJ12686325515","room_confirmation_number":"SJ12649490626","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.85","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"2","product_name":"Soda","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 00:07:02","reservation_modified_date_time":"2020-01-03 00:07:02","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053242","reservation_id":"89178","confirmation_number":"SJ12678267931","room_confirmation_number":"SJ12664636262","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 00:22:10","reservation_modified_date_time":"2020-01-03 00:22:10","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053243","reservation_id":"89178","confirmation_number":"SJ12658504926","room_confirmation_number":"SJ12664636262","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"House Whiskey","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 00:22:10","reservation_modified_date_time":"2020-01-03 00:22:10","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053244","reservation_id":"89178","confirmation_number":"SJ12689053404","room_confirmation_number":"SJ12664636262","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"House Gin","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 00:22:10","reservation_modified_date_time":"2020-01-03 00:22:10","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053250","reservation_id":"89181","confirmation_number":"SJ12624082206","room_confirmation_number":"SJ12619728122","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 00:34:33","reservation_modified_date_time":"2020-01-03 00:34:33","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053251","reservation_id":"89181","confirmation_number":"SJ12676701039","room_confirmation_number":"SJ12619728122","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Domestic Draft Beer","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 00:34:33","reservation_modified_date_time":"2020-01-03 00:34:33","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053258","reservation_id":"89183","confirmation_number":"SJ12633504434","room_confirmation_number":"SJ12672589457","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"2","product_name":"Domestic Can Beer","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 01:03:37","reservation_modified_date_time":"2020-01-03 01:03:37","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053273","reservation_id":"89186","confirmation_number":"SJ12614159583","room_confirmation_number":"SJ12651720712","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Domestic Draft Beer","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 01:22:54","reservation_modified_date_time":"2020-01-03 01:22:54","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053278","reservation_id":"89188","confirmation_number":"SJ12651813425","room_confirmation_number":"SJ12660113271","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"Maker's Mark","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 01:36:57","reservation_modified_date_time":"2020-01-03 01:36:57","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053279","reservation_id":"89188","confirmation_number":"SJ12644239339","room_confirmation_number":"SJ12660113271","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"6.00","paid_amount":"6.00","product_id":null,"service_quantity":"2","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 01:36:57","reservation_modified_date_time":"2020-01-03 01:36:57","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"5.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053282","reservation_id":"89189","confirmation_number":"SJ12679357819","room_confirmation_number":"SJ12666416356","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Well Drinks","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 01:40:15","reservation_modified_date_time":"2020-01-03 01:40:15","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053283","reservation_id":"89189","confirmation_number":"SJ12652666957","room_confirmation_number":"SJ12666416356","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"2","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 01:40:15","reservation_modified_date_time":"2020-01-03 01:40:15","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053305","reservation_id":"89195","confirmation_number":"SJ12689889851","room_confirmation_number":"SJ12639726666","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"2","product_name":"House Tequila","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 02:19:34","reservation_modified_date_time":"2020-01-03 02:19:34","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053309","reservation_id":"89197","confirmation_number":"SJ12675249254","room_confirmation_number":"SJ12662645334","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"2","product_name":"House Vodka","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 02:43:47","reservation_modified_date_time":"2020-01-03 02:43:47","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"9.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3053330","reservation_id":"89198","confirmation_number":"SJ12651358846","room_confirmation_number":"SJ12680081974","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"Jameson","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 02:54:28","reservation_modified_date_time":"2020-01-03 02:54:28","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}