{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-07-21","total_rooms_exist":"1281,1282,1289,1274,1275,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":6,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1307,1943","block_room_bookings":[{"confirmation_number":"SJ12676533150","room_stay_from":"2020-07-11","room_stay_to":"2020-07-25","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-09-01","bundle_room":"0"}],"bundle_block_count":"1311,1312,1267,1268,1262,1263,1269,1270,1260,1261,1271,1272,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12631795255","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","bundle_room":"1"},{"confirmation_number":"SJB12645599732","room_stay_from":"2020-07-20","room_stay_to":"2020-07-22","bundle_room":"1"},{"confirmation_number":"SJB12649311128","room_stay_from":"2020-07-21","room_stay_to":"2020-07-22","bundle_room":"1"},{"confirmation_number":"SJB12658964183","room_stay_from":"2020-07-19","room_stay_to":"2020-07-23","bundle_room":"1"},{"confirmation_number":"SJB12685383857","room_stay_from":"2020-07-21","room_stay_to":"2020-07-24","bundle_room":"1"},{"confirmation_number":"SJB12644285903","room_stay_from":"2020-07-21","room_stay_to":"2020-07-24","bundle_room":"1"},{"confirmation_number":"SJB12655768163","room_stay_from":"2020-07-21","room_stay_to":"2020-07-25","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3116713","reservation_id":"95818","confirmation_number":"SJ12674482855","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"149.2,149.2,122,122,93.2","nightly_discount":"0,0,0,0,0","subtotal":"635.60","grand_total":"715.05","paid_amount":"715.05","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-2549320888","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"250.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101975","customer_id":"101975","source_of_creation":"Booking.com","reservation_created_date":"2020-06-02 18:44:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"181.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"93.2","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":"3116277","reservation_id":"95219","confirmation_number":"SJ12664576909","room_stay_from":"2020-07-17","room_stay_to":"2020-07-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.20,155.20,134.40,134.40,134.40,134.40","nightly_discount":"0,0,0,0,0,0","subtotal":"848.00","grand_total":"954.00","paid_amount":"954.00","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1665273433","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":"101401","customer_id":"101401","source_of_creation":"Expedia","reservation_created_date":"2020-05-22 00:22:11","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":"134.40","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":"3116717","reservation_id":"97806","confirmation_number":"SJ12682290535","room_stay_from":"2020-07-18","room_stay_to":"2020-07-23","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"205.44,139.52,139.52,139.52,139.52","nightly_discount":"0,0,0,0,0","subtotal":"763.52","grand_total":"858.96","paid_amount":"858.96","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1679905036","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":"103878","customer_id":"103878","source_of_creation":"Expedia","reservation_created_date":"2020-07-16 01:18:08","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":"139.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3094653","reservation_id":"94921","confirmation_number":"SJ12633883298","room_stay_from":"2020-07-21","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.56,82.56,82.56","nightly_discount":"0,0,0","subtotal":"247.68","grand_total":"278.64","paid_amount":"278.64","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1664551350","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":"101112","customer_id":"101112","source_of_creation":"Expedia","reservation_created_date":"2020-05-17 22:41:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117461","reservation_id":"95005","confirmation_number":"SJ12696624914","room_stay_from":"2020-07-17","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.36,95.36,82.56,82.56,82.56,82.56,82.56,95.36","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"698.88","grand_total":"786.24","paid_amount":"786.24","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1664737254","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":"101198","customer_id":"101198","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 00:37:09","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":"82.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"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":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3112999","reservation_id":"96085","confirmation_number":"SJ12661380581","room_stay_from":"2020-07-18","room_stay_to":"2020-07-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.44,174.89,174.89,145.76","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"698.98","grand_total":"786.35","paid_amount":"786.35","room_type_id":"319","product_id":"1915","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":"102209","customer_id":"102209","source_of_creation":"FE","reservation_created_date":"2020-06-08 02:14:30","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":"145.76","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":"3117895","reservation_id":"95157","confirmation_number":"SJ12679746112","room_stay_from":"2020-07-20","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.55,122.55,142.55,142.55,142.55","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"672.75","grand_total":"756.85","paid_amount":"756.85","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":"86804","customer_id":"86804","source_of_creation":"FE","reservation_created_date":"2020-05-20 21:36:34","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":"122.55","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":"3118037","reservation_id":"97241","confirmation_number":"SJ12622696882","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"290.00,290.00,225.00,225.00,225.00","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"1255.00","grand_total":"1411.88","paid_amount":"1158.75","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103342","customer_id":"103342","source_of_creation":"PMS","reservation_created_date":"2020-06-30 14:42:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"225.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":"3118373","reservation_id":"97988","confirmation_number":"SJ12656858715","room_stay_from":"2020-07-20","room_stay_to":"2020-07-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.12,125.12","nightly_discount":"0.00,0.00","subtotal":"250.24","grand_total":"281.52","paid_amount":"281.52","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104056","customer_id":"104056","source_of_creation":"PMS","reservation_created_date":"2020-07-20 21:31:56","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"125.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":"3118128","reservation_id":"96038","confirmation_number":"SJ12629265738","room_stay_from":"2020-07-20","room_stay_to":"2020-07-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"178.50,178.50,178.50","nightly_discount":"19.38,19.38,19.38","subtotal":"535.50","grand_total":"537.03","paid_amount":"537.03","room_type_id":"319","product_id":"1916","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":"99511","customer_id":"99511","source_of_creation":"PMS","reservation_created_date":"2020-06-07 14:34:20","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":"178.50","currentDayDiscount":"19.38","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118136","reservation_id":"97343","confirmation_number":"SJ12628885770","room_stay_from":"2020-07-20","room_stay_to":"2020-07-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.50,178.50,178.50","nightly_discount":"19.38,19.38,19.38","subtotal":"535.50","grand_total":"537.03","paid_amount":"537.03","room_type_id":"319","product_id":"1286","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":"99511","customer_id":"99511","source_of_creation":"PMS","reservation_created_date":"2020-07-03 16:40:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"178.50","currentDayDiscount":"19.38","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113861","reservation_id":"97543","confirmation_number":"SJ12612018357","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00,111.75,111.75,111.75,111.75,111.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"988.75","grand_total":"1112.35","paid_amount":"1112.35","room_type_id":"413","product_id":"1271","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":"103616","customer_id":"103616","source_of_creation":"PMS","reservation_created_date":"2020-07-08 18:07:25","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":"111.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118453","reservation_id":"95503","confirmation_number":"SJ12673054340","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.27","nightly_discount":"0.00","subtotal":"149.27","grand_total":"167.93","paid_amount":"167.93","room_type_id":"319","product_id":"1288","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":"101691","customer_id":"101691","source_of_creation":"PMS","reservation_created_date":"2020-05-27 19:14:01","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":"","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":"3116730","reservation_id":"97429","confirmation_number":"SJ12665901478","room_stay_from":"2020-07-18","room_stay_to":"2020-07-25","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":"413","product_id":"1269","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":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-07-06 01:13:22","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":"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":[{"room_stay_id":"3109865","reservation_id":"97090","confirmation_number":"SJ12623685175","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1756","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":"2020-06-26 00:13:36","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":"77.86","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":"3109867","reservation_id":"97091","confirmation_number":"SJ12693369595","room_stay_from":"2020-07-19","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"140.63","room_type_id":"413","product_id":"1273","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":"2020-06-26 00:16:16","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":"78.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":"3112155","reservation_id":"96853","confirmation_number":"SJ12673840595","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-20 02:23:05","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":"77.86","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":"3116715","reservation_id":"95818","confirmation_number":"SJ12654664350","room_confirmation_number":"SJ12674482855","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","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":"101975","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-17 01:07:03","reservation_modified_date_time":"2020-07-17 01:07:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101975","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.00","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":"3113000","reservation_id":"96085","confirmation_number":"SJ12668349350","room_confirmation_number":"SJ12661380581","room_stay_from":"2020-07-18","room_stay_to":"2020-07-22","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":"102209","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 02:14:30","reservation_modified_date_time":"2020-07-06 01:10:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102209","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3116716","reservation_id":"95818","confirmation_number":"SJ12685564347","room_confirmation_number":"SJ12674482855","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"101975","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-02 18:44:12","reservation_modified_date_time":"2020-07-17 01:07:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101975","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.00","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":"3118038","reservation_id":"97241","confirmation_number":"SJ12646842239","room_confirmation_number":"SJ12622696882","room_stay_from":"2020-07-17","room_stay_to":"2020-07-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"103342","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-30 14:42:13","reservation_modified_date_time":"2020-07-20 15:42:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103342","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3118375","reservation_id":"97988","confirmation_number":"SJ12656858716","room_confirmation_number":"SJ12656858715","room_stay_from":"2020-07-20","room_stay_to":"2020-07-22","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"25.00,0.00","subtotal":"50.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"104056","product_attribute_values":"resort_fee#&#flat_rate#&#25.00","reservation_created_date":"2020-07-20 21:31:56","reservation_modified_date_time":"2020-07-21 15:18:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104056","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","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":"3116279","reservation_id":"95219","confirmation_number":"SJ12653974752","room_confirmation_number":"SJ12664576909","room_stay_from":"2020-07-17","room_stay_to":"2020-07-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"101401","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-22 00:22:11","reservation_modified_date_time":"2020-07-15 22:00:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101401","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3116718","reservation_id":"97806","confirmation_number":"SJ12626230046","room_confirmation_number":"SJ12682290535","room_stay_from":"2020-07-18","room_stay_to":"2020-07-23","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":"103878","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 01:18:08","reservation_modified_date_time":"2020-07-17 01:07:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103878","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3118138","reservation_id":"97343","confirmation_number":"SJ12642071786","room_confirmation_number":"SJ12628885770","room_stay_from":"2020-07-20","room_stay_to":"2020-07-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"103427","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-03 16:40:41","reservation_modified_date_time":"2020-07-20 19:54:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99511","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3094654","reservation_id":"94921","confirmation_number":"SJ12629234571","room_confirmation_number":"SJ12633883298","room_stay_from":"2020-07-21","room_stay_to":"2020-07-24","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":"101112","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-17 22:41:05","reservation_modified_date_time":"2020-05-17 22:41:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101112","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3109866","reservation_id":"97090","confirmation_number":"SJ12699029325","room_confirmation_number":"SJ12623685175","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103210","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 00:13:36","reservation_modified_date_time":"2020-06-26 00:13:36","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3109868","reservation_id":"97091","confirmation_number":"SJ12659687426","room_confirmation_number":"SJ12693369595","room_stay_from":"2020-07-19","room_stay_to":"2020-07-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103211","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 00:16:16","reservation_modified_date_time":"2020-06-26 00:16:16","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3112156","reservation_id":"96853","confirmation_number":"SJ12647401310","room_confirmation_number":"SJ12673840595","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102982","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 02:23:05","reservation_modified_date_time":"2020-07-03 16:33:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3113863","reservation_id":"97543","confirmation_number":"SJ12672171083","room_confirmation_number":"SJ12612018357","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"103616","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-08 18:07:25","reservation_modified_date_time":"2020-07-08 18:17:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103616","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3116732","reservation_id":"97429","confirmation_number":"SJ12625155325","room_confirmation_number":"SJ12665901478","room_stay_from":"2020-07-18","room_stay_to":"2020-07-25","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":"103516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-06 01:13:22","reservation_modified_date_time":"2020-07-17 01:41:31","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3117460","reservation_id":"95005","confirmation_number":"SJ12630760262","room_confirmation_number":"SJ12696624914","room_stay_from":"2020-07-17","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102619","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 00:37:09","reservation_modified_date_time":"2020-07-18 17:35:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101198","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3117897","reservation_id":"95157","confirmation_number":"SJ12623063876","room_confirmation_number":"SJ12679746112","room_stay_from":"2020-07-20","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"86804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 21:36:34","reservation_modified_date_time":"2020-07-20 00:25:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86804","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3118454","reservation_id":"95503","confirmation_number":"SJ12649184074","room_confirmation_number":"SJ12673054340","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101691","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 19:14:01","reservation_modified_date_time":"2020-07-21 16:37:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101691","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3118523","reservation_id":"95462","confirmation_number":"SJ12632473179","room_confirmation_number":"SJ12693797268","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":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-21 20:01:11","reservation_modified_date_time":"2020-07-21 20:01:11","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"104052","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"1","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3117943","reservation_id":"95462","confirmation_number":"SJ12610817488","room_confirmation_number":"SJ12693797268","room_stay_from":"2020-07-20","room_stay_to":"2020-07-21","room_stay_status":"Canceled","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Daily Resort","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-20 13:42:32","reservation_modified_date_time":"2020-07-20 13:42:32","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"82465","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-07-21 20:01:25","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-25,"changedComment":"reservation is canceled","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"}]}],"bar_taxable":[{"room_stay_id":"3118723","reservation_id":"98032","confirmation_number":"SJ12611116632","room_confirmation_number":"SJ12677692982","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":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-22 01:38:49","reservation_modified_date_time":"2020-07-22 01:38:49","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":"7.44","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":[]}}