{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-19","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":15,"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":"1307,1308,1309,1310,1291,1711,1302,1303,1267,1268,1304,1305,1260,1261,1271,1272,1269,1270","bundle_block_bookings":[{"confirmation_number":"SJB12655076314","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","bundle_room":"0"},{"confirmation_number":"SJB12677919747","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","bundle_room":"0"},{"confirmation_number":"SJB12690321780","room_stay_from":"2020-03-17","room_stay_to":"2020-03-20","bundle_room":"1"},{"confirmation_number":"SJB12699258806","room_stay_from":"2020-03-19","room_stay_to":"2020-03-20","bundle_room":"1"},{"confirmation_number":"SJB12644612211","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","bundle_room":"1"},{"confirmation_number":"SJB12651616832","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","bundle_room":"1"},{"confirmation_number":"SJB12657898776","room_stay_from":"2020-03-19","room_stay_to":"2020-03-20","bundle_room":"1"},{"confirmation_number":"SJB12678255452","room_stay_from":"2020-03-19","room_stay_to":"2020-03-20","bundle_room":"1"},{"confirmation_number":"SJB12664291874","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","bundle_room":"1"},{"confirmation_number":"SJB12631918999","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3073576","reservation_id":"92485","confirmation_number":"SJ12610905984","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"5","nightly_price":"520.00,520.00","nightly_discount":"0,0","subtotal":"1040.00","grand_total":"1170.00","paid_amount":"1170.00","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-3889088085","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":"98649","customer_id":"98649","source_of_creation":"Booking.com","reservation_created_date":"2020-02-24 16:34:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"196.20","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"520.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":"3080106","reservation_id":"92898","confirmation_number":"SJ12642481089","room_stay_from":"2020-03-19","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.50","nightly_discount":"0","subtotal":"229.50","grand_total":"258.19","paid_amount":"258.19","room_type_id":"319","product_id":"1711","siteminder_id":"BDC-2200050076","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":"99058","customer_id":"99058","source_of_creation":"Booking.com","reservation_created_date":"2020-03-03 06:26:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"45.81","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"229.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":"3081187","reservation_id":"92937","confirmation_number":"SJ12697271857","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.50,229.50","nightly_discount":"0,0","subtotal":"459.00","grand_total":"516.38","paid_amount":"516.38","room_type_id":"319","product_id":"1303","siteminder_id":"BDC-2674734028","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":"99100","customer_id":"99100","source_of_creation":"Booking.com","reservation_created_date":"2020-03-04 11:27:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"91.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"229.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":"3083087","reservation_id":"92004","confirmation_number":"SJ12631179755","room_stay_from":"2020-03-17","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"247.00,247.00,247.00","nightly_discount":"0.00,0.00,0.00","subtotal":"741.00","grand_total":"833.63","paid_amount":"833.63","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-3830308149","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98165","customer_id":"98165","source_of_creation":"Booking.com","reservation_created_date":"2020-02-15 17:06:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"175.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"247.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":"3083516","reservation_id":"90625","confirmation_number":"SJ12647224907","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.10,161.10","nightly_discount":"0,0","subtotal":"322.20","grand_total":"362.48","paid_amount":"362.48","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-3175792526","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":"96702","customer_id":"96702","source_of_creation":"Booking.com","reservation_created_date":"2020-01-26 17:29:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"68.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"161.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"247","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":"3074926","reservation_id":"91336","confirmation_number":"SJ12656917403","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"185.6,205.85","nightly_discount":"0,0","subtotal":"391.45","grand_total":"440.38","paid_amount":"0.00","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","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"89.58","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"185.6","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"160","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":"210.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3082799","reservation_id":"90893","confirmation_number":"SJ12627452907","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"179.00,215.00","nightly_discount":"0,0","subtotal":"394.00","grand_total":"443.25","paid_amount":"201.38","room_type_id":"413","product_id":"1271","siteminder_id":"BDC-2823088771","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":"96986","customer_id":"96986","source_of_creation":"Booking.com","reservation_created_date":"2020-01-29 20:26:07","service_canceled_date_time":"2020-03-17 00:54:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"81.04","deltaChange":"201.38","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3076373","reservation_id":"92746","confirmation_number":"SJ12669412921","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"183.60,183.60,183.60,183.60","nightly_discount":"0,0,0,0","subtotal":"734.40","grand_total":"826.20","paid_amount":"826.20","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1650458161","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":"98892","customer_id":"98892","source_of_creation":"Expedia","reservation_created_date":"2020-02-29 01:24:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.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":"3080296","reservation_id":"90901","confirmation_number":"SJ12644844258","room_stay_from":"2020-03-19","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1632125110","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":"96995","customer_id":"96995","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 22:23:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081797","reservation_id":"93321","confirmation_number":"SJ12686729977","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,204.00,204.00","nightly_discount":"0,0,0,0","subtotal":"816.00","grand_total":"918.00","paid_amount":"918.00","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1657504924","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":"99531","customer_id":"99531","source_of_creation":"Expedia","reservation_created_date":"2020-03-14 01:22:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"204.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":"3082640","reservation_id":"92687","confirmation_number":"SJ12682510155","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,183.60,183.60","nightly_discount":"0,0,0,0","subtotal":"734.40","grand_total":"826.20","paid_amount":"826.20","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1649764156","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":"99664","customer_id":"99664","source_of_creation":"Expedia","reservation_created_date":"2020-02-27 21:58:10","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":"183.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":"3082930","reservation_id":"91536","confirmation_number":"SJ12610904996","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"169.20,169.20","nightly_discount":"0,0","subtotal":"338.40","grand_total":"380.70","paid_amount":"380.70","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1637558281","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":"97670","customer_id":"97670","source_of_creation":"Expedia","reservation_created_date":"2020-02-08 00:28:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068720","reservation_id":"90592","confirmation_number":"SJ12626181334","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","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":"179.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"143.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"219.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":"183.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":"168.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":"3083708","reservation_id":"89926","confirmation_number":"SJ12630248874","room_stay_from":"2020-03-17","room_stay_to":"2020-03-19","room_stay_status":"Checked-Out","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"234.20,234.20","nightly_discount":"0,0","subtotal":"468.40","grand_total":"526.95","paid_amount":"526.95","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1622496187","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95948","customer_id":"95948","source_of_creation":"Expedia","reservation_created_date":"2020-01-14 01:28:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3083881","reservation_id":"90764","confirmation_number":"SJ12647446742","room_stay_from":"2021-03-27","room_stay_to":"2021-03-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00","nightly_discount":"0","subtotal":"215.00","grand_total":"241.88","paid_amount":"241.88","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1631159864","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":"96845","customer_id":"96845","source_of_creation":"Expedia","reservation_created_date":"2020-01-28 11:14:07","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":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[{"room_stay_id":"3082932","reservation_id":"90112","confirmation_number":"SJ12611387535","room_stay_from":"2020-03-18","room_stay_to":"2020-03-19","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20","nightly_discount":"0","subtotal":"239.20","grand_total":"269.10","paid_amount":"269.10","room_type_id":"319","product_id":"1302","siteminder_id":"EXP-1624405913","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":"96145","customer_id":"96145","source_of_creation":"Expedia","reservation_created_date":"2020-01-17 03:38:07","service_canceled_date_time":"2020-03-19 09:10:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.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":"139.48","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":"235.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":"","changedComment":"To date changed","deltaChange":"0.00","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":"255.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"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":[{"room_stay_id":"3083676","reservation_id":"92641","confirmation_number":"SJ12665458362","room_stay_from":"2020-03-15","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"495.00","grand_total":"495.00","paid_amount":"112.50","room_type_id":"319","product_id":"1305","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-02-27 03:55:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"396.00","currentDayPrice":"99.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":"3083694","reservation_id":"92638","confirmation_number":"SJ12691367276","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00","subtotal":"300.00","grand_total":"300.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":"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-02-27 03:48:56","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3077158","reservation_id":"92004","confirmation_number":"SJ12670190380","room_confirmation_number":"SJ12631179755","room_stay_from":"2020-03-17","room_stay_to":"2020-03-20","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"98165","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-02 19:20:34","reservation_modified_date_time":"2020-03-02 19:20:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98165","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":"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":"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":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"97459","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-27 03:47:13","reservation_modified_date_time":"2020-02-27 03:47:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97459","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":"3083711","reservation_id":"89926","confirmation_number":"SJ12626021263","room_confirmation_number":"SJ12630248874","room_stay_from":"2020-03-17","room_stay_to":"2020-03-19","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"95948","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-19 13:39:20","reservation_modified_date_time":"2020-03-19 13:39:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95948","canceled_nights_data":"","changedComment":"Reservation created for complete past date","deltaChange":"50.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081795","reservation_id":"90460","confirmation_number":"SJ12683820528","room_confirmation_number":"SJ12655050350","room_stay_from":"2020-03-18","room_stay_to":"2020-03-22","room_stay_status":"Canceled","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"0.00","product_id":"1777","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-14 19:47:34","reservation_modified_date_time":"2020-03-14 19:47:34","customer_id":"96514","parentCustTravId":"96514","customer_traveller_id":"96514","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-19 09:14:36","canceled_nights_data":"","product_attribute_values":"extra_person#&#25","deltaChange":-50,"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":"3073577","reservation_id":"92485","confirmation_number":"SJ12637897481","room_confirmation_number":"SJ12610905984","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"98649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-24 16:34:11","reservation_modified_date_time":"2020-02-24 16:34:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98649","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":"3076375","reservation_id":"92746","confirmation_number":"SJ12675434923","room_confirmation_number":"SJ12669412921","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","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":"98892","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-29 01:24:10","reservation_modified_date_time":"2020-02-29 20:22:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98892","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":"3080107","reservation_id":"92898","confirmation_number":"SJ12628401946","room_confirmation_number":"SJ12642481089","room_stay_from":"2020-03-19","room_stay_to":"2020-03-20","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":"99058","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-03 06:26:13","reservation_modified_date_time":"2020-03-10 14:57:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99058","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":"3080297","reservation_id":"90901","confirmation_number":"SJ12612033939","room_confirmation_number":"SJ12644844258","room_stay_from":"2020-03-19","room_stay_to":"2020-03-20","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":"96995","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 22:23:10","reservation_modified_date_time":"2020-03-10 20:33:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96995","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":"3081188","reservation_id":"92937","confirmation_number":"SJ12680073089","room_confirmation_number":"SJ12697271857","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.24","paid_amount":"56.24","product_id":"1776","service_quantity":"1","customer_traveller_id":"99100","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-04 11:27:10","reservation_modified_date_time":"2020-03-13 16:19:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99100","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":"3081798","reservation_id":"93321","confirmation_number":"SJ12643720585","room_confirmation_number":"SJ12686729977","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","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":"99531","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-14 01:22:09","reservation_modified_date_time":"2020-03-14 19:48:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99531","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":"3082639","reservation_id":"92687","confirmation_number":"SJ12634142512","room_confirmation_number":"SJ12682510155","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","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":"99664","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 21:58:10","reservation_modified_date_time":"2020-03-16 21:43:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99664","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":"3082931","reservation_id":"91536","confirmation_number":"SJ12693110328","room_confirmation_number":"SJ12610904996","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"97670","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 00:28:05","reservation_modified_date_time":"2020-03-17 14:15:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97670","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":"3083088","reservation_id":"92004","confirmation_number":"SJ12620227456","room_confirmation_number":"SJ12631179755","room_stay_from":"2020-03-17","room_stay_to":"2020-03-20","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":"98165","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-15 17:06:09","reservation_modified_date_time":"2020-03-17 17:23:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98165","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":"3083517","reservation_id":"90625","confirmation_number":"SJ12616994244","room_confirmation_number":"SJ12647224907","room_stay_from":"2020-03-18","room_stay_to":"2020-03-20","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"96702","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 17:29:10","reservation_modified_date_time":"2020-03-18 18:51:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96702","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":"3083678","reservation_id":"92641","confirmation_number":"SJ12695614638","room_confirmation_number":"SJ12665458362","room_stay_from":"2020-03-15","room_stay_to":"2020-03-20","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,25.00","subtotal":"125.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98794","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 03:55:06","reservation_modified_date_time":"2020-03-19 11:06:14","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"25.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"3074929","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":"Active","nightly_price":"28.12,28.12","nightly_discount":"0.00,0.00","subtotal":"56.24","grand_total":"63.27","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97459","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-02-05 00:30:13","reservation_modified_date_time":"2020-02-27 03:47:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97459","canceled_nights_data":"","currentDayPrice":"28.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"","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":"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":"3083696","reservation_id":"92638","confirmation_number":"SJ12679456111","room_confirmation_number":"SJ12691367276","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98792","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 03:48:56","reservation_modified_date_time":"2020-03-19 11:33:14","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"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":"3083712","reservation_id":"89926","confirmation_number":"SJ12661282577","room_confirmation_number":"SJ12630248874","room_stay_from":"2020-03-17","room_stay_to":"2020-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"95948","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-14 01:28:09","reservation_modified_date_time":"2020-03-19 13:39:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95948","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3083882","reservation_id":"90764","confirmation_number":"SJ12684768800","room_confirmation_number":"SJ12647446742","room_stay_from":"2021-03-27","room_stay_to":"2021-03-28","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":"96845","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 11:14:07","reservation_modified_date_time":"2020-03-20 00:06:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96845","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081796","reservation_id":"90460","confirmation_number":"SJ12677856000","room_confirmation_number":"SJ12655050350","room_stay_from":"2020-03-18","room_stay_to":"2020-03-22","room_stay_status":"Canceled","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-23 21:08:12","reservation_modified_date_time":"2020-03-14 19:47:35","customer_id":"96514","parentCustTravId":"96514","customer_traveller_id":"96514","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-19 09:14:36","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#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"}]},{"room_stay_id":"3082933","reservation_id":"90112","confirmation_number":"SJ12657810568","room_confirmation_number":"SJ12611387535","room_stay_from":"2020-03-18","room_stay_to":"2020-03-19","room_stay_status":"Canceled","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-17 03:38:07","reservation_modified_date_time":"2020-03-17 14:15:45","customer_id":"96145","parentCustTravId":"96145","customer_traveller_id":"96145","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-19 09:10:57","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#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"}]}],"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":"3083811","reservation_id":"93529","confirmation_number":"SJ12689643478","room_confirmation_number":"SJ12635036906","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-03-19 19:00:45","reservation_modified_date_time":"2020-03-19 19:00:45","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"}]},{"room_stay_id":"3083902","reservation_id":"93535","confirmation_number":"SJ12633803279","room_confirmation_number":"SJ12690051270","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 02:39:38","reservation_modified_date_time":"2020-03-20 02:39:38","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":[]}}