{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-03-19","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,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":22,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1711","block_room_bookings":[{"confirmation_number":"SJ12650101230","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","bundle_room":"0","product_id":"1711"}],"bundle_block_count":"1271,1272,1309,1310,1260,1261,1291,1711,1302,1303,1267,1268,1262,1263,1311,1312,1304,1305,1307,1308,1269,1270","bundle_block_bookings":[{"confirmation_number":"SJB12673899513","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12684079541","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12670172230","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12678184165","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12615595655","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12639146895","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12610585305","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12615360176","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12684014702","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12611974579","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12690052931","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12654073298","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12613872108","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12676167275","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12687074072","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12630496005","room_stay_from":"2021-03-16","room_stay_to":"2021-03-23","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12654194868","room_stay_from":"2021-03-16","room_stay_to":"2021-03-23","bundle_room":"0","product_id":"1270"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3217598","reservation_id":"110575","confirmation_number":"SJ12642771202","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"347.31","nightly_discount":"0","subtotal":"347.31","grand_total":"390.73","paid_amount":"390.73","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-2525756373","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":"117087","customer_id":"117087","source_of_creation":"Booking.com","reservation_created_date":"2021-03-17 21:11:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"67.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"347.31","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":"3219122","reservation_id":"105442","confirmation_number":"SJ12684137929","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.15","nightly_discount":"100.00","subtotal":"254.15","grand_total":"173.42","paid_amount":"173.42","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2873801176","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":"111849","customer_id":"111849","source_of_creation":"Booking.com","reservation_created_date":"2021-01-16 14:55:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"32.25","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"254.15","currentDayDiscount":"100.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":"3219160","reservation_id":"110771","confirmation_number":"SJ12690558838","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"322.31","nightly_discount":"0","subtotal":"322.31","grand_total":"362.60","paid_amount":"362.60","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-2420667874","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":"117282","customer_id":"117282","source_of_creation":"Booking.com","reservation_created_date":"2021-03-19 22:27:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"67.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"322.31","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":"3181235","reservation_id":"105613","confirmation_number":"SJ12698902436","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"286.30,286.30,286.30,286.30,314.30,314.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1773.80","grand_total":"1995.53","paid_amount":"1995.53","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-3268807783","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":"112034","customer_id":"112034","source_of_creation":"Booking.com","reservation_created_date":"2021-01-19 03:57:25","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"346.28","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"314.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186773","reservation_id":"106355","confirmation_number":"SJ12663383071","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"276.07,303.07,303.07","nightly_discount":"0,0,0","subtotal":"882.21","grand_total":"992.49","paid_amount":"992.49","room_type_id":"320","product_id":"1322","siteminder_id":"BDC-3542333661","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":"112752","customer_id":"112752","source_of_creation":"Booking.com","reservation_created_date":"2021-01-28 22:48:22","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1267,1268","currentDayPrice":"303.07","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":"3199162","reservation_id":"107780","confirmation_number":"SJ12640907882","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"210.87,210.87","nightly_discount":"0,0","subtotal":"421.74","grand_total":"474.46","paid_amount":"474.46","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2382679519","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":"114236","customer_id":"114236","source_of_creation":"Booking.com","reservation_created_date":"2021-02-16 13:42:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"210.87","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":"3218601","reservation_id":"106225","confirmation_number":"SJ12644731106","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,239.20","nightly_discount":"0,0","subtotal":"478.40","grand_total":"538.20","paid_amount":"538.20","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2862928196","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":"112631","customer_id":"112631","source_of_creation":"Booking.com","reservation_created_date":"2021-01-27 02:21:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"95.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"239.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":"3195784","reservation_id":"105389","confirmation_number":"SJ12656476633","room_stay_from":"2021-03-15","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,181.30,181.30,209.30,209.30,181.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1325.10","grand_total":"1490.74","paid_amount":"1490.74","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-3841989126","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":"111787","customer_id":"111787","source_of_creation":"Booking.com","reservation_created_date":"2021-01-15 20:55:27","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204318","reservation_id":"107202","confirmation_number":"SJ12613533233","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"310.50,310.50,295.50","nightly_discount":"0,0,0","subtotal":"916.50","grand_total":"1031.07","paid_amount":"1031.07","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-3118479975","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":"113664","customer_id":"113664","source_of_creation":"Booking.com","reservation_created_date":"2021-02-09 03:17:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"178.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"310.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":"3204943","reservation_id":"105755","confirmation_number":"SJ12637689180","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"4","nightly_price":"272.77,272.77,248.47","nightly_discount":"0,0,0","subtotal":"794.01","grand_total":"893.26","paid_amount":"893.26","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-3941507199","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":"112153","customer_id":"112153","source_of_creation":"Booking.com","reservation_created_date":"2021-01-20 23:06:18","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"156.42","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"272.77","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":"3207349","reservation_id":"109038","confirmation_number":"SJ12615924289","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,261.75","nightly_discount":"0,0,0","subtotal":"860.25","grand_total":"967.78","paid_amount":"336.65","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-2328077573","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":"115502","customer_id":"115502","source_of_creation":"Booking.com","reservation_created_date":"2021-03-02 19:58:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"168.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"299.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218642","reservation_id":"110654","confirmation_number":"SJ12625306899","room_stay_from":"2021-03-26","room_stay_to":"2021-03-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"364.65,364.65","nightly_discount":"0,0","subtotal":"729.30","grand_total":"820.47","paid_amount":"410.23","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-2535613879","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":"117163","customer_id":"117163","source_of_creation":"Booking.com","reservation_created_date":"2021-03-18 21:25:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3207359","reservation_id":"109043","confirmation_number":"SJ12684685884","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"291.72","nightly_discount":"0","subtotal":"291.72","grand_total":"328.19","paid_amount":"328.19","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1743219022","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":"115507","customer_id":"115507","source_of_creation":"Expedia","reservation_created_date":"2021-03-02 20:32:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"291.72","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":"3212712","reservation_id":"106680","confirmation_number":"SJ12628985318","room_stay_from":"2021-03-13","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"198.24,175.84,175.84,175.84,175.84,175.84,198.24","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1275.68","grand_total":"1435.14","paid_amount":"1435.14","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1734527822","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":"113098","customer_id":"113098","source_of_creation":"Expedia","reservation_created_date":"2021-02-01 23:21:51","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.24","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":"3212812","reservation_id":"106351","confirmation_number":"SJ12691938427","room_stay_from":"2021-03-16","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.64,108.64,108.64,125.44","nightly_discount":"0,0,0,0","subtotal":"451.36","grand_total":"507.78","paid_amount":"507.78","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1733482290","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":"112745","customer_id":"112745","source_of_creation":"Expedia","reservation_created_date":"2021-01-28 21:26:18","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"125.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219126","reservation_id":"110369","confirmation_number":"SJ12642581139","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"291.72","nightly_discount":"0","subtotal":"291.72","grand_total":"328.19","paid_amount":"328.19","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1747949272","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":"116879","customer_id":"116879","source_of_creation":"Expedia","reservation_created_date":"2021-03-15 18:27:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"291.72","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":"3183634","reservation_id":"105983","confirmation_number":"SJ12698964259","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"173.04,173.04,173.04,173.04,195.44,195.44","nightly_discount":"0,0,0,0,0,0","subtotal":"1083.04","grand_total":"1218.42","paid_amount":"1218.42","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1732379634","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":"112407","customer_id":"112407","source_of_creation":"Expedia","reservation_created_date":"2021-01-24 16:41:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190438","reservation_id":"104405","confirmation_number":"SJ12691851776","room_stay_from":"2021-03-17","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.84,161.84,184.24,184.24","nightly_discount":"0,0,0,0","subtotal":"692.16","grand_total":"778.68","paid_amount":"778.68","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1726154407","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":"110754","customer_id":"110754","source_of_creation":"Expedia","reservation_created_date":"2020-12-29 22:51:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"184.24","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":"3192534","reservation_id":"106992","confirmation_number":"SJ12623105215","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.96,216.96","nightly_discount":"0,0","subtotal":"433.92","grand_total":"488.16","paid_amount":"488.16","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1735627930","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":"113429","customer_id":"113429","source_of_creation":"Expedia","reservation_created_date":"2021-02-05 22:30:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"216.96","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":"3204386","reservation_id":"106169","confirmation_number":"SJ12682371586","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"194.25,224.25,224.25","nightly_discount":"0,0,0","subtotal":"642.75","grand_total":"723.10","paid_amount":"723.10","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1732883244","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":"112576","customer_id":"112576","source_of_creation":"Expedia","reservation_created_date":"2021-01-26 16:31:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"224.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218595","reservation_id":"107855","confirmation_number":"SJ12694501069","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"216.96,216.96","nightly_discount":"0,0","subtotal":"433.92","grand_total":"488.16","paid_amount":"488.16","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1738860159","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":"114313","customer_id":"114313","source_of_creation":"Expedia","reservation_created_date":"2021-02-17 01:08:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"216.96","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":"3199665","reservation_id":"106255","confirmation_number":"SJ12661291649","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.40,179.40,155.40","nightly_discount":"0,0,0","subtotal":"514.20","grand_total":"578.48","paid_amount":"578.48","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1733169446","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":"112665","customer_id":"112665","source_of_creation":"Expedia","reservation_created_date":"2021-01-27 18:06:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219179","reservation_id":"106491","confirmation_number":"SJ12629349535","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"197.40,197.40,173.40","nightly_discount":"0.00,0.00,0.00","subtotal":"568.20","grand_total":"639.23","paid_amount":"639.23","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1733962739","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":"112900","customer_id":"112900","source_of_creation":"Expedia","reservation_created_date":"2021-01-30 18:31:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"197.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3179472","reservation_id":"105397","confirmation_number":"SJ12623217482","room_stay_from":"2021-03-13","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.16,139.60,139.60,139.60,139.60,139.60,161.16","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1020.32","grand_total":"1147.86","paid_amount":"1147.86","room_type_id":"413","product_id":"1272","siteminder_id":"GAM-R2283463867","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":"111795","customer_id":"111795","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-15 22:11:06","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":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"161.16","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":"3180415","reservation_id":"105404","confirmation_number":"SJ12655638550","room_stay_from":"2021-03-13","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"161.16,139.60,139.60,139.60,139.60,139.60,161.16","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1020.32","grand_total":"1147.86","paid_amount":"1147.86","room_type_id":"319","product_id":"1276","siteminder_id":"GAM-R2283496780","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":"111803","customer_id":"111803","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-15 22:31:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"161.16","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":"3212842","reservation_id":"107390","confirmation_number":"SJ12638922747","room_stay_from":"2021-03-16","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.81,190.81,190.81,196.20","nightly_discount":"0,0,0,0","subtotal":"768.63","grand_total":"864.71","paid_amount":"864.71","room_type_id":"413","product_id":"1260","siteminder_id":"GAM-R2323503907","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":"113846","customer_id":"113846","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-12 00:33:07","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"196.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":"3212862","reservation_id":"105399","confirmation_number":"SJ12675504417","room_stay_from":"2021-03-13","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"190.81,169.25,169.25,169.25,169.25,169.25,190.81","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1227.87","grand_total":"1381.35","paid_amount":"1381.35","room_type_id":"412","product_id":"1921","siteminder_id":"GAM-R2283473247","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":"116378","customer_id":"116378","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-15 22:18:11","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"190.81","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3218764","reservation_id":"107527","confirmation_number":"SJ12687100748","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"337.30","nightly_discount":"0.00","subtotal":"337.30","grand_total":"398.53","paid_amount":"398.53","room_type_id":"319","product_id":"1310","siteminder_id":"ABB-HM8HNFQXFF","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"339.64","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113987","customer_id":"113987","source_of_creation":"Airbnb","reservation_created_date":"2021-02-13 19:28:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"11.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"337.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3218039","reservation_id":"105511","confirmation_number":"SJ12624321203","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"257.50,262.14,262.14","nightly_discount":"0.00,0.00,0.00","subtotal":"781.78","grand_total":"905.97","paid_amount":"905.97","room_type_id":"413","product_id":"1266","siteminder_id":"ABB-HMJDXFX2MN","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"786.42","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111926","customer_id":"111926","source_of_creation":"Airbnb","reservation_created_date":"2021-01-17 17:18:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"23.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"262.14","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3218060","reservation_id":"106788","confirmation_number":"SJ12688690931","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"392.64,399.84,399.84","nightly_discount":"0.00,0.00,0.00","subtotal":"1192.32","grand_total":"1381.74","paid_amount":"1381.74","room_type_id":"320","product_id":"1332","siteminder_id":"ABB-HM9YDYYTKC","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1199.52","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113211","customer_id":"113211","source_of_creation":"Airbnb","reservation_created_date":"2021-02-03 01:01:19","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"35.28","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"399.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3218754","reservation_id":"106798","confirmation_number":"SJ12632406384","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"301.92,298.30","nightly_discount":"0.00,0.00","subtotal":"600.22","grand_total":"695.57","paid_amount":"695.57","room_type_id":"319","product_id":"1943","siteminder_id":"ABB-HM5483T9WZ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"603.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113222","customer_id":"113222","source_of_creation":"Airbnb","reservation_created_date":"2021-02-03 02:48:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"17.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"301.92","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3215957","reservation_id":"104462","confirmation_number":"SJ12688246677","room_stay_from":"2021-03-15","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"248.15,248.15,248.15,248.15,248.15,248.15,237.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1726.80","grand_total":"2001.11","paid_amount":"2001.11","room_type_id":"319","product_id":"1319","siteminder_id":"ABB-HMDYAXS9C4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1737.05","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110815","customer_id":"110815","source_of_creation":"Airbnb","reservation_created_date":"2020-12-31 04:01:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"51.09","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"248.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3218191","reservation_id":"105357","confirmation_number":"SJ12635648603","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00","nightly_discount":"0,0","subtotal":"238.00","grand_total":"267.75","paid_amount":"267.75","room_type_id":"319","product_id":"1913","siteminder_id":"HWR-303122358","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":"111748","customer_id":"111748","source_of_creation":"Hotwire","reservation_created_date":"2021-01-15 01:48:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"119.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"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3190348","reservation_id":"106156","confirmation_number":"SJ12622430278","room_stay_from":"2021-03-17","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"235.50,235.50,265.50","nightly_discount":"0.00,0.00,0.00","subtotal":"736.50","grand_total":"828.57","paid_amount":"828.57","room_type_id":"412","product_id":"1294","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":"112569","customer_id":"112569","source_of_creation":"FE","reservation_created_date":"2021-01-26 15:09:43","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"265.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":"3190369","reservation_id":"105401","confirmation_number":"SJ12693579641","room_stay_from":"2021-03-13","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.65,245.65,245.65,245.65,245.65,245.65,279.65","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1787.55","grand_total":"2011.00","paid_amount":"2011.00","room_type_id":"319","product_id":"1313","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":"111798","customer_id":"111798","source_of_creation":"FE","reservation_created_date":"2021-01-15 22:21:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"279.65","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":"3185563","reservation_id":"105469","confirmation_number":"SJ12639372780","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"306.75,336.75,336.75,306.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1287.00","grand_total":"1447.88","paid_amount":"1447.88","room_type_id":"320","product_id":"1329","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":"111878","customer_id":"111878","source_of_creation":"FE","reservation_created_date":"2021-01-16 20:30:46","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1304,1305","currentDayPrice":"336.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218299","reservation_id":"105853","confirmation_number":"SJ12689670857","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"216.75,246.75,246.75,216.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"927.00","grand_total":"1042.88","paid_amount":"1042.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112257","customer_id":"112257","source_of_creation":"FE","reservation_created_date":"2021-01-22 15:32:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3176284","reservation_id":"105013","confirmation_number":"SJ12690887633","room_stay_from":"2021-03-16","room_stay_to":"2021-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"306.75,306.75,306.75,336.75,336.75,306.75,306.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2207.25","grand_total":"2483.15","paid_amount":"2483.15","room_type_id":"320","product_id":"1323","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":"111377","customer_id":"111377","source_of_creation":"FE","reservation_created_date":"2021-01-08 17:41:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1269,1270","currentDayPrice":"336.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3180968","reservation_id":"105458","confirmation_number":"SJ12644396823","room_stay_from":"2021-03-14","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"180.00,180.00,180.00,180.00,180.00,180.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1080.00","grand_total":"1215.00","paid_amount":"1215.00","room_type_id":"319","product_id":"1293","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":"111983","customer_id":"111983","source_of_creation":"PMS","reservation_created_date":"2021-01-16 19:04:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"180.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":"3204432","reservation_id":"108548","confirmation_number":"SJ12652092352","room_stay_from":"2021-03-17","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.17,163.17,188.37","nightly_discount":"0.00,0.00,0.00","subtotal":"514.71","grand_total":"579.05","paid_amount":"579.05","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"114985","customer_id":"114985","source_of_creation":"PMS","reservation_created_date":"2021-02-25 16:42:37","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"188.37","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":"3212690","reservation_id":"106760","confirmation_number":"SJ12682158747","room_stay_from":"2021-03-14","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,194.25,194.25,194.25,194.25,224.25","nightly_discount":"9.71,9.71,9.71,9.71,9.71,11.21","subtotal":"1195.50","grand_total":"1277.71","paid_amount":"1277.71","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"113179","customer_id":"113179","source_of_creation":"PMS","reservation_created_date":"2021-02-02 19:50:59","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":"","promotion_code":"FLRES","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"224.25","currentDayDiscount":"11.21","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3217392","reservation_id":"106565","confirmation_number":"SJ12646218847","room_stay_from":"2021-03-16","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"224.25,224.25,224.25,224.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"897.00","grand_total":"1009.13","paid_amount":"1009.13","room_type_id":"318","product_id":"1289","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":"112982","customer_id":"112982","source_of_creation":"PMS","reservation_created_date":"2021-01-31 19:26:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"224.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":"3216921","reservation_id":"106087","confirmation_number":"SJ12663709695","room_stay_from":"2021-03-17","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,209.30,209.30","nightly_discount":"9.07,9.07,10.47,10.47","subtotal":"781.20","grand_total":"834.89","paid_amount":"834.89","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112509","customer_id":"112509","source_of_creation":"PMS","reservation_created_date":"2021-01-25 19:09:56","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"209.30","currentDayDiscount":"10.47","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204324","reservation_id":"106335","confirmation_number":"SJ12649884231","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.50,265.50,265.50,235.50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1002.00","grand_total":"1127.25","paid_amount":"1127.25","room_type_id":"411","product_id":"1296","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":"112730","customer_id":"112730","source_of_creation":"PMS","reservation_created_date":"2021-01-28 16:48:35","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"265.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":"3218331","reservation_id":"105586","confirmation_number":"SJ12697872291","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,224.25,224.25,194.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"837.00","grand_total":"941.63","paid_amount":"941.63","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112007","customer_id":"112007","source_of_creation":"PMS","reservation_created_date":"2021-01-18 23:46:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"224.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":"3219158","reservation_id":"108734","confirmation_number":"SJ12653140862","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"364.65,364.65,322.15","nightly_discount":"18.23,18.23,16.11","subtotal":"1051.45","grand_total":"1123.74","paid_amount":"1123.74","room_type_id":"319","product_id":"1306","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":"115187","customer_id":"115187","source_of_creation":"PMS","reservation_created_date":"2021-02-27 16:36:22","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":"","promotion_code":"AAA","sub_hotel_id":"0","currentDayPrice":"364.65","currentDayDiscount":"18.23","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186740","reservation_id":"105559","confirmation_number":"SJ12639093755","room_stay_from":"2021-03-18","room_stay_to":"2021-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,224.25,224.25,194.25,194.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1031.25","grand_total":"1160.15","paid_amount":"1160.15","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111979","customer_id":"111979","source_of_creation":"PMS","reservation_created_date":"2021-01-18 16:24:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"224.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":"3218328","reservation_id":"105794","confirmation_number":"SJ12633230040","room_stay_from":"2021-03-18","room_stay_to":"2021-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.65,279.65,279.65,279.65,279.65","nightly_discount":"0.00,0.00,0,0,0","subtotal":"1364.25","grand_total":"1534.78","paid_amount":"1534.78","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":"112199","customer_id":"112199","source_of_creation":"PMS","reservation_created_date":"2021-01-21 18:09:56","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"279.65","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":"3219135","reservation_id":"105456","confirmation_number":"SJ12693995368","room_stay_from":"2021-03-13","room_stay_to":"2021-03-19","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.00,300.00,300.00,300.00,300.00,600.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2100.00","grand_total":"2362.50","paid_amount":"2362.50","room_type_id":"320","product_id":"1714","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":"102558","customer_id":"102558","source_of_creation":"PMS","reservation_created_date":"2021-01-16 18:50:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"300.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3193461","reservation_id":"106658","confirmation_number":"SJ12666188576","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","paid_amount":"84.38","room_type_id":"319","product_id":"1287","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":"2021-02-01 22:04:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.33","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":"3198823","reservation_id":"95532","confirmation_number":"SJ12633661106","room_stay_from":"2021-03-19","room_stay_to":"2021-03-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"794.99","grand_total":"794.99","paid_amount":"0.00","room_type_id":"413","product_id":"1271","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-05-28 13:54:56","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.57","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":"3211124","reservation_id":"105424","confirmation_number":"SJ12644018896","room_stay_from":"2021-03-19","room_stay_to":"2021-03-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.00","paid_amount":"0.00","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-01-16 02:35:22","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"178.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":"3207885","reservation_id":"107527","confirmation_number":"SJ12619228541","room_confirmation_number":"SJ12687100748","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"50.30","paid_amount":"50.30","product_id":"1777","service_quantity":"1","customer_traveller_id":"113987","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-03-03 17:01:56","reservation_modified_date_time":"2021-03-03 17:01:56","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113987","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3219161","reservation_id":"110771","confirmation_number":"SJ12647645420","room_confirmation_number":"SJ12690558838","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","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":"117282","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-03-19 22:27:10","reservation_modified_date_time":"2021-03-19 22:27:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117282","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","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":"3199160","reservation_id":"107780","confirmation_number":"SJ12633292361","room_confirmation_number":"SJ12640907882","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"114236","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-16 17:48:14","reservation_modified_date_time":"2021-02-16 17:48:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114236","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3218300","reservation_id":"105853","confirmation_number":"SJ12696087677","room_confirmation_number":"SJ12689670857","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"25.00,25.00,0.00,0.00","subtotal":"100.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"112257","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-03-18 20:32:28","reservation_modified_date_time":"2021-03-18 20:33:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112257","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3179473","reservation_id":"105397","confirmation_number":"SJ12692136287","room_confirmation_number":"SJ12623217482","room_stay_from":"2021-03-13","room_stay_to":"2021-03-20","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":"111795","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 22:11:06","reservation_modified_date_time":"2021-01-15 22:11:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111795","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3180417","reservation_id":"105404","confirmation_number":"SJ12665856011","room_confirmation_number":"SJ12655638550","room_stay_from":"2021-03-13","room_stay_to":"2021-03-20","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":"111803","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 22:31:24","reservation_modified_date_time":"2021-01-17 18:04:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111803","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3180967","reservation_id":"105458","confirmation_number":"SJ12628209597","room_confirmation_number":"SJ12644396823","room_stay_from":"2021-03-14","room_stay_to":"2021-03-20","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":"111983","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 19:04:05","reservation_modified_date_time":"2021-01-18 18:26:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111983","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3190349","reservation_id":"106156","confirmation_number":"SJ12679269021","room_confirmation_number":"SJ12622430278","room_stay_from":"2021-03-17","room_stay_to":"2021-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":"112569","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 15:09:43","reservation_modified_date_time":"2021-02-02 18:13:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112569","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3190370","reservation_id":"105401","confirmation_number":"SJ12645255248","room_confirmation_number":"SJ12693579641","room_stay_from":"2021-03-13","room_stay_to":"2021-03-20","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":"111798","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 22:21:37","reservation_modified_date_time":"2021-02-02 18:25:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111798","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3204433","reservation_id":"108548","confirmation_number":"SJ12629471336","room_confirmation_number":"SJ12652092352","room_stay_from":"2021-03-17","room_stay_to":"2021-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":"114985","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 16:42:37","reservation_modified_date_time":"2021-02-25 16:42:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114985","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3207360","reservation_id":"109043","confirmation_number":"SJ12681116404","room_confirmation_number":"SJ12684685884","room_stay_from":"2021-03-19","room_stay_to":"2021-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":"115507","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 20:32:09","reservation_modified_date_time":"2021-03-02 20:32:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115507","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3212691","reservation_id":"106760","confirmation_number":"SJ12662006248","room_confirmation_number":"SJ12682158747","room_stay_from":"2021-03-14","room_stay_to":"2021-03-20","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":"113179","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 19:50:59","reservation_modified_date_time":"2021-03-09 19:40:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113179","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3212713","reservation_id":"106680","confirmation_number":"SJ12611866514","room_confirmation_number":"SJ12628985318","room_stay_from":"2021-03-13","room_stay_to":"2021-03-20","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":"113098","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 23:21:51","reservation_modified_date_time":"2021-03-09 19:42:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113098","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3212814","reservation_id":"106351","confirmation_number":"SJ12665490527","room_confirmation_number":"SJ12691938427","room_stay_from":"2021-03-16","room_stay_to":"2021-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":"112745","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 21:26:18","reservation_modified_date_time":"2021-03-09 21:25:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112745","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3212843","reservation_id":"107390","confirmation_number":"SJ12690474207","room_confirmation_number":"SJ12638922747","room_stay_from":"2021-03-16","room_stay_to":"2021-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":"113846","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 00:33:07","reservation_modified_date_time":"2021-03-09 21:35:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113846","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3212863","reservation_id":"105399","confirmation_number":"SJ12663865000","room_confirmation_number":"SJ12675504417","room_stay_from":"2021-03-13","room_stay_to":"2021-03-20","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":"116378","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 22:18:11","reservation_modified_date_time":"2021-03-09 21:39:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116378","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3217393","reservation_id":"106565","confirmation_number":"SJ12654207476","room_confirmation_number":"SJ12646218847","room_stay_from":"2021-03-16","room_stay_to":"2021-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":"112982","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 19:26:05","reservation_modified_date_time":"2021-03-17 18:01:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112982","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3217599","reservation_id":"110575","confirmation_number":"SJ12663838896","room_confirmation_number":"SJ12642771202","room_stay_from":"2021-03-19","room_stay_to":"2021-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":"117087","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 21:11:09","reservation_modified_date_time":"2021-03-17 21:11:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117087","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3218765","reservation_id":"107527","confirmation_number":"SJ12696125688","room_confirmation_number":"SJ12687100748","room_stay_from":"2021-03-19","room_stay_to":"2021-03-20","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113987","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-13 19:28:11","reservation_modified_date_time":"2021-03-19 16:04:56","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113987","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3219123","reservation_id":"105442","confirmation_number":"SJ12688332491","room_confirmation_number":"SJ12684137929","room_stay_from":"2021-03-19","room_stay_to":"2021-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":"111849","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 14:55:08","reservation_modified_date_time":"2021-03-19 22:01:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111849","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3219127","reservation_id":"110369","confirmation_number":"SJ12626215622","room_confirmation_number":"SJ12642581139","room_stay_from":"2021-03-19","room_stay_to":"2021-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":"116879","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-15 18:27:08","reservation_modified_date_time":"2021-03-19 22:02:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116879","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3219162","reservation_id":"110771","confirmation_number":"SJ12682192061","room_confirmation_number":"SJ12690558838","room_stay_from":"2021-03-19","room_stay_to":"2021-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":"117282","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 22:27:10","reservation_modified_date_time":"2021-03-19 22:27:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117282","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","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":"3181236","reservation_id":"105613","confirmation_number":"SJ12685821092","room_confirmation_number":"SJ12698902436","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","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":"112034","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 03:57:25","reservation_modified_date_time":"2021-01-19 03:57:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112034","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3183633","reservation_id":"105983","confirmation_number":"SJ12664731509","room_confirmation_number":"SJ12698964259","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","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":"112407","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 16:41:28","reservation_modified_date_time":"2021-01-24 17:20:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112407","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3186772","reservation_id":"106355","confirmation_number":"SJ12625327187","room_confirmation_number":"SJ12663383071","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","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":"112752","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 22:48:22","reservation_modified_date_time":"2021-01-29 03:09:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112752","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3190439","reservation_id":"104405","confirmation_number":"SJ12694732822","room_confirmation_number":"SJ12691851776","room_stay_from":"2021-03-17","room_stay_to":"2021-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":"110754","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 22:51:10","reservation_modified_date_time":"2021-02-02 18:50:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110754","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3192535","reservation_id":"106992","confirmation_number":"SJ12653786359","room_confirmation_number":"SJ12623105215","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"113429","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 22:30:12","reservation_modified_date_time":"2021-02-05 22:30:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113429","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3193462","reservation_id":"106658","confirmation_number":"SJ12666744684","room_confirmation_number":"SJ12666188576","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","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":"113076","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 22:04:12","reservation_modified_date_time":"2021-02-07 16:43:51","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3199161","reservation_id":"107780","confirmation_number":"SJ12650308146","room_confirmation_number":"SJ12640907882","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"114236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-16 13:42:17","reservation_modified_date_time":"2021-02-16 17:48:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114236","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3204387","reservation_id":"106169","confirmation_number":"SJ12637861055","room_confirmation_number":"SJ12682371586","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","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":"112576","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 16:31:15","reservation_modified_date_time":"2021-02-25 15:42:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112576","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3216922","reservation_id":"106087","confirmation_number":"SJ12630861654","room_confirmation_number":"SJ12663709695","room_stay_from":"2021-03-17","room_stay_to":"2021-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":"112509","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 19:09:56","reservation_modified_date_time":"2021-03-16 22:17:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112509","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3218040","reservation_id":"105511","confirmation_number":"SJ12688211615","room_confirmation_number":"SJ12624321203","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111926","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 17:18:11","reservation_modified_date_time":"2021-03-18 14:26:47","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111926","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3218063","reservation_id":"106788","confirmation_number":"SJ12651688484","room_confirmation_number":"SJ12688690931","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113211","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-03 01:01:19","reservation_modified_date_time":"2021-03-18 14:30:19","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113211","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3218192","reservation_id":"105357","confirmation_number":"SJ12678357835","room_confirmation_number":"SJ12635648603","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"111748","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 01:48:10","reservation_modified_date_time":"2021-03-18 17:10:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111748","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3218598","reservation_id":"107855","confirmation_number":"SJ12675436334","room_confirmation_number":"SJ12694501069","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"114313","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-17 01:08:17","reservation_modified_date_time":"2021-03-19 12:50:43","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114313","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3218602","reservation_id":"106225","confirmation_number":"SJ12619537746","room_confirmation_number":"SJ12644731106","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"112631","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 02:21:11","reservation_modified_date_time":"2021-03-19 12:51:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112631","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3218755","reservation_id":"106798","confirmation_number":"SJ12650375922","room_confirmation_number":"SJ12632406384","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","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":"113222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-03 02:48:12","reservation_modified_date_time":"2021-03-19 16:02:54","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113222","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3185566","reservation_id":"105469","confirmation_number":"SJ12628605254","room_confirmation_number":"SJ12639372780","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"111878","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 20:30:46","reservation_modified_date_time":"2021-01-27 16:01:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111878","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3195785","reservation_id":"105389","confirmation_number":"SJ12613660095","room_confirmation_number":"SJ12656476633","room_stay_from":"2021-03-15","room_stay_to":"2021-03-22","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":"111787","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 20:55:27","reservation_modified_date_time":"2021-02-11 13:37:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111787","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3199666","reservation_id":"106255","confirmation_number":"SJ12657725353","room_confirmation_number":"SJ12661291649","room_stay_from":"2021-03-19","room_stay_to":"2021-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":"112665","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 18:06:18","reservation_modified_date_time":"2021-02-17 16:23:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112665","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3204319","reservation_id":"107202","confirmation_number":"SJ12623042019","room_confirmation_number":"SJ12613533233","room_stay_from":"2021-03-19","room_stay_to":"2021-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":"113664","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-09 03:17:11","reservation_modified_date_time":"2021-02-25 14:53:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113664","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3204325","reservation_id":"106335","confirmation_number":"SJ12687493051","room_confirmation_number":"SJ12649884231","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"112730","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 16:48:35","reservation_modified_date_time":"2021-02-25 14:54:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112730","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3204944","reservation_id":"105755","confirmation_number":"SJ12643710663","room_confirmation_number":"SJ12637689180","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"112153","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-20 23:06:18","reservation_modified_date_time":"2021-02-26 11:52:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3207350","reservation_id":"109038","confirmation_number":"SJ12626471164","room_confirmation_number":"SJ12615924289","room_stay_from":"2021-03-19","room_stay_to":"2021-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":"115502","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 19:58:13","reservation_modified_date_time":"2021-03-02 20:03:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115502","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3215958","reservation_id":"104462","confirmation_number":"SJ12682627802","room_confirmation_number":"SJ12688246677","room_stay_from":"2021-03-15","room_stay_to":"2021-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":"110815","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-31 04:01:06","reservation_modified_date_time":"2021-03-15 12:38:01","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110815","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3218301","reservation_id":"105853","confirmation_number":"SJ12696059365","room_confirmation_number":"SJ12689670857","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"112257","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-22 15:32:42","reservation_modified_date_time":"2021-03-18 20:33:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112257","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3218332","reservation_id":"105586","confirmation_number":"SJ12668206512","room_confirmation_number":"SJ12697872291","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"112007","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 23:46:36","reservation_modified_date_time":"2021-03-18 21:24:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112007","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3219159","reservation_id":"108734","confirmation_number":"SJ12674513742","room_confirmation_number":"SJ12653140862","room_stay_from":"2021-03-19","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"25.00,25.00,0.00","subtotal":"75.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"115187","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 16:36:22","reservation_modified_date_time":"2021-03-19 22:25:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115187","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3219180","reservation_id":"106491","confirmation_number":"SJ12655786397","room_confirmation_number":"SJ12629349535","room_stay_from":"2021-03-19","room_stay_to":"2021-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":"112900","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 18:31:07","reservation_modified_date_time":"2021-03-19 22:59:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112900","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3176285","reservation_id":"105013","confirmation_number":"SJ12630098404","room_confirmation_number":"SJ12690887633","room_stay_from":"2021-03-16","room_stay_to":"2021-03-23","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":"111377","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-08 17:41:13","reservation_modified_date_time":"2021-01-08 17:41:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111377","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3186741","reservation_id":"105559","confirmation_number":"SJ12632455561","room_confirmation_number":"SJ12639093755","room_stay_from":"2021-03-18","room_stay_to":"2021-03-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"111979","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 16:24:15","reservation_modified_date_time":"2021-01-29 03:07:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111979","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3218330","reservation_id":"105794","confirmation_number":"SJ12620652603","room_confirmation_number":"SJ12633230040","room_stay_from":"2021-03-18","room_stay_to":"2021-03-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"112199","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 18:09:56","reservation_modified_date_time":"2021-03-18 21:24:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112199","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3198825","reservation_id":"95532","confirmation_number":"SJ12672827816","room_confirmation_number":"SJ12633661106","room_stay_from":"2021-03-19","room_stay_to":"2021-03-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101718","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 13:54:56","reservation_modified_date_time":"2021-02-16 01:23:47","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3211123","reservation_id":"105424","confirmation_number":"SJ12621938761","room_confirmation_number":"SJ12644018896","room_stay_from":"2021-03-19","room_stay_to":"2021-03-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111827","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 02:35:22","reservation_modified_date_time":"2021-03-07 15:18:15","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3218641","reservation_id":"110654","confirmation_number":"SJ12610126030","room_confirmation_number":"SJ12625306899","room_stay_from":"2021-03-26","room_stay_to":"2021-03-28","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117163","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-18 21:25:32","reservation_modified_date_time":"2021-03-19 14:09:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117163","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3219138","reservation_id":"105456","confirmation_number":"SJ12688277894","room_confirmation_number":"SJ12693995368","room_stay_from":"2021-03-13","room_stay_to":"2021-03-19","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":"102558","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 18:50:10","reservation_modified_date_time":"2021-03-19 22:14:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102558","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3218587","reservation_id":"106335","confirmation_number":"SJ12679022164","room_confirmation_number":"SJ12649884231","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":"1663","service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-19 11:51:43","reservation_modified_date_time":"2021-03-19 11:51:43","customer_id":"112730","parentCustTravId":"112730","customer_traveller_id":"112730","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-18","sub_hotel_id":"0","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":"3219134","reservation_id":"105456","confirmation_number":"SJ12618388234","room_confirmation_number":"SJ12693995368","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-19 22:13:50","reservation_modified_date_time":"2021-03-19 22:13:50","customer_id":"102558","parentCustTravId":"102558","customer_traveller_id":"102558","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-13","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219248","reservation_id":"110786","confirmation_number":"SJ12642081289","room_confirmation_number":"SJ12616099670","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":"1663","service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-20 03:00:28","reservation_modified_date_time":"2021-03-20 03:00:28","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}