{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-06","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1278,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":16,"holdBlockRooms":{"hold_room_count":"1277","hold_room_bookings":[{"confirmation_number":"SJ12697964990","room_stay_from":"2020-03-03","room_stay_to":"2020-03-07","bundle_room":"0"}],"block_room_count":"1261,1312,1942,1262,1313,1943","block_room_bookings":[{"confirmation_number":"SJ12661352664","room_stay_from":"2020-03-04","room_stay_to":"2020-03-07","bundle_room":"0"},{"confirmation_number":"SJ12689500653","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","bundle_room":"0"},{"confirmation_number":"SJ12622180244","room_stay_from":"2020-02-29","room_stay_to":"2020-03-09","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12660283277","room_stay_from":"2020-03-02","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-03-27","bundle_room":"0"}],"bundle_block_count":"1260,1261,1291,1711,1307,1308,1262,1263,1267,1268,1309,1310,1304,1305,1271,1272,1269,1270,1302,1303,1311,1312","bundle_block_bookings":[{"confirmation_number":"SJB12671735907","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","bundle_room":"1"},{"confirmation_number":"SJB12678769234","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","bundle_room":"1"},{"confirmation_number":"SJB12684003462","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","bundle_room":"0"},{"confirmation_number":"SJB12690316105","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","bundle_room":"0"},{"confirmation_number":"SJB12682590000","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","bundle_room":"1"},{"confirmation_number":"SJB12686619366","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","bundle_room":"1"},{"confirmation_number":"SJB12621185457","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","bundle_room":"1"},{"confirmation_number":"SJB12661669537","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","bundle_room":"1"},{"confirmation_number":"SJB12650715139","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","bundle_room":"1"},{"confirmation_number":"SJB12699283429","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","bundle_room":"1"},{"confirmation_number":"SJB12612301217","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","bundle_room":"0"},{"confirmation_number":"SJB12614094009","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","bundle_room":"0"},{"confirmation_number":"SJB12644472257","room_stay_from":"2020-03-05","room_stay_to":"2020-03-12","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3073919","reservation_id":"92536","confirmation_number":"SJ12636557516","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.80","nightly_discount":"0","subtotal":"226.80","grand_total":"255.15","paid_amount":"255.15","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3788016210","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":"98698","customer_id":"98698","source_of_creation":"Booking.com","reservation_created_date":"2020-02-25 09:21:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"45.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"226.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":"3078729","reservation_id":"93039","confirmation_number":"SJ12690630216","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-2918814368","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":"99217","customer_id":"99217","source_of_creation":"Booking.com","reservation_created_date":"2020-03-06 22:16:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"36.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.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":"3078839","reservation_id":"91634","confirmation_number":"SJ12663383515","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.00","nightly_discount":"0","subtotal":"234.00","grand_total":"263.25","paid_amount":"263.25","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3087317359","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":"99228","customer_id":"99228","source_of_creation":"Booking.com","reservation_created_date":"2020-02-09 10:34:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"47.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3061702","reservation_id":"90585","confirmation_number":"SJ12685831356","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"143.5,143.5","nightly_discount":"0,0","subtotal":"287.00","grand_total":"322.88","paid_amount":"322.88","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-3105717362","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96652","customer_id":"96652","source_of_creation":"Booking.com","reservation_created_date":"2020-01-25 20:33:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"79.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.5","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":"3065614","reservation_id":"91185","confirmation_number":"SJ12631952695","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"111.1,143.5,143.5","nightly_discount":"0,0,0","subtotal":"398.10","grand_total":"447.87","paid_amount":"447.87","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-2285543696","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":"97309","customer_id":"97309","source_of_creation":"Booking.com","reservation_created_date":"2020-02-03 00:44:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"56.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.5","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":"3076353","reservation_id":"92786","confirmation_number":"SJ12667691279","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"350.00,350.00","nightly_discount":"0,0","subtotal":"700.00","grand_total":"787.50","paid_amount":"393.75","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3097905806","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":"98933","customer_id":"98933","source_of_creation":"Booking.com","reservation_created_date":"2020-02-29 20:17:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"135.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"350.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":"3077505","reservation_id":"89659","confirmation_number":"SJ12621022204","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"321.70,321.70","nightly_discount":"0,0","subtotal":"643.40","grand_total":"723.83","paid_amount":"723.83","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3598833794","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95643","customer_id":"95643","source_of_creation":"Booking.com","reservation_created_date":"2020-01-09 20:37:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"143.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"321.70","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":"3078063","reservation_id":"92912","confirmation_number":"SJ12642098072","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00,280.00","nightly_discount":"0,0","subtotal":"560.00","grand_total":"630.00","paid_amount":"630.00","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-2137622640","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":"99068","customer_id":"99068","source_of_creation":"Booking.com","reservation_created_date":"2020-03-03 17:16:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"109.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.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":"3078067","reservation_id":"92535","confirmation_number":"SJ12663346009","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"272,325,325","nightly_discount":"0,0,0","subtotal":"922.00","grand_total":"1037.25","paid_amount":"1037.25","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2862401758","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":"98697","customer_id":"98697","source_of_creation":"Booking.com","reservation_created_date":"2020-02-25 09:21:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"192.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"325","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":"3078551","reservation_id":"92009","confirmation_number":"SJ12642654969","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"420,420","nightly_discount":"0,0","subtotal":"840.00","grand_total":"945.00","paid_amount":"945.00","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-3841146308","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98173","customer_id":"98173","source_of_creation":"Booking.com","reservation_created_date":"2020-02-15 19:50:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"179.32","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"420","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":"3078679","reservation_id":"92029","confirmation_number":"SJ12682213094","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00,280.00","nightly_discount":"0,0","subtotal":"560.00","grand_total":"630.00","paid_amount":"630.00","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-3331084872","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":"99207","customer_id":"99207","source_of_creation":"Booking.com","reservation_created_date":"2020-02-16 04:04:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"110.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.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":"3078827","reservation_id":"92426","confirmation_number":"SJ12681234262","room_stay_from":"2020-03-24","room_stay_to":"2020-03-25","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"185","nightly_discount":"0","subtotal":"185.00","grand_total":"208.13","paid_amount":"208.13","room_type_id":"413","product_id":"1271","siteminder_id":"BDC-3312881399","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98601","customer_id":"98601","source_of_creation":"Booking.com","reservation_created_date":"2020-02-23 17:21:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"42.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3055197","reservation_id":"86752","confirmation_number":"SJ12617303084","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"272.80,230.40,230.40,230.40,230.40,230.40,272.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1697.60","grand_total":"1909.80","paid_amount":"1909.80","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1375501820","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":"93421","customer_id":"93421","source_of_creation":"Expedia","reservation_created_date":"2019-11-06 16:30: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","migrated_id":"","currentDayPrice":"272.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":"3066561","reservation_id":"91430","confirmation_number":"SJ12642163936","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00","nightly_discount":"0","subtotal":"172.00","grand_total":"193.50","paid_amount":"193.50","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1636740763","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":"97559","customer_id":"97559","source_of_creation":"Expedia","reservation_created_date":"2020-02-06 18:53:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.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":"3074664","reservation_id":"91639","confirmation_number":"SJ12664433543","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"205.20,223.20","nightly_discount":"0,0","subtotal":"428.40","grand_total":"481.95","paid_amount":"481.95","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1638329276","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":"97776","customer_id":"97776","source_of_creation":"Expedia","reservation_created_date":"2020-02-09 15:28:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"223.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":"3074667","reservation_id":"91955","confirmation_number":"SJ12632568471","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,187.20","nightly_discount":"0,0","subtotal":"356.40","grand_total":"400.95","paid_amount":"400.95","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1641315395","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":"98102","customer_id":"98102","source_of_creation":"Expedia","reservation_created_date":"2020-02-14 03:19:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3076276","reservation_id":"92281","confirmation_number":"SJ12648491434","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60","nightly_discount":"0","subtotal":"201.60","grand_total":"226.80","paid_amount":"226.80","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1645704231","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":"98463","customer_id":"98463","source_of_creation":"Expedia","reservation_created_date":"2020-02-21 02:28:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"201.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":"3077765","reservation_id":"90494","confirmation_number":"SJ12697251388","room_stay_from":"2020-03-04","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"179.00,179.00,215.00","nightly_discount":"0,0,0","subtotal":"573.00","grand_total":"644.63","paid_amount":"644.63","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1628994775","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":"96550","customer_id":"96550","source_of_creation":"Expedia","reservation_created_date":"2020-01-24 15:34:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.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":"3077969","reservation_id":"92606","confirmation_number":"SJ12640410314","room_stay_from":"2020-03-04","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,201.60","nightly_discount":"0.00,0.00,0.00","subtotal":"568.80","grand_total":"639.90","paid_amount":"639.90","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1648992567","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":"98762","customer_id":"98762","source_of_creation":"Expedia","reservation_created_date":"2020-02-26 17:43:05","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"113.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"201.60","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":"3078731","reservation_id":"92199","confirmation_number":"SJ12635887970","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"196.00","nightly_discount":"0","subtotal":"196.00","grand_total":"220.50","paid_amount":"220.50","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1644714848","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":"98385","customer_id":"98385","source_of_creation":"Expedia","reservation_created_date":"2020-02-19 16:28:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"196.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":"3078776","reservation_id":"93040","confirmation_number":"SJ12670767443","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"128.88","nightly_discount":"0","subtotal":"128.88","grand_total":"144.99","paid_amount":"144.99","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1654213904","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":"99220","customer_id":"99220","source_of_creation":"Expedia","reservation_created_date":"2020-03-06 23:00:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3078842","reservation_id":"93044","confirmation_number":"SJ12651546361","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.88","nightly_discount":"0","subtotal":"128.88","grand_total":"144.99","paid_amount":"144.99","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1654241298","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":"99229","customer_id":"99229","source_of_creation":"Expedia","reservation_created_date":"2020-03-07 00:04:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3078879","reservation_id":"92064","confirmation_number":"SJ12620489313","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"274.5","nightly_discount":"0","subtotal":"274.50","grand_total":"308.82","paid_amount":"308.82","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1642886581","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99236","customer_id":"99236","source_of_creation":"Expedia","reservation_created_date":"2020-02-16 20:54:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"274.5","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":"3063434","reservation_id":"90907","confirmation_number":"SJ12651125833","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,172.00,172.00","nightly_discount":"0,0,0","subtotal":"487.20","grand_total":"548.10","paid_amount":"548.10","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1632159193","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":"97002","customer_id":"97002","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 23:38:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.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":"3064014","reservation_id":"91023","confirmation_number":"SJ12689263523","room_stay_from":"2020-03-03","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,169.20,187.20,187.20","nightly_discount":"0,0,0,0,0","subtotal":"882.00","grand_total":"992.25","paid_amount":"992.25","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1633421734","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":"97130","customer_id":"97130","source_of_creation":"Expedia","reservation_created_date":"2020-02-01 01:03:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3066438","reservation_id":"91403","confirmation_number":"SJ12628564409","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00","nightly_discount":"0,0","subtotal":"430.00","grand_total":"483.75","paid_amount":"483.75","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1636419351","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":"97532","customer_id":"97532","source_of_creation":"Expedia","reservation_created_date":"2020-02-06 05:13:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.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":"3067675","reservation_id":"91614","confirmation_number":"SJ12613875844","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,172.00,172.00","nightly_discount":"0,0,0","subtotal":"487.20","grand_total":"548.10","paid_amount":"548.10","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1638023693","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":"97751","customer_id":"97751","source_of_creation":"Expedia","reservation_created_date":"2020-02-08 22:28:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.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":"3071298","reservation_id":"92178","confirmation_number":"SJ12676234161","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60,201.60","nightly_discount":"0,0","subtotal":"403.20","grand_total":"453.60","paid_amount":"453.60","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1644361894","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":"98362","customer_id":"98362","source_of_creation":"Expedia","reservation_created_date":"2020-02-19 01:37:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"201.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":"3077294","reservation_id":"92882","confirmation_number":"SJ12621518943","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"196.00,196.00","nightly_discount":"0,0","subtotal":"392.00","grand_total":"441.00","paid_amount":"441.00","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1651933639","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":"99043","customer_id":"99043","source_of_creation":"Expedia","reservation_created_date":"2020-03-02 22:59:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"196.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":"3078690","reservation_id":"91615","confirmation_number":"SJ12634777225","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00","nightly_discount":"0,0","subtotal":"430.00","grand_total":"483.75","paid_amount":"483.75","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1638023953","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":"99211","customer_id":"99211","source_of_creation":"Expedia","reservation_created_date":"2020-02-08 22:28:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.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":"3078837","reservation_id":"91957","confirmation_number":"SJ12616643647","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"260,260","nightly_discount":"0,0","subtotal":"520.00","grand_total":"585.00","paid_amount":"585.00","room_type_id":"319","product_id":"1287","siteminder_id":"EXP-1641332849","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99227","customer_id":"99227","source_of_creation":"Expedia","reservation_created_date":"2020-02-14 03:54:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"260","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":"3078867","reservation_id":"93046","confirmation_number":"SJ12636288478","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"170.10,252.00","nightly_discount":"0,0","subtotal":"422.10","grand_total":"474.87","paid_amount":"191.37","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1654304287","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":"99233","customer_id":"99233","source_of_creation":"Expedia","reservation_created_date":"2020-03-07 02:24:09","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","migrated_id":"","currentDayPrice":"170.10","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":"3067635","reservation_id":"91624","confirmation_number":"SJ12687095070","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.09,172.69","nightly_discount":"0,0","subtotal":"328.78","grand_total":"369.88","paid_amount":"369.88","room_type_id":"319","product_id":"1288","siteminder_id":"HTN-118469557-2RLYYA","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":"97762","customer_id":"97762","source_of_creation":"HotelTonight","reservation_created_date":"2020-02-09 02:28:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.69","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3077818","reservation_id":"91457","confirmation_number":"SJ12647056401","room_stay_from":"2020-03-06","room_stay_to":"2020-03-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00,179.00","nightly_discount":"0.00,0.00,0.00","subtotal":"609.00","grand_total":"685.13","paid_amount":"685.13","room_type_id":"413","product_id":"1268","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":"97585","customer_id":"97585","source_of_creation":"FE","reservation_created_date":"2020-02-06 22:20:54","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.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":"3078596","reservation_id":"92707","confirmation_number":"SJ12662042316","room_stay_from":"2020-03-05","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,280.00,280.00,255.00,255.00,255.00,255.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1835.00","grand_total":"2064.38","paid_amount":"2064.38","room_type_id":"319","product_id":"1311","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":"98852","customer_id":"98852","source_of_creation":"FE","reservation_created_date":"2020-02-28 04:13:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3072129","reservation_id":"92280","confirmation_number":"SJ12684781023","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"420.00,420.00","nightly_discount":"0.00,0.00","subtotal":"840.00","grand_total":"945.00","paid_amount":"945.00","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":"98462","customer_id":"98462","source_of_creation":"PMS","reservation_created_date":"2020-02-21 02:03:37","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","migrated_id":"","currentDayPrice":"420.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":"3061652","reservation_id":"90576","confirmation_number":"SJ12694255640","room_stay_from":"2020-03-04","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"179.00,179.00,215.00,215.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"788.00","grand_total":"886.50","paid_amount":"886.50","room_type_id":"413","product_id":"1264","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":"96641","customer_id":"96641","source_of_creation":"PMS","reservation_created_date":"2020-01-25 18:36:03","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.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":"3078058","reservation_id":"92899","confirmation_number":"SJ12658759472","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"280.00,280.00","nightly_discount":"0.00,0.00","subtotal":"560.00","grand_total":"630.00","paid_amount":"630.00","room_type_id":"412","product_id":"1921","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":"99059","customer_id":"99059","source_of_creation":"PMS","reservation_created_date":"2020-03-03 13:16:02","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.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":"3078578","reservation_id":"92677","confirmation_number":"SJ12615761224","room_stay_from":"2020-05-28","room_stay_to":"2020-06-01","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"313.20,313.20,376.20,376.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1378.80","grand_total":"1551.15","paid_amount":"391.50","room_type_id":"320","product_id":"1321","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":"98824","customer_id":"98824","source_of_creation":"PMS","reservation_created_date":"2020-02-27 19:33:04","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3068639","reservation_id":"91759","confirmation_number":"SJ12612193407","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","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":"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":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-11 01:00:18","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3061653","reservation_id":"90576","confirmation_number":"SJ12676537162","room_confirmation_number":"SJ12694255640","room_stay_from":"2020-03-04","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"96641","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-25 18:36:03","reservation_modified_date_time":"2020-01-25 18:36:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96641","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":"3061703","reservation_id":"90585","confirmation_number":"SJ12657966789","room_confirmation_number":"SJ12685831356","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"96652","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-25 20:33:06","reservation_modified_date_time":"2020-01-25 20:33:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96652","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":"3065617","reservation_id":"91185","confirmation_number":"SJ12614578557","room_confirmation_number":"SJ12631952695","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"97309","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-03 18:08:01","reservation_modified_date_time":"2020-02-03 18:08:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97309","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":"3077508","reservation_id":"89659","confirmation_number":"SJ12616656663","room_confirmation_number":"SJ12621022204","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"95643","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-03 20:51:40","reservation_modified_date_time":"2020-03-03 20:51:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95643","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":"3078059","reservation_id":"92899","confirmation_number":"SJ12666502452","room_confirmation_number":"SJ12658759472","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"99059","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-05 20:26:47","reservation_modified_date_time":"2020-03-05 20:26:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99059","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":"3078068","reservation_id":"92535","confirmation_number":"SJ12686524017","room_confirmation_number":"SJ12663346009","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","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":"98697","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-05 21:20:50","reservation_modified_date_time":"2020-03-05 21:20:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98697","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":"3078549","reservation_id":"92009","confirmation_number":"SJ12669592093","room_confirmation_number":"SJ12642654969","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"98173","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-15 19:50:07","reservation_modified_date_time":"2020-03-06 16:37:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98173","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":"3078835","reservation_id":"91957","confirmation_number":"SJ12611876187","room_confirmation_number":"SJ12616643647","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"99227","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-14 03:54:10","reservation_modified_date_time":"2020-03-06 23:38:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99227","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3055199","reservation_id":"86752","confirmation_number":"SJ12661253646","room_confirmation_number":"SJ12617303084","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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":"93421","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-06 16:30:10","reservation_modified_date_time":"2019-11-06 16:30:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93421","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":"3066562","reservation_id":"91430","confirmation_number":"SJ12695586975","room_confirmation_number":"SJ12642163936","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","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":"97559","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 18:53:09","reservation_modified_date_time":"2020-02-06 18:53:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97559","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":"3067636","reservation_id":"91624","confirmation_number":"SJ12623844703","room_confirmation_number":"SJ12687095070","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","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":"97762","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 02:28:05","reservation_modified_date_time":"2020-02-09 02:28:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97762","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":"3068640","reservation_id":"91759","confirmation_number":"SJ12618322882","room_confirmation_number":"SJ12612193407","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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":"96904","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 01:00:18","reservation_modified_date_time":"2020-02-11 01:00:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","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":"3072130","reservation_id":"92280","confirmation_number":"SJ12690761059","room_confirmation_number":"SJ12684781023","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","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":"98462","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 02:03:37","reservation_modified_date_time":"2020-02-21 02:03:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98462","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":"3073920","reservation_id":"92536","confirmation_number":"SJ12695476910","room_confirmation_number":"SJ12636557516","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","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":"98698","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-25 09:21:12","reservation_modified_date_time":"2020-02-25 09:21:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98698","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":"3074666","reservation_id":"91639","confirmation_number":"SJ12681597142","room_confirmation_number":"SJ12664433543","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","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":"97776","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 15:28:10","reservation_modified_date_time":"2020-02-26 16:33:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97776","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":"3074668","reservation_id":"91955","confirmation_number":"SJ12626886177","room_confirmation_number":"SJ12632568471","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","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":"98102","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-14 03:19:10","reservation_modified_date_time":"2020-02-26 16:34:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98102","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":"3076277","reservation_id":"92281","confirmation_number":"SJ12629540195","room_confirmation_number":"SJ12648491434","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","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":"98463","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 02:28:09","reservation_modified_date_time":"2020-02-29 19:06:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98463","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":"3077767","reservation_id":"90494","confirmation_number":"SJ12625949406","room_confirmation_number":"SJ12697251388","room_stay_from":"2020-03-04","room_stay_to":"2020-03-07","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":"96550","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 15:34:11","reservation_modified_date_time":"2020-03-04 20:03:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96550","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":"3077970","reservation_id":"92606","confirmation_number":"SJ12698272259","room_confirmation_number":"SJ12640410314","room_stay_from":"2020-03-04","room_stay_to":"2020-03-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98762","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 17:43:05","reservation_modified_date_time":"2020-03-05 14:38:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98762","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":"3078730","reservation_id":"93039","confirmation_number":"SJ12667904767","room_confirmation_number":"SJ12690630216","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","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":"99217","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-06 22:16:15","reservation_modified_date_time":"2020-03-06 22:16:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99217","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":"3078732","reservation_id":"92199","confirmation_number":"SJ12624780416","room_confirmation_number":"SJ12635887970","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","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":"98385","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-19 16:28:08","reservation_modified_date_time":"2020-03-06 22:23:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98385","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":"3078777","reservation_id":"93040","confirmation_number":"SJ12680853183","room_confirmation_number":"SJ12670767443","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","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":"99220","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-06 23:00:12","reservation_modified_date_time":"2020-03-06 23:00:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99220","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":"3078838","reservation_id":"91634","confirmation_number":"SJ12659286942","room_confirmation_number":"SJ12663383515","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","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":"99228","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 10:34:10","reservation_modified_date_time":"2020-03-06 23:48:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99228","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":"3078843","reservation_id":"93044","confirmation_number":"SJ12614746973","room_confirmation_number":"SJ12651546361","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","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":"99229","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-07 00:04:12","reservation_modified_date_time":"2020-03-07 00:04:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99229","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":"3078878","reservation_id":"92064","confirmation_number":"SJ12687148004","room_confirmation_number":"SJ12620489313","room_stay_from":"2020-03-06","room_stay_to":"2020-03-07","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":"99236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-16 20:54:09","reservation_modified_date_time":"2020-03-07 03:12:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99236","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":"3061654","reservation_id":"90576","confirmation_number":"SJ12631729997","room_confirmation_number":"SJ12694255640","room_stay_from":"2020-03-04","room_stay_to":"2020-03-08","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":"96641","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 18:36:03","reservation_modified_date_time":"2020-01-25 18:36:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96641","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":"3061704","reservation_id":"90585","confirmation_number":"SJ12677730256","room_confirmation_number":"SJ12685831356","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"96652","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 20:33:06","reservation_modified_date_time":"2020-01-25 20:33:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96652","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":"3063435","reservation_id":"90907","confirmation_number":"SJ12691492475","room_confirmation_number":"SJ12651125833","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","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":"97002","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 23:38:09","reservation_modified_date_time":"2020-01-29 23:38:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97002","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":"3064015","reservation_id":"91023","confirmation_number":"SJ12613691427","room_confirmation_number":"SJ12689263523","room_stay_from":"2020-03-03","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"97130","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 01:03:07","reservation_modified_date_time":"2020-02-01 01:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97130","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":"3065618","reservation_id":"91185","confirmation_number":"SJ12645908837","room_confirmation_number":"SJ12631952695","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"28.12,28.12,28.12","nightly_discount":"0.00,0.00,0","subtotal":"84.36","grand_total":"94.90","paid_amount":"94.90","product_id":"1776","service_quantity":"1","customer_traveller_id":"97309","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-02-03 00:44:08","reservation_modified_date_time":"2020-02-03 18:08:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97309","canceled_nights_data":"","currentDayPrice":"28.12","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":"3066439","reservation_id":"91403","confirmation_number":"SJ12659500804","room_confirmation_number":"SJ12628564409","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"97532","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 05:13:10","reservation_modified_date_time":"2020-02-06 05:13:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97532","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":"3067676","reservation_id":"91614","confirmation_number":"SJ12635995311","room_confirmation_number":"SJ12613875844","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"97751","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 22:28:06","reservation_modified_date_time":"2020-02-09 12:10:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97751","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":"3071299","reservation_id":"92178","confirmation_number":"SJ12689133404","room_confirmation_number":"SJ12676234161","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"98362","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-19 01:37:07","reservation_modified_date_time":"2020-02-19 01:37:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98362","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":"3076354","reservation_id":"92786","confirmation_number":"SJ12678286703","room_confirmation_number":"SJ12667691279","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98933","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-29 20:17:08","reservation_modified_date_time":"2020-02-29 20:17:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98933","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":"3077293","reservation_id":"92882","confirmation_number":"SJ12663629417","room_confirmation_number":"SJ12621518943","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"99043","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 22:59:09","reservation_modified_date_time":"2020-03-02 23:32:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99043","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":"3077509","reservation_id":"89659","confirmation_number":"SJ12621558685","room_confirmation_number":"SJ12621022204","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"95643","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-09 20:37:09","reservation_modified_date_time":"2020-03-03 20:51:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95643","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":"3078060","reservation_id":"92899","confirmation_number":"SJ12680916668","room_confirmation_number":"SJ12658759472","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"99059","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-03 13:16:02","reservation_modified_date_time":"2020-03-05 20:26:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99059","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":"3078064","reservation_id":"92912","confirmation_number":"SJ12615174751","room_confirmation_number":"SJ12642098072","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"99068","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-03 17:16:08","reservation_modified_date_time":"2020-03-05 21:12:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99068","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":"3078069","reservation_id":"92535","confirmation_number":"SJ12690470775","room_confirmation_number":"SJ12663346009","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","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":"98697","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-25 09:21:08","reservation_modified_date_time":"2020-03-05 21:20:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98697","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":"3078550","reservation_id":"92009","confirmation_number":"SJ12615554944","room_confirmation_number":"SJ12642654969","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"98173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-15 19:50:07","reservation_modified_date_time":"2020-03-06 16:37:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98173","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":"3078678","reservation_id":"92029","confirmation_number":"SJ12643151180","room_confirmation_number":"SJ12682213094","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"99207","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-16 04:04:11","reservation_modified_date_time":"2020-03-06 19:54:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99207","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":"3078689","reservation_id":"91615","confirmation_number":"SJ12663705213","room_confirmation_number":"SJ12634777225","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"99211","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 22:28:11","reservation_modified_date_time":"2020-03-06 20:25:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99211","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":"3078836","reservation_id":"91957","confirmation_number":"SJ12642938104","room_confirmation_number":"SJ12616643647","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"99227","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-14 03:54:10","reservation_modified_date_time":"2020-03-06 23:38:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99227","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":"3078868","reservation_id":"93046","confirmation_number":"SJ12671288624","room_confirmation_number":"SJ12636288478","room_stay_from":"2020-03-06","room_stay_to":"2020-03-08","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99233","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-07 02:24:09","reservation_modified_date_time":"2020-03-07 02:24:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99233","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":"3077819","reservation_id":"91457","confirmation_number":"SJ12646036829","room_confirmation_number":"SJ12647056401","room_stay_from":"2020-03-06","room_stay_to":"2020-03-09","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":"97585","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 22:20:54","reservation_modified_date_time":"2020-03-04 22:28:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97585","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":"3078598","reservation_id":"92707","confirmation_number":"SJ12630565147","room_confirmation_number":"SJ12662042316","room_stay_from":"2020-03-05","room_stay_to":"2020-03-12","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":"98852","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 04:13:14","reservation_modified_date_time":"2020-03-06 17:12:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98852","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":"3078581","reservation_id":"92677","confirmation_number":"SJ12686138769","room_confirmation_number":"SJ12615761224","room_stay_from":"2020-05-28","room_stay_to":"2020-06-01","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 19:33:04","reservation_modified_date_time":"2020-03-06 16:49:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98824","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3078829","reservation_id":"92426","confirmation_number":"SJ12666268499","room_confirmation_number":"SJ12681234262","room_stay_from":"2020-03-24","room_stay_to":"2020-03-25","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98601","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-23 17:21:09","reservation_modified_date_time":"2020-03-06 23:30:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98601","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3078602","reservation_id":"92195","confirmation_number":"SJ12616558644","room_confirmation_number":"SJ12655913785","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1710","service_quantity":"1","product_name":"Late Departure Check-Out","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-06 17:28:09","reservation_modified_date_time":"2020-03-06 17:28:09","customer_id":"98382","parentCustTravId":"98382","customer_traveller_id":"98382","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]},{"room_stay_id":"3078641","reservation_id":"92195","confirmation_number":"SJ12643593459","room_confirmation_number":"SJ12655913785","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1710","service_quantity":"1","product_name":"Late Departure Check-Out","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-06 18:15:04","reservation_modified_date_time":"2020-03-06 18:15:04","customer_id":"98382","parentCustTravId":"98382","customer_traveller_id":"98382","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]},{"room_stay_id":"3078833","reservation_id":"90494","confirmation_number":"SJ12695377529","room_confirmation_number":"SJ12697251388","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.88","paid_amount":"26.88","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-06 23:33:38","reservation_modified_date_time":"2020-03-06 23:33:38","customer_id":"96550","parentCustTravId":"96550","customer_traveller_id":"96550","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3078884","reservation_id":"93050","confirmation_number":"SJ12664475118","room_confirmation_number":"SJ12622845613","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-07 03:43:33","reservation_modified_date_time":"2020-03-07 03:43:33","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.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}