{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-17","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":17,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1267,1268,1260,1261,1291,1711,1311,1312,1302,1303,1271,1272,1269,1270,1309,1310,1262,1263,1307,1308,1304,1305","bundle_block_bookings":[{"confirmation_number":"SJB12628012826","room_stay_from":"2021-04-12","room_stay_to":"2021-04-18","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12654498920","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12677111121","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12610244173","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12683170334","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12643619850","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12649373686","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12670831774","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12621268374","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12652487663","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12665847320","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12611326897","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12666054852","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12613403859","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12694671864","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12633642729","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12618932037","room_stay_from":"2021-04-17","room_stay_to":"2021-04-19","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12616786130","room_stay_from":"2021-04-17","room_stay_to":"2021-04-19","bundle_room":"0","product_id":"1305"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3196208","reservation_id":"107412","confirmation_number":"SJ12662267220","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"319","product_id":"1275","siteminder_id":"BDC-3432616004","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":"113869","customer_id":"113869","source_of_creation":"Booking.com","reservation_created_date":"2021-02-12 03:55:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"95.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"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":"3199137","reservation_id":"107102","confirmation_number":"SJ12626135135","room_stay_from":"2021-04-11","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.80,198.80,198.80,198.80,198.80,226.80,226.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1447.60","grand_total":"1628.55","paid_amount":"1628.55","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3670850987","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":"113558","customer_id":"113558","source_of_creation":"Booking.com","reservation_created_date":"2021-02-07 19:48:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"292.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"226.80","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":"3226542","reservation_id":"111787","confirmation_number":"SJ12644289724","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.37","nightly_discount":"0","subtotal":"295.37","grand_total":"332.29","paid_amount":"332.29","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2825284084","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":"118344","customer_id":"118344","source_of_creation":"Booking.com","reservation_created_date":"2021-03-31 22:08:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"57.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"295.37","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":"3227916","reservation_id":"106932","confirmation_number":"SJ12638436862","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.80,198.80,226.80,226.80","nightly_discount":"0,0,0,0","subtotal":"851.20","grand_total":"957.60","paid_amount":"957.60","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-2955016139","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":"113369","customer_id":"113369","source_of_creation":"Booking.com","reservation_created_date":"2021-02-05 00:37:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"171.22","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"226.80","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":"3228284","reservation_id":"112154","confirmation_number":"SJ12660126642","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2918480314","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":"118729","customer_id":"118729","source_of_creation":"Booking.com","reservation_created_date":"2021-04-05 15:15:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"70.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"364.65","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":"3234087","reservation_id":"112936","confirmation_number":"SJ12661919881","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.20,319.20","nightly_discount":"0,0","subtotal":"638.40","grand_total":"718.20","paid_amount":"718.20","room_type_id":"413","product_id":"1271","siteminder_id":"BDC-3422326358","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":"119519","customer_id":"119519","source_of_creation":"Booking.com","reservation_created_date":"2021-04-13 23:44:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"123.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"319.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":"3234795","reservation_id":"105984","confirmation_number":"SJ12662354976","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.31,174.31","nightly_discount":"0,0","subtotal":"348.62","grand_total":"392.20","paid_amount":"392.20","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-2515268794","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":"112408","customer_id":"112408","source_of_creation":"Booking.com","reservation_created_date":"2021-01-24 16:43:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"71.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.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":"3235518","reservation_id":"107960","confirmation_number":"SJ12650304073","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"271.51,271.51","nightly_discount":"0.00,0.00","subtotal":"543.02","grand_total":"610.90","paid_amount":"610.90","room_type_id":"320","product_id":"1910","siteminder_id":"BDC-3053604412","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":"114427","customer_id":"114427","source_of_creation":"Booking.com","reservation_created_date":"2021-02-18 14:39:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"106.74","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1309,1310","currentDayPrice":"271.51","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":"3236657","reservation_id":"112317","confirmation_number":"SJ12663754216","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.20","nightly_discount":"0","subtotal":"319.20","grand_total":"359.10","paid_amount":"359.10","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-3712561276","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":"118885","customer_id":"118885","source_of_creation":"Booking.com","reservation_created_date":"2021-04-07 12:24:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"61.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"319.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":"3195025","reservation_id":"107175","confirmation_number":"SJ12621575072","room_stay_from":"2021-04-06","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.30,223.30,223.30,251.30,251.30,181.30,181.30,181.30,181.30,181.30,209.30,209.30,181.30","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2678.90","grand_total":"3013.77","paid_amount":"3013.77","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-2365692959","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":"113633","customer_id":"113633","source_of_creation":"Booking.com","reservation_created_date":"2021-02-08 21:14:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"540.70","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":"3206601","reservation_id":"108905","confirmation_number":"SJ12673437172","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,230.30,230.30,195.30","nightly_discount":"0,0,0,0","subtotal":"851.20","grand_total":"957.60","paid_amount":"957.60","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2129030528","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":"115371","customer_id":"115371","source_of_creation":"Booking.com","reservation_created_date":"2021-03-01 12:27:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"171.22","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.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":"3226333","reservation_id":"111877","confirmation_number":"SJ12673193553","room_stay_from":"2021-04-17","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"326.88,254.88","nightly_discount":"0,0","subtotal":"581.76","grand_total":"654.48","paid_amount":"654.48","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-3676418433","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":"118443","customer_id":"118443","source_of_creation":"Booking.com","reservation_created_date":"2021-04-02 06:57:10","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"113.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"326.88","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":"3227930","reservation_id":"106649","confirmation_number":"SJ12693659277","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,188.30,188.30,160.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2713765928","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":"113068","customer_id":"113068","source_of_creation":"Booking.com","reservation_created_date":"2021-02-01 20:52:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"143.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.30","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":"3235203","reservation_id":"106678","confirmation_number":"SJ12628966949","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.27,169.47,169.47,144.27","nightly_discount":"0,0,0,0","subtotal":"627.48","grand_total":"705.91","paid_amount":"705.91","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-2717506620","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":"113096","customer_id":"113096","source_of_creation":"Booking.com","reservation_created_date":"2021-02-01 23:20:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"130.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"169.47","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":"3223704","reservation_id":"111478","confirmation_number":"SJ12683414019","room_stay_from":"2021-04-17","room_stay_to":"2021-04-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"351.75,246.75,246.75","nightly_discount":"0,0,0","subtotal":"845.25","grand_total":"950.90","paid_amount":"950.90","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2420299205","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":"118038","customer_id":"118038","source_of_creation":"Booking.com","reservation_created_date":"2021-03-28 00:32:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"165.65","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"351.75","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":"3225060","reservation_id":"111664","confirmation_number":"SJ12692749761","room_stay_from":"2021-04-17","room_stay_to":"2021-04-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"351.75,246.75,246.75","nightly_discount":"0,0,0","subtotal":"845.25","grand_total":"950.90","paid_amount":"950.90","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-2379296008","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":"118220","customer_id":"118220","source_of_creation":"Booking.com","reservation_created_date":"2021-03-30 03:29:23","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":"351.75","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":"3236570","reservation_id":"112915","confirmation_number":"SJ12655985560","room_stay_from":"2021-06-02","room_stay_to":"2021-06-07","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"228.00,228.00,318.00,318.00,265.50","nightly_discount":"0,0,0,0,0","subtotal":"1357.50","grand_total":"1527.19","paid_amount":"256.50","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-3999454248","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":"119493","customer_id":"119493","source_of_creation":"Booking.com","reservation_created_date":"2021-04-13 20:45:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]},{"room_stay_id":"3236588","reservation_id":"112591","confirmation_number":"SJ12647218236","room_stay_from":"2021-06-02","room_stay_to":"2021-06-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.25,209.25,299.25,299.25","nightly_discount":"0,0,0,0","subtotal":"1017.00","grand_total":"1144.13","paid_amount":"252.28","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-2398101223","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":"119172","customer_id":"119172","source_of_creation":"Booking.com","reservation_created_date":"2021-04-10 14:23:19","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","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":"3200076","reservation_id":"107943","confirmation_number":"SJ12682842923","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"355.20,355.20","nightly_discount":"0,0","subtotal":"710.40","grand_total":"799.20","paid_amount":"799.20","room_type_id":"320","product_id":"1332","siteminder_id":"EXP-1739184569","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":"114407","customer_id":"114407","source_of_creation":"Expedia","reservation_created_date":"2021-02-18 01:57:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"355.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":"3206812","reservation_id":"108935","confirmation_number":"SJ12693509082","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,300.30,300.30","nightly_discount":"0,0,0,0","subtotal":"963.20","grand_total":"1083.60","paid_amount":"1083.60","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1742805494","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":"115398","customer_id":"115398","source_of_creation":"Expedia","reservation_created_date":"2021-03-01 18:07:08","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"300.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":"3234175","reservation_id":"106567","confirmation_number":"SJ12622607469","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.36,207.36","nightly_discount":"0,0","subtotal":"414.72","grand_total":"466.56","paid_amount":"466.56","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1734216793","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":"112986","customer_id":"112986","source_of_creation":"Expedia","reservation_created_date":"2021-01-31 20:26:12","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":"126","group_rooms":null,"currentDayPrice":"207.36","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":"3234177","reservation_id":"112744","confirmation_number":"SJ12674190012","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"308.72","nightly_discount":"0","subtotal":"308.72","grand_total":"347.31","paid_amount":"347.31","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1758547958","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":"119340","customer_id":"119340","source_of_creation":"Expedia","reservation_created_date":"2021-04-12 01:34:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","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":"308.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":"3234651","reservation_id":"108882","confirmation_number":"SJ12625336558","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"279.30,279.30,314.30,314.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1187.20","grand_total":"1335.60","paid_amount":"1335.60","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1742604468","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":"115347","customer_id":"115347","source_of_creation":"Expedia","reservation_created_date":"2021-03-01 00:27:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","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.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":"3235059","reservation_id":"108736","confirmation_number":"SJ12636771285","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.56,226.56","nightly_discount":"0,0","subtotal":"453.12","grand_total":"509.76","paid_amount":"509.76","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1742183281","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":"115189","customer_id":"115189","source_of_creation":"Expedia","reservation_created_date":"2021-02-27 16:42:16","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","group_rooms":null,"currentDayPrice":"226.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3205888","reservation_id":"108796","confirmation_number":"SJ12672555038","room_stay_from":"2021-04-17","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"3","nightly_price":"374.2,334.2","nightly_discount":"0,0","subtotal":"708.40","grand_total":"796.95","paid_amount":"796.95","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1742320534","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115255","customer_id":"115255","source_of_creation":"Expedia","reservation_created_date":"2021-02-28 00:47:11","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":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"374.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3206286","reservation_id":"108866","confirmation_number":"SJ12641511212","room_stay_from":"2021-04-16","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.40,197.40,167.40","nightly_discount":"0,0,0","subtotal":"562.20","grand_total":"632.48","paid_amount":"632.48","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1742543099","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":"115328","customer_id":"115328","source_of_creation":"Expedia","reservation_created_date":"2021-02-28 21:02:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","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":"197.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":"3229340","reservation_id":"110951","confirmation_number":"SJ12622191369","room_stay_from":"2021-04-16","room_stay_to":"2021-04-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"240.24,262.64,184.24,173.04","nightly_discount":"0,0,0,0","subtotal":"860.16","grand_total":"967.68","paid_amount":"967.68","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1750582953","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":"117488","customer_id":"117488","source_of_creation":"Expedia","reservation_created_date":"2021-03-22 03:42:36","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":"126","group_rooms":null,"currentDayPrice":"262.64","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":"3235051","reservation_id":"107653","confirmation_number":"SJ12638034814","room_stay_from":"2021-04-17","room_stay_to":"2021-04-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.75,171.75,171.75","nightly_discount":"0.00,0.00,0.00","subtotal":"545.25","grand_total":"613.40","paid_amount":"613.40","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1738243703","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":"114113","customer_id":"114113","source_of_creation":"Expedia","reservation_created_date":"2021-02-15 03:08:09","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","group_rooms":null,"currentDayPrice":"201.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":"3217037","reservation_id":"110474","confirmation_number":"SJ12690743748","room_stay_from":"2021-04-17","room_stay_to":"2021-04-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,113.12,96.32,96.32","nightly_discount":"0,0,0,0","subtotal":"473.20","grand_total":"532.35","paid_amount":"532.35","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1748517761","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":"116987","customer_id":"116987","source_of_creation":"Expedia","reservation_created_date":"2021-03-17 01:58:11","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"167.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":"3236435","reservation_id":"108267","confirmation_number":"SJ12643577181","room_stay_from":"2021-04-17","room_stay_to":"2021-04-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"188.30,160.30,160.30,160.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"669.20","grand_total":"752.85","paid_amount":"752.85","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1740475380","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":"114729","customer_id":"114729","source_of_creation":"Expedia","reservation_created_date":"2021-02-22 15:12:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"188.30","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":"3218133","reservation_id":"110631","confirmation_number":"SJ12653884458","room_stay_from":"2021-04-17","room_stay_to":"2021-04-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"240.24,167.44,145.04,145.04,167.44","nightly_discount":"0,0,0,0,0","subtotal":"865.20","grand_total":"973.35","paid_amount":"973.35","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1749140435","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":"117138","customer_id":"117138","source_of_creation":"Expedia","reservation_created_date":"2021-03-18 15:52:06","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"240.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":"3236459","reservation_id":"112835","confirmation_number":"SJ12694326082","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,174.30","nightly_discount":"0,0,0,0","subtotal":"655.20","grand_total":"737.10","paid_amount":"180.34","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1758913165","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":"119419","customer_id":"119419","source_of_creation":"Expedia","reservation_created_date":"2021-04-13 00:09:43","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3190562","reservation_id":"106768","confirmation_number":"SJ12623957977","room_stay_from":"2021-04-12","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.43,123.43,123.43,123.43,144.99,144.99","nightly_discount":"0,0,0,0,0,0","subtotal":"783.70","grand_total":"881.67","paid_amount":"881.67","room_type_id":"413","product_id":"1267","siteminder_id":"GAM-R2308182920","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":"97545","customer_id":"97545","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-02 21:43:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"144.99","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":"3225421","reservation_id":"111707","confirmation_number":"SJ12624537142","room_stay_from":"2021-04-17","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.23,177.33,177.33,193.50,193.50","nightly_discount":"0,0,0,0,0","subtotal":"972.89","grand_total":"1094.50","paid_amount":"1094.50","room_type_id":"319","product_id":"1288","siteminder_id":"GAM-R2417817756","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":"118267","customer_id":"118267","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-30 20:36:23","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"231.23","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3234850","reservation_id":"107288","confirmation_number":"SJ12668301195","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"366.00,372.01,372.30","nightly_discount":"0.00,0.00,0.00","subtotal":"1110.31","grand_total":"1286.68","paid_amount":"1286.68","room_type_id":"320","product_id":"1323","siteminder_id":"ABB-HMBYNQ55ES","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1116.90","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113750","customer_id":"113750","source_of_creation":"Airbnb","reservation_created_date":"2021-02-10 16:39:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"32.85","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1269,1270","currentDayPrice":"372.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.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3234860","reservation_id":"108521","confirmation_number":"SJ12646407806","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"281.50,287.12,287.12","nightly_discount":"0.00,0.00,0.00","subtotal":"855.74","grand_total":"1003.15","paid_amount":"1003.15","room_type_id":"318","product_id":"1281","siteminder_id":"ABB-HM3JA34PMS","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"861.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114961","customer_id":"114961","source_of_creation":"Airbnb","reservation_created_date":"2021-02-25 05:23:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"27.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"287.12","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":"3235951","reservation_id":"108884","confirmation_number":"SJ12642643500","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"272.76","nightly_discount":"0.00","subtotal":"272.76","grand_total":"316.09","paid_amount":"316.09","room_type_id":"413","product_id":"1265","siteminder_id":"ABB-HMSWY932XM","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"274.38","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115351","customer_id":"115351","source_of_creation":"Airbnb","reservation_created_date":"2021-03-01 01:06:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"8.07","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"272.76","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":"3200082","reservation_id":"107945","confirmation_number":"SJ12689288455","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00","nightly_discount":"0,0","subtotal":"298.00","grand_total":"335.25","paid_amount":"335.25","room_type_id":"319","product_id":"1276","siteminder_id":"HWR-303253154","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":"114409","customer_id":"114409","source_of_creation":"Hotwire","reservation_created_date":"2021-02-18 02:24:06","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"149.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3234731","reservation_id":"107822","confirmation_number":"SJ12631441568","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"119.00,119.00","nightly_discount":"0,0","subtotal":"238.00","grand_total":"267.75","paid_amount":"267.75","room_type_id":"413","product_id":"1272","siteminder_id":"HWR-303230782","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":"114280","customer_id":"114280","source_of_creation":"Hotwire","reservation_created_date":"2021-02-16 19:19:08","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":"","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":"3191088","reservation_id":"94969","confirmation_number":"SJ12688152945","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00","nightly_discount":"0.00,0.00","subtotal":"430.00","grand_total":"483.75","paid_amount":"483.75","room_type_id":"413","product_id":"1260","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":"101157","customer_id":"101157","source_of_creation":"FE","reservation_created_date":"2020-05-18 17:19:27","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":"0","group_rooms":null,"currentDayPrice":"215.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":"3193230","reservation_id":"107052","confirmation_number":"SJ12640716544","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.65,228.65","nightly_discount":"0.00,0.00","subtotal":"457.30","grand_total":"514.47","paid_amount":"514.47","room_type_id":"413","product_id":"1261","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":"113497","customer_id":"113497","source_of_creation":"FE","reservation_created_date":"2021-02-06 22:42:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","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":"228.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":"3206507","reservation_id":"108885","confirmation_number":"SJ12692091884","room_stay_from":"2021-04-16","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,209.25","nightly_discount":"12.34,12.34,10.46","subtotal":"702.75","grand_total":"751.06","paid_amount":"751.06","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":"115350","customer_id":"115350","source_of_creation":"FE","reservation_created_date":"2021-03-01 01:07:16","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"12.34","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219872","reservation_id":"110864","confirmation_number":"SJ12638244119","room_stay_from":"2021-04-17","room_stay_to":"2021-04-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"351.75,246.75,231.75,231.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1062.00","grand_total":"1194.75","paid_amount":"1194.75","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":"117386","customer_id":"117386","source_of_creation":"FE","reservation_created_date":"2021-03-21 05:36:11","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":"351.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":"3197939","reservation_id":"107606","confirmation_number":"SJ12647125638","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"322.15,356.15,356.15","nightly_discount":"0.00,0.00,0.00","subtotal":"1034.45","grand_total":"1163.75","paid_amount":"1163.75","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":"114061","customer_id":"114061","source_of_creation":"PMS","reservation_created_date":"2021-02-14 17:22:19","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","group_rooms":"1291,1711","currentDayPrice":"356.15","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":"3199289","reservation_id":"107831","confirmation_number":"SJ12666875437","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.15,254.15","nightly_discount":"0.00,0.00","subtotal":"508.30","grand_total":"571.84","paid_amount":"571.84","room_type_id":"319","product_id":"1319","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":"114291","customer_id":"114291","source_of_creation":"PMS","reservation_created_date":"2021-02-16 21:22:01","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"254.15","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":"3199934","reservation_id":"107912","confirmation_number":"SJ12656060181","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"194.65,254.65,228.37,194.65","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"872.32","grand_total":"981.36","paid_amount":"981.36","room_type_id":"320","product_id":"1330","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":"114373","customer_id":"114373","source_of_creation":"PMS","reservation_created_date":"2021-02-17 20:50:30","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","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":"1307,1308","currentDayPrice":"228.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":"3203761","reservation_id":"108466","confirmation_number":"SJ12683428426","room_stay_from":"2021-04-08","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25,299.25,299.25,209.25,209.25,209.25,209.25,209.25,246.75,246.75,209.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2616.75","grand_total":"2943.85","paid_amount":"2943.85","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":"114913","customer_id":"114913","source_of_creation":"PMS","reservation_created_date":"2021-02-24 17:50:18","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":"","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":"3214174","reservation_id":"108092","confirmation_number":"SJ12681091358","room_stay_from":"2021-04-14","room_stay_to":"2021-04-19","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","subtotal":"1031.25","grand_total":"1160.15","paid_amount":"1160.15","room_type_id":"319","product_id":"1943","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":"114559","customer_id":"114559","source_of_creation":"PMS","reservation_created_date":"2021-02-20 02:59:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","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":"194.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":"3235207","reservation_id":"107910","confirmation_number":"SJ12659434508","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.25,209.25,209.25,209.25","nightly_discount":"0.00,0,0,0","subtotal":"837.00","grand_total":"941.63","paid_amount":"941.63","room_type_id":"413","product_id":"1266","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":"114373","customer_id":"114373","source_of_creation":"PMS","reservation_created_date":"2021-02-17 20:47:58","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","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":"209.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":"3207500","reservation_id":"109066","confirmation_number":"SJ12670184291","room_stay_from":"2021-04-15","room_stay_to":"2021-04-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.82,289.58,289.58,174.82,174.82","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1103.62","grand_total":"1241.57","paid_amount":"1241.57","room_type_id":"319","product_id":"1942","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":"115536","customer_id":"115536","source_of_creation":"PMS","reservation_created_date":"2021-03-03 00:46:19","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":"0","group_rooms":null,"currentDayPrice":"289.58","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":"3203979","reservation_id":"108493","confirmation_number":"SJ12665438074","room_stay_from":"2021-04-16","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.51,123.51,123.51,123.51,123.51,123.51,123.51","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"864.57","grand_total":"972.64","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114227","customer_id":"114227","source_of_creation":"PMS","reservation_created_date":"2021-02-24 23:59:49","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":"123.51","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":"3137355","reservation_id":"100420","confirmation_number":"SJ12678073836","room_stay_from":"2021-04-17","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"277.00,212.00,212.00,212.00,212.00,212.00,277.00","nightly_discount":"27.70,21.20,21.10,21.10,21.10,21.10,27.70","subtotal":"1614.00","grand_total":"1634.63","paid_amount":"1634.63","room_type_id":"412","product_id":"1921","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":"106453","customer_id":"106453","source_of_creation":"PMS","reservation_created_date":"2020-09-15 22:12:31","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"277.00","currentDayDiscount":"27.70","productIsTaxExempt":false,"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":"3204804","reservation_id":"108590","confirmation_number":"SJ12692218900","room_stay_from":"2021-04-16","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","room_type_id":"319","product_id":"1913","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-26 01:22:54","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":"0","group_rooms":null,"currentDayPrice":"114.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":"3204216","reservation_id":"108521","confirmation_number":"SJ12637613951","room_confirmation_number":"SJ12646407806","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"75.45","paid_amount":"75.45","product_id":"1777","service_quantity":"1","customer_traveller_id":"114961","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-02-25 05:23:10","reservation_modified_date_time":"2021-02-25 05:23:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114961","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.60","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3205889","reservation_id":"108796","confirmation_number":"SJ12636651566","room_confirmation_number":"SJ12672555038","room_stay_from":"2021-04-17","room_stay_to":"2021-04-19","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"115255","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-02-28 00:47:11","reservation_modified_date_time":"2021-02-28 00:47:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115255","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3190563","reservation_id":"106768","confirmation_number":"SJ12662342364","room_confirmation_number":"SJ12623957977","room_stay_from":"2021-04-12","room_stay_to":"2021-04-18","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":"97545","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 21:43:08","reservation_modified_date_time":"2021-02-02 21:43:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97545","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":"3191090","reservation_id":"94969","confirmation_number":"SJ12661319318","room_confirmation_number":"SJ12688152945","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"101157","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 17:19:27","reservation_modified_date_time":"2021-02-03 16:14:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101157","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":"3193231","reservation_id":"107052","confirmation_number":"SJ12616499340","room_confirmation_number":"SJ12640716544","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"113497","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-06 22:42:13","reservation_modified_date_time":"2021-02-06 22:42:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113497","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":"3196209","reservation_id":"107412","confirmation_number":"SJ12675798590","room_confirmation_number":"SJ12662267220","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"113869","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 03:55:07","reservation_modified_date_time":"2021-02-12 03:55:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113869","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":"3197940","reservation_id":"107606","confirmation_number":"SJ12697143677","room_confirmation_number":"SJ12647125638","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","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":"114061","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 17:22:19","reservation_modified_date_time":"2021-02-14 17:22:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114061","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":"3199138","reservation_id":"107102","confirmation_number":"SJ12627735779","room_confirmation_number":"SJ12626135135","room_stay_from":"2021-04-11","room_stay_to":"2021-04-18","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","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":"113558","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-07 19:48:13","reservation_modified_date_time":"2021-02-16 17:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113558","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":"3199290","reservation_id":"107831","confirmation_number":"SJ12670063094","room_confirmation_number":"SJ12666875437","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"114291","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-16 21:22:01","reservation_modified_date_time":"2021-02-16 21:22:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114291","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":"3200077","reservation_id":"107943","confirmation_number":"SJ12679779722","room_confirmation_number":"SJ12682842923","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"114407","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-18 01:57:07","reservation_modified_date_time":"2021-02-18 01:57:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114407","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":"3200083","reservation_id":"107945","confirmation_number":"SJ12693734765","room_confirmation_number":"SJ12689288455","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"114409","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-18 02:24:06","reservation_modified_date_time":"2021-02-18 02:24:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114409","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":"3206813","reservation_id":"108935","confirmation_number":"SJ12619379447","room_confirmation_number":"SJ12693509082","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","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":"115398","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 18:07:08","reservation_modified_date_time":"2021-03-01 18:07:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115398","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":"3226543","reservation_id":"111787","confirmation_number":"SJ12684737314","room_confirmation_number":"SJ12644289724","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"118344","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 22:08:09","reservation_modified_date_time":"2021-04-02 17:48:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118344","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":"3227917","reservation_id":"106932","confirmation_number":"SJ12611107654","room_confirmation_number":"SJ12638436862","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","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":"113369","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 00:37:10","reservation_modified_date_time":"2021-04-04 17:58:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113369","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":"3228285","reservation_id":"112154","confirmation_number":"SJ12612527267","room_confirmation_number":"SJ12660126642","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","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":"118729","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-05 15:15:06","reservation_modified_date_time":"2021-04-05 15:15:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118729","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":"3234088","reservation_id":"112936","confirmation_number":"SJ12689191886","room_confirmation_number":"SJ12661919881","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"119519","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-13 23:44:12","reservation_modified_date_time":"2021-04-13 23:44:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119519","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":"3234176","reservation_id":"106567","confirmation_number":"SJ12694575445","room_confirmation_number":"SJ12622607469","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"112986","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 20:26:12","reservation_modified_date_time":"2021-04-14 02:01:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112986","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":"3234178","reservation_id":"112744","confirmation_number":"SJ12640527141","room_confirmation_number":"SJ12674190012","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","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":"119340","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 01:34:11","reservation_modified_date_time":"2021-04-14 02:01:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119340","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":"3234654","reservation_id":"108882","confirmation_number":"SJ12611246529","room_confirmation_number":"SJ12625336558","room_stay_from":"2021-04-14","room_stay_to":"2021-04-18","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"115347","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 00:27:11","reservation_modified_date_time":"2021-04-15 01:37:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115347","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":"3234732","reservation_id":"107822","confirmation_number":"SJ12687909234","room_confirmation_number":"SJ12631441568","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"114280","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-16 19:19:08","reservation_modified_date_time":"2021-04-15 14:20:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114280","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":"3234798","reservation_id":"105984","confirmation_number":"SJ12646301042","room_confirmation_number":"SJ12662354976","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"112408","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 16:43:08","reservation_modified_date_time":"2021-04-15 14:41:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112408","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":"3234853","reservation_id":"107288","confirmation_number":"SJ12661016529","room_confirmation_number":"SJ12668301195","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","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":"113750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-10 16:39:07","reservation_modified_date_time":"2021-04-15 15:18:58","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113750","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":"3234861","reservation_id":"108521","confirmation_number":"SJ12663182248","room_confirmation_number":"SJ12646407806","room_stay_from":"2021-04-15","room_stay_to":"2021-04-18","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":"114961","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 05:23:10","reservation_modified_date_time":"2021-04-15 15:20:31","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114961","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3235060","reservation_id":"108736","confirmation_number":"SJ12672448154","room_confirmation_number":"SJ12636771285","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","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":"115189","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 16:42:16","reservation_modified_date_time":"2021-04-15 19:08:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115189","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":"3235521","reservation_id":"107960","confirmation_number":"SJ12690553288","room_confirmation_number":"SJ12650304073","room_stay_from":"2021-04-16","room_stay_to":"2021-04-18","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"114427","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-18 14:39:08","reservation_modified_date_time":"2021-04-16 19:40:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114427","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":"3235952","reservation_id":"108884","confirmation_number":"SJ12611004258","room_confirmation_number":"SJ12642643500","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","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":"115351","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 01:06:06","reservation_modified_date_time":"2021-04-17 13:51:43","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115351","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":"3236660","reservation_id":"112317","confirmation_number":"SJ12646640045","room_confirmation_number":"SJ12663754216","room_stay_from":"2021-04-17","room_stay_to":"2021-04-18","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"118885","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 12:24:11","reservation_modified_date_time":"2021-04-17 22:53:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118885","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","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":"3195026","reservation_id":"107175","confirmation_number":"SJ12617337503","room_confirmation_number":"SJ12621575072","room_stay_from":"2021-04-06","room_stay_to":"2021-04-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"325.00","grand_total":"365.63","paid_amount":"365.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"113633","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-08 21:14:13","reservation_modified_date_time":"2021-02-09 22:22:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113633","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":"3199935","reservation_id":"107912","confirmation_number":"SJ12612934845","room_confirmation_number":"SJ12656060181","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","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":"114373","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-17 20:50:30","reservation_modified_date_time":"2021-02-17 20:50:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114373","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":"3203762","reservation_id":"108466","confirmation_number":"SJ12698704665","room_confirmation_number":"SJ12683428426","room_stay_from":"2021-04-08","room_stay_to":"2021-04-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"275.00","grand_total":"309.38","paid_amount":"309.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"114913","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 17:50:18","reservation_modified_date_time":"2021-02-24 17:50:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114913","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":"3205890","reservation_id":"108796","confirmation_number":"SJ12616593003","room_confirmation_number":"SJ12672555038","room_stay_from":"2021-04-17","room_stay_to":"2021-04-19","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"115255","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-28 00:47:11","reservation_modified_date_time":"2021-02-28 00:47:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115255","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3206287","reservation_id":"108866","confirmation_number":"SJ12610687961","room_confirmation_number":"SJ12641511212","room_stay_from":"2021-04-16","room_stay_to":"2021-04-19","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":"115328","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-28 21:02:14","reservation_modified_date_time":"2021-02-28 21:02:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115328","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":"3206508","reservation_id":"108885","confirmation_number":"SJ12699623739","room_confirmation_number":"SJ12692091884","room_stay_from":"2021-04-16","room_stay_to":"2021-04-19","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":"115350","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 01:07:16","reservation_modified_date_time":"2021-03-01 01:07:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115350","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":"3206602","reservation_id":"108905","confirmation_number":"SJ12656602156","room_confirmation_number":"SJ12673437172","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","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":"115371","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 12:27:07","reservation_modified_date_time":"2021-03-01 12:27:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115371","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":"3214175","reservation_id":"108092","confirmation_number":"SJ12671576272","room_confirmation_number":"SJ12681091358","room_stay_from":"2021-04-14","room_stay_to":"2021-04-19","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":"114559","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-20 02:59:46","reservation_modified_date_time":"2021-03-11 22:44:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114559","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":"3226334","reservation_id":"111877","confirmation_number":"SJ12673916380","room_confirmation_number":"SJ12673193553","room_stay_from":"2021-04-17","room_stay_to":"2021-04-19","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"118443","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-02 06:57:10","reservation_modified_date_time":"2021-04-02 06:57:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118443","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":"3227931","reservation_id":"106649","confirmation_number":"SJ12657566167","room_confirmation_number":"SJ12693659277","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","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":"113068","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 20:52:13","reservation_modified_date_time":"2021-04-04 18:00:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113068","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":"3235204","reservation_id":"106678","confirmation_number":"SJ12674752462","room_confirmation_number":"SJ12628966949","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","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":"113096","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 23:20:09","reservation_modified_date_time":"2021-04-15 23:55:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113096","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":"3235208","reservation_id":"107910","confirmation_number":"SJ12677913422","room_confirmation_number":"SJ12659434508","room_stay_from":"2021-04-15","room_stay_to":"2021-04-19","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":"114373","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-17 20:47:58","reservation_modified_date_time":"2021-04-15 23:55:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114373","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":"3207501","reservation_id":"109066","confirmation_number":"SJ12668579902","room_confirmation_number":"SJ12670184291","room_stay_from":"2021-04-15","room_stay_to":"2021-04-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"115536","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 00:46:19","reservation_modified_date_time":"2021-03-03 00:46:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115536","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":"3223705","reservation_id":"111478","confirmation_number":"SJ12627847717","room_confirmation_number":"SJ12683414019","room_stay_from":"2021-04-17","room_stay_to":"2021-04-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":"118038","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 00:32:12","reservation_modified_date_time":"2021-03-28 00:32:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118038","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":"3225059","reservation_id":"111664","confirmation_number":"SJ12632811179","room_confirmation_number":"SJ12692749761","room_stay_from":"2021-04-17","room_stay_to":"2021-04-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":"118220","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 03:29:23","reservation_modified_date_time":"2021-03-30 12:56:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118220","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":"3229339","reservation_id":"110951","confirmation_number":"SJ12619739488","room_confirmation_number":"SJ12622191369","room_stay_from":"2021-04-16","room_stay_to":"2021-04-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":"117488","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 03:42:36","reservation_modified_date_time":"2021-03-22 03:42:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117488","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":"3235052","reservation_id":"107653","confirmation_number":"SJ12650195761","room_confirmation_number":"SJ12638034814","room_stay_from":"2021-04-17","room_stay_to":"2021-04-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":"114113","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 03:08:09","reservation_modified_date_time":"2021-04-15 19:06:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114113","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":"3217038","reservation_id":"110474","confirmation_number":"SJ12662563756","room_confirmation_number":"SJ12690743748","room_stay_from":"2021-04-17","room_stay_to":"2021-04-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":"116987","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 01:58:11","reservation_modified_date_time":"2021-03-17 01:58:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116987","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":"3219873","reservation_id":"110864","confirmation_number":"SJ12636131681","room_confirmation_number":"SJ12638244119","room_stay_from":"2021-04-17","room_stay_to":"2021-04-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":"117386","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-21 05:36:11","reservation_modified_date_time":"2021-03-21 05:36:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117386","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":"3236437","reservation_id":"108267","confirmation_number":"SJ12613216486","room_confirmation_number":"SJ12643577181","room_stay_from":"2021-04-17","room_stay_to":"2021-04-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":"114729","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 15:12:10","reservation_modified_date_time":"2021-04-17 20:31:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114729","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":"3218134","reservation_id":"110631","confirmation_number":"SJ12683890528","room_confirmation_number":"SJ12653884458","room_stay_from":"2021-04-17","room_stay_to":"2021-04-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117138","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-18 15:52:06","reservation_modified_date_time":"2021-03-18 15:52:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117138","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":"3225420","reservation_id":"111707","confirmation_number":"SJ12657873816","room_confirmation_number":"SJ12624537142","room_stay_from":"2021-04-17","room_stay_to":"2021-04-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"118267","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 20:36:23","reservation_modified_date_time":"2021-03-30 21:39:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118267","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":"3203980","reservation_id":"108493","confirmation_number":"SJ12693732543","room_confirmation_number":"SJ12665438074","room_stay_from":"2021-04-16","room_stay_to":"2021-04-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114940","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 23:59:49","reservation_modified_date_time":"2021-02-25 00:53:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114227","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":"3204805","reservation_id":"108590","confirmation_number":"SJ12643680677","room_confirmation_number":"SJ12692218900","room_stay_from":"2021-04-16","room_stay_to":"2021-04-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115028","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:22:54","reservation_modified_date_time":"2021-02-26 01:22:54","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":"3137356","reservation_id":"100420","confirmation_number":"SJ12640625081","room_confirmation_number":"SJ12678073836","room_stay_from":"2021-04-17","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"106453","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-15 22:12:31","reservation_modified_date_time":"2020-09-16 14:52:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106453","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":"3236458","reservation_id":"112835","confirmation_number":"SJ12661990843","room_confirmation_number":"SJ12694326082","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119419","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-13 00:09:43","reservation_modified_date_time":"2021-04-17 20:41:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119419","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":"3236569","reservation_id":"112915","confirmation_number":"SJ12681044963","room_confirmation_number":"SJ12655985560","room_stay_from":"2021-06-02","room_stay_to":"2021-06-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119493","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-13 20:45:08","reservation_modified_date_time":"2021-04-17 21:40:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119493","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":"3236587","reservation_id":"112591","confirmation_number":"SJ12633991336","room_confirmation_number":"SJ12647218236","room_stay_from":"2021-06-02","room_stay_to":"2021-06-06","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119172","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 14:23:19","reservation_modified_date_time":"2021-04-17 21:44:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119172","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3236357","reservation_id":"113243","confirmation_number":"SJ12637158850","room_confirmation_number":"SJ12695559490","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-17 18:40:52","reservation_modified_date_time":"2021-04-17 18:40:52","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":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3236688","reservation_id":"113269","confirmation_number":"SJ12611845586","room_confirmation_number":"SJ12631217773","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"45.00","paid_amount":"45.00","product_id":"1231","service_quantity":"3","product_name":"T shirt","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-17 23:23:01","reservation_modified_date_time":"2021-04-17 23:23:01","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":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}