{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-12-26","total_rooms_exist":63,"departureCount":6,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"13","block_room_bookings":[],"bundle_block_count":"10","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3044258","reservation_id":"87822","confirmation_number":"SJ12681365226","room_stay_from":"2019-12-23","room_stay_to":"2019-12-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,359.00","nightly_discount":"0,0,0,0","subtotal":"1352.60","grand_total":"1521.68","paid_amount":"1521.68","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3165248506","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":"94262","customer_id":"94262","source_of_creation":"Booking.com","reservation_created_date":"2019-12-03 22:40:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"243.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"359.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":"3047702","reservation_id":"88185","confirmation_number":"SJ12652725035","room_stay_from":"2019-12-26","room_stay_to":"2019-12-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"404.00","nightly_discount":"0","subtotal":"404.00","grand_total":"454.50","paid_amount":"454.50","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2361764540","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":"94505","customer_id":"94505","source_of_creation":"Booking.com","reservation_created_date":"2019-12-12 01:17:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"72.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"404.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":"3049993","reservation_id":"88389","confirmation_number":"SJ12675830518","room_stay_from":"2019-12-26","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"419,414","nightly_discount":"0,0","subtotal":"833.00","grand_total":"937.13","paid_amount":"937.13","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-3675036651","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":"94621","customer_id":"94621","source_of_creation":"Booking.com","reservation_created_date":"2019-12-16 18:01:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"299.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"419","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":"3049997","reservation_id":"88389","confirmation_number":"SJ12668699663","room_stay_from":"2019-12-26","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"369.00,414.00","nightly_discount":"0,0","subtotal":"783.00","grand_total":"880.88","paid_amount":"880.88","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3675036651","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94621","customer_id":"94621","source_of_creation":"Booking.com","reservation_created_date":"2019-12-16 18:01:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"299.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"369.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":"3050768","reservation_id":"87877","confirmation_number":"SJ12624442930","room_stay_from":"2019-12-26","room_stay_to":"2019-12-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"332.10,372.60,372.60","nightly_discount":"0,0,0","subtotal":"1077.30","grand_total":"1211.97","paid_amount":"1211.97","room_type_id":"319","product_id":"1307","siteminder_id":"BDC-2274247261","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":"94309","customer_id":"94309","source_of_creation":"Booking.com","reservation_created_date":"2019-12-05 15:16:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"387.83","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"332.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"}]},{"room_stay_id":"3050772","reservation_id":"87877","confirmation_number":"SJ12642382218","room_stay_from":"2019-12-26","room_stay_to":"2019-12-29","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"332.10,372.60,372.60","nightly_discount":"0,0,0","subtotal":"1077.30","grand_total":"1211.97","paid_amount":"1211.97","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-2274247261","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":"94309","customer_id":"94309","source_of_creation":"Booking.com","reservation_created_date":"2019-12-05 15:16:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"387.83","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"332.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2994764","reservation_id":"80077","confirmation_number":"SJ12652491809","room_stay_from":"2019-12-25","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"303.24,318.44,371.64","nightly_discount":"0,0,0","subtotal":"993.32","grand_total":"1117.49","paid_amount":"1117.49","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1291209635","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88500","customer_id":"88500","source_of_creation":"Expedia","reservation_created_date":"2019-07-03 00:33:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"318.44","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":"3040266","reservation_id":"87390","confirmation_number":"SJ12678775750","room_stay_from":"2019-12-26","room_stay_to":"2019-12-27","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"343.20","nightly_discount":"0","subtotal":"343.20","grand_total":"386.10","paid_amount":"386.10","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1384191076","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93937","customer_id":"93937","source_of_creation":"Expedia","reservation_created_date":"2019-11-21 20:08:05","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":"343.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":"3042039","reservation_id":"87078","confirmation_number":"SJ12632913282","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"271.20,271.20,271.20,287.20,343.20","nightly_discount":"0,0,0,0,0","subtotal":"1444.00","grand_total":"1624.50","paid_amount":"1624.50","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1379419406","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":"93662","customer_id":"93662","source_of_creation":"Expedia","reservation_created_date":"2019-11-13 02:15:12","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":"287.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":"3042129","reservation_id":"87580","confirmation_number":"SJ12624460058","room_stay_from":"2019-12-26","room_stay_to":"2019-12-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"291.84,345.04,345.04,337.44","nightly_discount":"0,0,0,0","subtotal":"1319.36","grand_total":"1484.28","paid_amount":"1484.28","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1386183592","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":"94087","customer_id":"94087","source_of_creation":"Expedia","reservation_created_date":"2019-11-28 03:52:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"291.84","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":"3042346","reservation_id":"87077","confirmation_number":"SJ12640846626","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"271.20,271.20,271.20,287.20,343.20","nightly_discount":"0,0,0,0,0","subtotal":"1444.00","grand_total":"1624.50","paid_amount":"1624.50","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1379419409","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":"93661","customer_id":"93661","source_of_creation":"Expedia","reservation_created_date":"2019-11-13 02:15:09","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":"287.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":"3045239","reservation_id":"87997","confirmation_number":"SJ12660808085","room_stay_from":"2019-12-24","room_stay_to":"2019-12-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"257.64,257.64,272.84,326.04,326.04","nightly_discount":"0,0,0,0,0","subtotal":"1440.20","grand_total":"1620.23","paid_amount":"1620.23","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1388933764","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":"94371","customer_id":"94371","source_of_creation":"Expedia","reservation_created_date":"2019-12-07 18:48:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"272.84","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":"3049811","reservation_id":"83658","confirmation_number":"SJ12669648447","room_stay_from":"2019-12-23","room_stay_to":"2019-12-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"355.30,355.30,355.30,374.30,440.80,440.80,431.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2753.10","grand_total":"3097.24","paid_amount":"3097.24","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1336599694","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":"91046","customer_id":"91046","source_of_creation":"Expedia","reservation_created_date":"2019-09-05 17:47:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"374.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3050212","reservation_id":"87894","confirmation_number":"SJ12649384064","room_stay_from":"2019-12-25","room_stay_to":"2019-12-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.55,350.55,417.05,417.05","nightly_discount":"0,0,0,0","subtotal":"1516.20","grand_total":"1705.73","paid_amount":"1705.73","room_type_id":"319","product_id":"1302","siteminder_id":"EXP-1604582408","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":"94323","customer_id":"94323","source_of_creation":"Expedia","reservation_created_date":"2019-12-05 21:08:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"350.55","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":"3050398","reservation_id":"88377","confirmation_number":"SJ12681696842","room_stay_from":"2019-12-26","room_stay_to":"2019-12-27","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"315.20","nightly_discount":"0","subtotal":"315.20","grand_total":"354.60","paid_amount":"354.60","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1608290949","collect_which":"channel_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":"94614","customer_id":"94614","source_of_creation":"Expedia","reservation_created_date":"2019-12-16 05:07:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"315.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":"3050409","reservation_id":"88376","confirmation_number":"SJ12684130976","room_stay_from":"2019-12-26","room_stay_to":"2019-12-27","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"315.20","nightly_discount":"0","subtotal":"315.20","grand_total":"354.60","paid_amount":"354.60","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1608290950","collect_which":"channel_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":"94613","customer_id":"94613","source_of_creation":"Expedia","reservation_created_date":"2019-12-16 05:07:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"315.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":"3050439","reservation_id":"88562","confirmation_number":"SJ12689898856","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.24,189.24,181.64,350.00,350.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1260.12","grand_total":"1417.64","paid_amount":"1417.64","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1611263306","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":"94760","customer_id":"94760","source_of_creation":"Expedia","reservation_created_date":"2019-12-22 21:07:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"350.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":"3050459","reservation_id":"88205","confirmation_number":"SJ12621591981","room_stay_from":"2019-12-26","room_stay_to":"2019-12-29","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"369.00,439.00,439.00","nightly_discount":"0.00,0.00,0.00","subtotal":"1247.00","grand_total":"1402.88","paid_amount":"1402.88","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1606761416","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":"94524","customer_id":"94524","source_of_creation":"Expedia","reservation_created_date":"2019-12-12 19:07:06","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":"369.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":"3050708","reservation_id":"85993","confirmation_number":"SJ12651218094","room_stay_from":"2019-12-26","room_stay_to":"2019-12-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"369.00,439.00,439.00,439.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1686.00","grand_total":"1896.75","paid_amount":"1896.75","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1365288150","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":"92889","customer_id":"92889","source_of_creation":"Expedia","reservation_created_date":"2019-10-20 16:56:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"369.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":"3050799","reservation_id":"88733","confirmation_number":"SJ12677858226","room_stay_from":"2019-12-26","room_stay_to":"2019-12-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.04","nightly_discount":"0","subtotal":"288.04","grand_total":"324.04","paid_amount":"324.04","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1612827716","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":"94892","customer_id":"94892","source_of_creation":"Expedia","reservation_created_date":"2019-12-26 19:47:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"288.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3050904","reservation_id":"87224","confirmation_number":"SJ12656630165","room_stay_from":"2019-12-26","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"308.88,359.28","nightly_discount":"0.00,0.00","subtotal":"668.16","grand_total":"751.68","paid_amount":"751.68","room_type_id":"319","product_id":"1304","siteminder_id":"EXP-1381513648","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93789","customer_id":"93789","source_of_creation":"Expedia","reservation_created_date":"2019-11-16 20:48:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"308.88","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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3048980","reservation_id":"85941","confirmation_number":"SJ12667002640","room_stay_from":"2019-12-23","room_stay_to":"2019-12-27","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"351.58,351.58,351.58,351.58","nightly_discount":"0,0,0,0","subtotal":"1406.32","grand_total":"1864.14","paid_amount":"1864.14","room_type_id":"413","product_id":"1263","siteminder_id":"ABB-HMAB8KCHBN","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"1406.32","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92865","customer_id":"92865","source_of_creation":"Airbnb","reservation_created_date":"2019-10-19 17:22:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 209","ota_service_fee_amount":"213.62","commision_charges":"49.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"351.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3043387","reservation_id":"87587","confirmation_number":"SJ12658958891","room_stay_from":"2019-12-25","room_stay_to":"2019-12-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"339.00,339.00,339.00,359.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1376.00","grand_total":"1548.00","paid_amount":"1548.00","room_type_id":"413","product_id":"1267","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":"94093","customer_id":"94093","source_of_creation":"FE","reservation_created_date":"2019-11-28 13:53:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"339.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":"3044084","reservation_id":"85102","confirmation_number":"SJ12614535110","room_stay_from":"2019-12-25","room_stay_to":"2019-12-29","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"339.00,359.00,429.00,429.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1556.00","grand_total":"1750.50","paid_amount":"1750.50","room_type_id":"413","product_id":"1273","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":"92298","customer_id":"92298","source_of_creation":"FE","reservation_created_date":"2019-10-04 13:11:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"359.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":"3044090","reservation_id":"87327","confirmation_number":"SJ12611989594","room_stay_from":"2019-12-26","room_stay_to":"2019-12-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"359.00,429.00,429.00","nightly_discount":"0.00,0.00,0.00","subtotal":"1217.00","grand_total":"1369.13","paid_amount":"1369.13","room_type_id":"413","product_id":"1265","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":"93881","customer_id":"93881","source_of_creation":"FE","reservation_created_date":"2019-11-19 20:13:29","canceled_nights_data":"","product_name":"Deluxe 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":"359.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":"3019292","reservation_id":"84095","confirmation_number":"SJ12632427332","room_stay_from":"2019-12-25","room_stay_to":"2019-12-30","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"339.00,359.00,429.00,429.00,419.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1975.00","grand_total":"2221.88","paid_amount":"2221.88","room_type_id":"319","product_id":"1305","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":"91612","customer_id":"91612","source_of_creation":"PMS","reservation_created_date":"2019-09-14 19:52:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"359.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3043527","reservation_id":"87758","confirmation_number":"SJ12680317762","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-02 14:05:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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"}]},{"room_stay_id":"3043529","reservation_id":"87759","confirmation_number":"SJ12655944302","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-02 14:07:31","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3043531","reservation_id":"87760","confirmation_number":"SJ12683116504","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1278","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-02 14:09:01","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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"}]},{"room_stay_id":"3051091","reservation_id":"87757","confirmation_number":"SJ12664033587","room_stay_from":"2019-12-21","room_stay_to":"2019-12-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-02 14:03:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3050659","reservation_id":"87756","confirmation_number":"SJ12660406277","room_stay_from":"2019-12-19","room_stay_to":"2019-12-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-02 14:01:33","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":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3063031","reservation_id":"87869","confirmation_number":"SJ12646968853","room_stay_from":"2019-12-26","room_stay_to":"2019-12-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"920.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"920.00","grand_total":"1035.00","paid_amount":"1035.00","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-12-05 04:51:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"920.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3052053","reservation_id":"88229","confirmation_number":"SJ12631190009","room_stay_from":"2019-12-25","room_stay_to":"2019-12-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,184.00,184.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"920.00","grand_total":"920.00","paid_amount":"920.00","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-12-13 02:14:04","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":"184.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063033","reservation_id":"87870","confirmation_number":"SJ12611544100","room_stay_from":"2019-12-26","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,184.00,184.00,184.00,184","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"920.00","grand_total":"920.00","paid_amount":"920.00","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-12-05 05:04:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184.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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3019293","reservation_id":"84095","confirmation_number":"SJ12637654971","room_confirmation_number":"SJ12632427332","room_stay_from":"2019-12-25","room_stay_to":"2019-12-30","room_stay_status":"Active","nightly_price":"50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"91612","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-09-14 19:52:16","reservation_modified_date_time":"2019-09-14 19:52:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91612","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":"3044085","reservation_id":"85102","confirmation_number":"SJ12670869343","room_confirmation_number":"SJ12614535110","room_stay_from":"2019-12-25","room_stay_to":"2019-12-29","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":"92298","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-12-05 00:45:47","reservation_modified_date_time":"2019-12-05 00:45:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92298","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":"3048983","reservation_id":"85941","confirmation_number":"SJ12684293024","room_confirmation_number":"SJ12667002640","room_stay_from":"2019-12-23","room_stay_to":"2019-12-27","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"210.00","paid_amount":"210.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"92865","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-12-20 21:39:36","reservation_modified_date_time":"2019-12-20 21:39:36","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92865","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3049995","reservation_id":"88389","confirmation_number":"SJ12648965528","room_confirmation_number":"SJ12675830518","room_stay_from":"2019-12-26","room_stay_to":"2019-12-28","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"94621","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-12-24 16:45:10","reservation_modified_date_time":"2019-12-24 16:45:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94621","canceled_nights_data":"","currentDayPrice":"50","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":"3050460","reservation_id":"88205","confirmation_number":"SJ12637901271","room_confirmation_number":"SJ12621591981","room_stay_from":"2019-12-26","room_stay_to":"2019-12-29","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"94524","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-12-25 21:49:12","reservation_modified_date_time":"2019-12-25 21:49:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94524","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2994766","reservation_id":"80077","confirmation_number":"SJ12662036519","room_confirmation_number":"SJ12652491809","room_stay_from":"2019-12-25","room_stay_to":"2019-12-28","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":"88500","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-03 00:33:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88500","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":"3019294","reservation_id":"84095","confirmation_number":"SJ12690891729","room_confirmation_number":"SJ12632427332","room_stay_from":"2019-12-25","room_stay_to":"2019-12-30","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":"91612","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-14 19:52:16","reservation_modified_date_time":"2019-09-14 19:52:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91612","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":"3040268","reservation_id":"87390","confirmation_number":"SJ12697145291","room_confirmation_number":"SJ12678775750","room_stay_from":"2019-12-26","room_stay_to":"2019-12-27","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":"93937","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-21 20:08:05","reservation_modified_date_time":"2019-11-21 20:08:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93937","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":"3042040","reservation_id":"87078","confirmation_number":"SJ12638731320","room_confirmation_number":"SJ12632913282","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","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":"93662","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-13 02:15:12","reservation_modified_date_time":"2019-11-13 02:15:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93662","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":"3042130","reservation_id":"87580","confirmation_number":"SJ12614151167","room_confirmation_number":"SJ12624460058","room_stay_from":"2019-12-26","room_stay_to":"2019-12-30","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":"94087","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-28 03:52:10","reservation_modified_date_time":"2019-11-28 03:52:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94087","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":"3042347","reservation_id":"87077","confirmation_number":"SJ12687541918","room_confirmation_number":"SJ12640846626","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","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":"93661","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-13 02:15:09","reservation_modified_date_time":"2019-11-13 02:15:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93661","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":"3043389","reservation_id":"87587","confirmation_number":"SJ12690077260","room_confirmation_number":"SJ12658958891","room_stay_from":"2019-12-25","room_stay_to":"2019-12-29","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":"94093","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-28 13:53:16","reservation_modified_date_time":"2019-11-28 13:53:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94093","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":"3043528","reservation_id":"87758","confirmation_number":"SJ12637863261","room_confirmation_number":"SJ12680317762","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","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":"94202","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-02 14:05:24","reservation_modified_date_time":"2019-12-02 14:05:24","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3043530","reservation_id":"87759","confirmation_number":"SJ12635413580","room_confirmation_number":"SJ12655944302","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","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":"94203","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-02 14:07:31","reservation_modified_date_time":"2019-12-02 14:07:31","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3043532","reservation_id":"87760","confirmation_number":"SJ12612581355","room_confirmation_number":"SJ12683116504","room_stay_from":"2019-12-21","room_stay_to":"2019-12-28","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":"94204","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-02 14:09:01","reservation_modified_date_time":"2019-12-02 14:09:01","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3044086","reservation_id":"85102","confirmation_number":"SJ12626065023","room_confirmation_number":"SJ12614535110","room_stay_from":"2019-12-25","room_stay_to":"2019-12-29","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":"92298","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-04 13:11:05","reservation_modified_date_time":"2019-10-04 13:11:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92298","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":"3044091","reservation_id":"87327","confirmation_number":"SJ12670174004","room_confirmation_number":"SJ12611989594","room_stay_from":"2019-12-26","room_stay_to":"2019-12-29","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":"93881","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-19 20:13:29","reservation_modified_date_time":"2019-11-19 20:13:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93881","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":"3044259","reservation_id":"87822","confirmation_number":"SJ12641854105","room_confirmation_number":"SJ12681365226","room_stay_from":"2019-12-23","room_stay_to":"2019-12-27","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":"94262","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-03 22:40:11","reservation_modified_date_time":"2019-12-03 22:40:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94262","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":"3045241","reservation_id":"87997","confirmation_number":"SJ12626227399","room_confirmation_number":"SJ12660808085","room_stay_from":"2019-12-24","room_stay_to":"2019-12-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"94371","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-07 18:48:09","reservation_modified_date_time":"2019-12-07 18:48:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94371","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":"3047704","reservation_id":"88185","confirmation_number":"SJ12623405797","room_confirmation_number":"SJ12652725035","room_stay_from":"2019-12-26","room_stay_to":"2019-12-27","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":"94505","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-12 01:17:07","reservation_modified_date_time":"2019-12-12 01:17:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94505","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":"3048984","reservation_id":"85941","confirmation_number":"SJ12630088516","room_confirmation_number":"SJ12667002640","room_stay_from":"2019-12-23","room_stay_to":"2019-12-27","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":"92865","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-19 17:22:08","reservation_modified_date_time":"2019-10-19 17:22:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92865","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3049812","reservation_id":"83658","confirmation_number":"SJ12629013572","room_confirmation_number":"SJ12669648447","room_stay_from":"2019-12-23","room_stay_to":"2019-12-30","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":"91046","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-05 17:47:11","reservation_modified_date_time":"2019-09-05 17:47:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91046","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":"3049996","reservation_id":"88389","confirmation_number":"SJ12656349741","room_confirmation_number":"SJ12675830518","room_stay_from":"2019-12-26","room_stay_to":"2019-12-28","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":"94621","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-16 18:01:09","reservation_modified_date_time":"2019-12-16 18:01:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94621","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":"3049998","reservation_id":"88389","confirmation_number":"SJ12664198026","room_confirmation_number":"SJ12668699663","room_stay_from":"2019-12-26","room_stay_to":"2019-12-28","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":"94621","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-16 18:01:14","reservation_modified_date_time":"2019-12-16 18:01:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94621","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":"3050214","reservation_id":"87894","confirmation_number":"SJ12636422421","room_confirmation_number":"SJ12649384064","room_stay_from":"2019-12-25","room_stay_to":"2019-12-29","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":"94323","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-05 21:08:09","reservation_modified_date_time":"2019-12-05 21:08:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94323","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":"3050401","reservation_id":"88377","confirmation_number":"SJ12633937222","room_confirmation_number":"SJ12681696842","room_stay_from":"2019-12-26","room_stay_to":"2019-12-27","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":"94614","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-16 05:07:12","reservation_modified_date_time":"2019-12-16 05:07:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94614","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":"3050411","reservation_id":"88376","confirmation_number":"SJ12688994909","room_confirmation_number":"SJ12684130976","room_stay_from":"2019-12-26","room_stay_to":"2019-12-27","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":"94613","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-16 05:07:10","reservation_modified_date_time":"2019-12-16 05:07:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94613","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":"3050441","reservation_id":"88562","confirmation_number":"SJ12660353055","room_confirmation_number":"SJ12689898856","room_stay_from":"2019-12-23","room_stay_to":"2019-12-28","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":"94760","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-22 21:07:09","reservation_modified_date_time":"2019-12-25 21:43:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94760","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":"3050461","reservation_id":"88205","confirmation_number":"SJ12698062497","room_confirmation_number":"SJ12621591981","room_stay_from":"2019-12-26","room_stay_to":"2019-12-29","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":"94524","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-12 19:07:06","reservation_modified_date_time":"2019-12-12 19:27:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94524","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":"3050710","reservation_id":"85993","confirmation_number":"SJ12632923513","room_confirmation_number":"SJ12651218094","room_stay_from":"2019-12-26","room_stay_to":"2019-12-30","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":"92889","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-20 16:56:11","reservation_modified_date_time":"2019-12-26 17:41:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92889","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":"3050771","reservation_id":"87877","confirmation_number":"SJ12623387202","room_confirmation_number":"SJ12624442930","room_stay_from":"2019-12-26","room_stay_to":"2019-12-29","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":"94309","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-05 15:16:08","reservation_modified_date_time":"2019-12-05 15:16:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94309","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":"3050773","reservation_id":"87877","confirmation_number":"SJ12616039997","room_confirmation_number":"SJ12642382218","room_stay_from":"2019-12-26","room_stay_to":"2019-12-29","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":"94309","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-05 15:16:12","reservation_modified_date_time":"2019-12-05 15:16:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94309","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":"3050800","reservation_id":"88733","confirmation_number":"SJ12627198673","room_confirmation_number":"SJ12677858226","room_stay_from":"2019-12-26","room_stay_to":"2019-12-27","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":"94892","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-26 19:47:07","reservation_modified_date_time":"2019-12-26 19:47:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94892","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":"3050906","reservation_id":"87224","confirmation_number":"SJ12649141466","room_confirmation_number":"SJ12656630165","room_stay_from":"2019-12-26","room_stay_to":"2019-12-28","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":"93789","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-16 20:48:10","reservation_modified_date_time":"2019-12-26 22:51:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93789","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":"3051092","reservation_id":"87757","confirmation_number":"SJ12615523774","room_confirmation_number":"SJ12664033587","room_stay_from":"2019-12-21","room_stay_to":"2019-12-27","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"94201","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-02 14:03:53","reservation_modified_date_time":"2019-12-02 14:03:53","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3052054","reservation_id":"88229","confirmation_number":"SJ12691027909","room_confirmation_number":"SJ12631190009","room_stay_from":"2019-12-25","room_stay_to":"2019-12-30","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":"94538","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-13 02:14:04","reservation_modified_date_time":"2019-12-30 15:57:50","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3063032","reservation_id":"87869","confirmation_number":"SJ12687815058","room_confirmation_number":"SJ12646968853","room_stay_from":"2019-12-26","room_stay_to":"2019-12-30","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":"94304","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-05 04:51:58","reservation_modified_date_time":"2020-01-29 12:49:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82465","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":"3063035","reservation_id":"87870","confirmation_number":"SJ12638569317","room_confirmation_number":"SJ12611544100","room_stay_from":"2019-12-26","room_stay_to":"2019-12-31","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":"94305","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-05 05:04:14","reservation_modified_date_time":"2020-01-29 12:50:37","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3050793","reservation_id":"88731","confirmation_number":"SJ12687567382","room_confirmation_number":"SJ12620671063","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"29.99","grand_total":"32.24","paid_amount":"32.24","product_id":null,"service_quantity":"1","product_name":"Beach Buggy package","parentTypeOfRes":"reservation","reservation_created_date":"2019-12-26 19:43:42","reservation_modified_date_time":"2019-12-26 19:43:42","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"29.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3050794","reservation_id":"88731","confirmation_number":"SJ12643054301","room_confirmation_number":"SJ12620671063","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"7.50","paid_amount":"7.50","product_id":null,"service_quantity":"3","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2019-12-26 19:43:42","reservation_modified_date_time":"2019-12-26 19:43:42","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"6.99","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":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}