{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-20","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1278,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":12,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1942,1943","block_room_bookings":[{"confirmation_number":"SJ12622180244","room_stay_from":"2020-03-03","room_stay_to":"2020-04-01","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-04-01","bundle_room":"0"}],"bundle_block_count":"1267,1268,1271,1272,1260,1261,1269,1270,1304,1305,1309,1310","bundle_block_bookings":[{"confirmation_number":"SJB12683692064","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","bundle_room":"1"},{"confirmation_number":"SJB12664291874","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","bundle_room":"1"},{"confirmation_number":"SJB12669025284","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","bundle_room":"1"},{"confirmation_number":"SJB12639277641","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","bundle_room":"1"},{"confirmation_number":"SJB12665210706","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","bundle_room":"1"},{"confirmation_number":"SJB12644346627","room_stay_from":"2020-03-20","room_stay_to":"2020-03-23","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3067874","reservation_id":"91651","confirmation_number":"SJ12654546375","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"247,247,247,247,300","nightly_discount":"0,0,0,0,0","subtotal":"1288.00","grand_total":"1449.00","paid_amount":"1449.00","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-2721399518","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":"97788","customer_id":"97788","source_of_creation":"Booking.com","reservation_created_date":"2020-02-09 17:50:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"302.15","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"300","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":"3077166","reservation_id":"92617","confirmation_number":"SJ12640075237","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"160,160,195","nightly_discount":"0,0,0","subtotal":"515.00","grand_total":"579.38","paid_amount":"579.38","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-3541091166","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":"98771","customer_id":"98771","source_of_creation":"Booking.com","reservation_created_date":"2020-02-26 21:21:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"133.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"195","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":"3081407","reservation_id":"93316","confirmation_number":"SJ12656730721","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,210.00,210.00,210.00,210.00,210.00,245.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1540.00","grand_total":"1732.50","paid_amount":"1732.50","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-2690176829","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":"99527","customer_id":"99527","source_of_creation":"Booking.com","reservation_created_date":"2020-03-14 00:01:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"77.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"245.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":"3083955","reservation_id":"91811","confirmation_number":"SJ12668132551","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"168.50","nightly_discount":"0.00","subtotal":"168.50","grand_total":"189.57","paid_amount":"161.44","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2457843070","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97958","customer_id":"97958","source_of_creation":"Booking.com","reservation_created_date":"2020-02-11 21:04:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"39.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"168.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"}]}],"bdc_non_taxable":[{"room_stay_id":"3083950","reservation_id":"91336","confirmation_number":"SJ12656917403","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"185.60,205.85","nightly_discount":"0.00,0.00","subtotal":"391.45","grand_total":"440.38","paid_amount":"440.38","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-2199554087","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":"97459","customer_id":"97459","source_of_creation":"Booking.com","reservation_created_date":"2020-02-05 00:30:13","service_canceled_date_time":"2020-03-20 13:56:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"89.58","deltaChange":"231.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3068720","reservation_id":"90592","confirmation_number":"SJ12626181334","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00,179.00,215.00","nightly_discount":"0,0,0,0,0","subtotal":"931.00","grand_total":"1047.38","paid_amount":"1047.38","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1629730423","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":"96662","customer_id":"96662","source_of_creation":"Expedia","reservation_created_date":"2020-01-25 22:03:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068751","reservation_id":"91772","confirmation_number":"SJ12669745818","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20,172.00","nightly_discount":"0,0,0,0","subtotal":"601.60","grand_total":"676.80","paid_amount":"676.80","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1639376774","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":"97917","customer_id":"97917","source_of_creation":"Expedia","reservation_created_date":"2020-02-11 03:54:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3084125","reservation_id":"93549","confirmation_number":"SJ12690191436","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.00","nightly_discount":"0","subtotal":"224.00","grand_total":"252.00","paid_amount":"252.00","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1658823473","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":"99782","customer_id":"99782","source_of_creation":"Expedia","reservation_created_date":"2020-03-20 18:52:05","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":"224.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":"3083836","reservation_id":"92696","confirmation_number":"SJ12691828985","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"219.60,237.60,237.60","nightly_discount":"0,0,0","subtotal":"694.80","grand_total":"781.65","paid_amount":"781.65","room_type_id":"319","product_id":"1304","siteminder_id":"EXP-1649835412","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":"98842","customer_id":"98842","source_of_creation":"Expedia","reservation_created_date":"2020-02-28 00:23:06","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":"237.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077553","reservation_id":"92928","confirmation_number":"SJ12610722039","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"193.68,193.68,193.68,193.68","nightly_discount":"0,0,0,0","subtotal":"774.72","grand_total":"871.56","paid_amount":"871.56","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1652553862","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":"99092","customer_id":"99092","source_of_creation":"Expedia","reservation_created_date":"2020-03-04 00:39:06","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":"193.68","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082844","reservation_id":"92719","confirmation_number":"SJ12674860314","room_stay_from":"2020-03-17","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,183.60,201.60,201.60,183.60","nightly_discount":"0,0,0,0,0,0","subtotal":"1137.60","grand_total":"1279.80","paid_amount":"1279.80","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1650199577","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":"98864","customer_id":"98864","source_of_creation":"Expedia","reservation_created_date":"2020-02-28 16:54:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082827","reservation_id":"93386","confirmation_number":"SJ12684603802","room_stay_from":"2020-03-17","room_stay_to":"2020-03-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"168.00,168.00,168.00,196.00,196.00,168.00,168.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1232.00","grand_total":"1386.00","paid_amount":"1386.00","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1657946966","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":"99600","customer_id":"99600","source_of_creation":"Expedia","reservation_created_date":"2020-03-15 19:52:10","canceled_nights_data":"","product_name":"Standard 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":"196.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[{"room_stay_id":"3084034","reservation_id":"93414","confirmation_number":"SJ12621481249","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"196.00,196.00","nightly_discount":"0.00,0.00","subtotal":"392.00","grand_total":"441.00","paid_amount":"441.00","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1658155629","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":"99640","customer_id":"99640","source_of_creation":"Expedia","reservation_created_date":"2020-03-16 18:12:09","service_canceled_date_time":"2020-03-20 16:18:59","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"441.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[{"room_stay_id":"3082349","reservation_id":"93136","confirmation_number":"SJ12611900663","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.48,139.48,139.48,139.48,139.48,185.98","nightly_discount":"0,0,0,0,0,0","subtotal":"883.38","grand_total":"993.80","paid_amount":"993.80","room_type_id":"412","product_id":"1866","siteminder_id":"HTN-122544494-GXLRDA","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":"99334","customer_id":"99334","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-09 14:59:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"185.98","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3067565","reservation_id":"91612","confirmation_number":"SJ12689117206","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"260.00,235.00,235.00,235.00,235.00,235.00,260.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1695.00","grand_total":"1906.88","paid_amount":"1906.88","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97749","customer_id":"97749","source_of_creation":"PMS","reservation_created_date":"2020-02-08 21:57:42","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"260.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":"3083732","reservation_id":"93415","confirmation_number":"SJ12659766473","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00,182.00,182.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"874.00","grand_total":"983.25","paid_amount":"983.25","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99641","customer_id":"99641","source_of_creation":"PMS","reservation_created_date":"2020-03-16 18:19:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"182.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":"3073019","reservation_id":"92386","confirmation_number":"SJ12644473183","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"255.00,280.00,280.00","nightly_discount":"0.00,0.00,0.00","subtotal":"815.00","grand_total":"916.88","paid_amount":"916.88","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":"98562","customer_id":"98562","source_of_creation":"PMS","reservation_created_date":"2020-02-22 22:11:38","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":"280.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3084066","reservation_id":"93267","confirmation_number":"SJ12661656443","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"133.34,133.33","nightly_discount":"0.00,0.00","subtotal":"266.67","grand_total":"300.00","paid_amount":"300.00","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99477","customer_id":"99477","source_of_creation":"PMS","reservation_created_date":"2020-03-13 00:08:42","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.34","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":"3074573","reservation_id":"90326","confirmation_number":"SJ12617869467","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"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":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2020-01-21 21:54:40","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":"3080798","reservation_id":"93257","confirmation_number":"SJ12645290249","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"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":"2020-03-12 15:02:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3081531","reservation_id":"90995","confirmation_number":"SJ12627554229","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.71,160.71,160.71,160.71,160.72,160.72,160.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1125.00","grand_total":"1125.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":"1","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-01-31 12:43:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.72","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":"3082358","reservation_id":"92871","confirmation_number":"SJ12623092937","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","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":"319","product_id":"1314","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-03-02 19:24:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3067875","reservation_id":"91651","confirmation_number":"SJ12669349708","room_confirmation_number":"SJ12654546375","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"97788","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-09 17:50:10","reservation_modified_date_time":"2020-02-09 17:50:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97788","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":"3068958","reservation_id":"91811","confirmation_number":"SJ12654231289","room_confirmation_number":"SJ12668132551","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"97958","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-11 21:04:10","reservation_modified_date_time":"2020-02-11 21:04:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97958","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":"3077167","reservation_id":"92617","confirmation_number":"SJ12662633836","room_confirmation_number":"SJ12640075237","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"98771","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-02 19:34:41","reservation_modified_date_time":"2020-03-02 19:34:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98771","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":"3074928","reservation_id":"91336","confirmation_number":"SJ12663242131","room_confirmation_number":"SJ12656917403","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Canceled","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-27 03:47:13","reservation_modified_date_time":"2020-02-27 03:47:13","customer_id":"97459","parentCustTravId":"97459","customer_traveller_id":"97459","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-03-20 13:56:49","canceled_nights_data":"","product_attribute_values":"extra_person#&#25","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3067566","reservation_id":"91612","confirmation_number":"SJ12677964477","room_confirmation_number":"SJ12689117206","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"97749","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 21:57:42","reservation_modified_date_time":"2020-02-08 22:21:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97749","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":"3067876","reservation_id":"91651","confirmation_number":"SJ12647988341","room_confirmation_number":"SJ12654546375","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"97788","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 17:50:10","reservation_modified_date_time":"2020-02-09 17:50:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97788","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":"3068723","reservation_id":"90592","confirmation_number":"SJ12635637752","room_confirmation_number":"SJ12626181334","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"96662","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 22:03:09","reservation_modified_date_time":"2020-02-11 02:46:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96662","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":"3068752","reservation_id":"91772","confirmation_number":"SJ12611160793","room_confirmation_number":"SJ12669745818","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","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":"97917","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 03:54:10","reservation_modified_date_time":"2020-02-11 03:54:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97917","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":"3074574","reservation_id":"90326","confirmation_number":"SJ12693267413","room_confirmation_number":"SJ12617869467","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"96375","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-21 21:54:40","reservation_modified_date_time":"2020-02-26 14:08:08","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","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":"3077168","reservation_id":"92617","confirmation_number":"SJ12678740700","room_confirmation_number":"SJ12640075237","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98771","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 21:21:08","reservation_modified_date_time":"2020-03-02 19:34:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98771","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":"3080799","reservation_id":"93257","confirmation_number":"SJ12668992347","room_confirmation_number":"SJ12645290249","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"99463","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-12 15:02:36","reservation_modified_date_time":"2020-03-12 15:02:36","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":"3081406","reservation_id":"93316","confirmation_number":"SJ12636037045","room_confirmation_number":"SJ12656730721","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"99527","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-14 00:01:08","reservation_modified_date_time":"2020-03-14 00:22:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99527","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":"3082348","reservation_id":"93136","confirmation_number":"SJ12676528499","room_confirmation_number":"SJ12611900663","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"99590","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-09 14:59:08","reservation_modified_date_time":"2020-03-16 01:53:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99334","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":"3083733","reservation_id":"93415","confirmation_number":"SJ12651298996","room_confirmation_number":"SJ12659766473","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","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":"99641","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-16 18:19:52","reservation_modified_date_time":"2020-03-19 14:14:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99641","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":"3083957","reservation_id":"91811","confirmation_number":"SJ12667732323","room_confirmation_number":"SJ12668132551","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97958","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 21:04:10","reservation_modified_date_time":"2020-03-20 08:44:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97958","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":"3084126","reservation_id":"93549","confirmation_number":"SJ12676901343","room_confirmation_number":"SJ12690191436","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"99782","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-20 18:52:05","reservation_modified_date_time":"2020-03-21 01:27:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99782","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":"3073020","reservation_id":"92386","confirmation_number":"SJ12613085154","room_confirmation_number":"SJ12644473183","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98561","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-22 22:11:39","reservation_modified_date_time":"2020-02-22 22:11:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98562","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":"3082359","reservation_id":"92871","confirmation_number":"SJ12692980193","room_confirmation_number":"SJ12623092937","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","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":"99023","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 19:24:10","reservation_modified_date_time":"2020-03-16 11:22:49","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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":"3083835","reservation_id":"92696","confirmation_number":"SJ12671837798","room_confirmation_number":"SJ12691828985","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98860","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 00:23:06","reservation_modified_date_time":"2020-03-19 20:02:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98842","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":"3084067","reservation_id":"93267","confirmation_number":"SJ12662904573","room_confirmation_number":"SJ12661656443","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99477","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-13 00:08:42","reservation_modified_date_time":"2020-03-20 18:03:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99477","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":"3077554","reservation_id":"92928","confirmation_number":"SJ12649591910","room_confirmation_number":"SJ12610722039","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"99092","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-04 00:39:06","reservation_modified_date_time":"2020-03-04 00:39:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99092","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":"3082846","reservation_id":"92719","confirmation_number":"SJ12650735115","room_confirmation_number":"SJ12674860314","room_stay_from":"2020-03-17","room_stay_to":"2020-03-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":"98864","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 16:54:10","reservation_modified_date_time":"2020-03-17 00:26:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98864","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":"3082826","reservation_id":"93386","confirmation_number":"SJ12684854886","room_confirmation_number":"SJ12684603802","room_stay_from":"2020-03-17","room_stay_to":"2020-03-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"99600","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-15 19:52:10","reservation_modified_date_time":"2020-03-16 22:55:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99600","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":"3083951","reservation_id":"91336","confirmation_number":"SJ12692379607","room_confirmation_number":"SJ12656917403","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Canceled","nightly_price":"28.12,28.12","nightly_discount":"0.00,0.00","subtotal":"56.24","grand_total":"63.27","paid_amount":"63.27","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-05 00:30:13","reservation_modified_date_time":"2020-03-20 08:36:40","customer_id":"97459","parentCustTravId":"97459","customer_traveller_id":"97459","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-03-20 13:56:49","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","deltaChange":-28.12,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"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"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3081532","reservation_id":"90995","confirmation_number":"SJ12693986498","room_confirmation_number":"SJ12627554229","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"97088","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 12:43:41","reservation_modified_date_time":"2020-03-14 12:01:23","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"77106","canceled_nights_data":"","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"}]}],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3084038","reservation_id":"93542","confirmation_number":"SJ12686595279","room_confirmation_number":"SJ12697167045","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 16:28:52","reservation_modified_date_time":"2020-03-20 16:28:52","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3084094","reservation_id":"93550","confirmation_number":"SJ12652674926","room_confirmation_number":"SJ12663286568","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 21:47:53","reservation_modified_date_time":"2020-03-20 21:47:53","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3084104","reservation_id":"93553","confirmation_number":"SJ12637787112","room_confirmation_number":"SJ12694509902","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 23:10:24","reservation_modified_date_time":"2020-03-20 23:10:24","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}