{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-09-12","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":16,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1307,1308,1309,1310,1311,1312,1302,1303,1271,1272,1304,1305,1269,1270,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12676955157","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12647557290","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12635628086","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12672032359","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12672297906","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12632128562","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12656100144","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12610196115","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12621665946","room_stay_from":"2021-09-11","room_stay_to":"2021-09-14","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12657845271","room_stay_from":"2021-09-11","room_stay_to":"2021-09-14","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12689749635","room_stay_from":"2021-09-11","room_stay_to":"2021-09-15","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12673338884","room_stay_from":"2021-09-11","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12621892222","room_stay_from":"2021-09-11","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12667654006","room_stay_from":"2021-09-11","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12661928156","room_stay_from":"2021-09-11","room_stay_to":"2021-09-13","bundle_room":"0","product_id":"1711"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3256011","reservation_id":"115744","confirmation_number":"SJ12656389710","room_stay_from":"2021-09-08","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.16,95.82,118.50,118.50,95.82,95.82,95.82","nightly_discount":"0,0,0,0,0,0,0","subtotal":"727.44","grand_total":"818.37","paid_amount":"818.37","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-2615072902","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":"122519","customer_id":"122519","source_of_creation":"Booking.com","reservation_created_date":"2021-05-23 19:44:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"162.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"95.82","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":"3282029","reservation_id":"119114","confirmation_number":"SJ12672168517","room_stay_from":"2021-09-10","room_stay_to":"2021-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.32,166.32,141.12,141.12","nightly_discount":"0,0,0,0","subtotal":"614.88","grand_total":"691.74","paid_amount":"691.74","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-3154442873","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":"126233","customer_id":"126233","source_of_creation":"Booking.com","reservation_created_date":"2021-07-11 15:27:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"128.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"141.12","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":"3299683","reservation_id":"120898","confirmation_number":"SJ12643492296","room_stay_from":"2021-09-10","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.27,207.27,191.52,156.87,156.87","nightly_discount":"0,0,0,0,0","subtotal":"919.80","grand_total":"1034.78","paid_amount":"1034.78","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3358998987","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":"128297","customer_id":"128297","source_of_creation":"Booking.com","reservation_created_date":"2021-08-07 18:17:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"188.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"191.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3302910","reservation_id":"120253","confirmation_number":"SJ12672369640","room_stay_from":"2021-09-10","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,186.75","nightly_discount":"0,0,0","subtotal":"680.25","grand_total":"765.28","paid_amount":"765.28","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-3865202159","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":"127518","customer_id":"127518","source_of_creation":"Booking.com","reservation_created_date":"2021-07-28 04:38:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"135.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"186.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":"5305859","reservation_id":"121150","confirmation_number":"SJ12663517871","room_stay_from":"2021-09-08","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"160.02,160.02,160.02,160.02,160.02,160.02,160.02","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1120.14","grand_total":"1260.16","paid_amount":"1260.16","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3273137917","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":"128605","customer_id":"128605","source_of_creation":"Booking.com","reservation_created_date":"2021-08-13 22:15:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"233.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.02","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":"5307816","reservation_id":"120564","confirmation_number":"SJ12639548493","room_stay_from":"2021-09-12","room_stay_to":"2021-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.77,175.77,175.77,175.77,175.77,226.17","nightly_discount":"0,0,0,0,0,0","subtotal":"1105.02","grand_total":"1243.15","paid_amount":"1243.15","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3085554269","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":"127896","customer_id":"127896","source_of_creation":"Booking.com","reservation_created_date":"2021-08-02 01:14:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"225.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"175.77","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5310148","reservation_id":"115521","confirmation_number":"SJ12663046246","room_stay_from":"2021-09-11","room_stay_to":"2021-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.30,118.30,118.30,118.30,118.30,118.30","nightly_discount":"0,0,0,0,0,0","subtotal":"737.80","grand_total":"830.03","paid_amount":"830.03","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-3671194168","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":"122266","customer_id":"122266","source_of_creation":"Booking.com","reservation_created_date":"2021-05-19 20:08:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"159.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"118.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":"5311926","reservation_id":"116854","confirmation_number":"SJ12695761569","room_stay_from":"2021-09-12","room_stay_to":"2021-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.20,159.20","nightly_discount":"0,0","subtotal":"318.40","grand_total":"358.20","paid_amount":"358.20","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-3810681719","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":"123770","customer_id":"123770","source_of_creation":"Booking.com","reservation_created_date":"2021-06-09 03:57:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"66.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"159.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":"5312217","reservation_id":"110311","confirmation_number":"SJ12697529305","room_stay_from":"2021-09-12","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.75,126.75,126.75","nightly_discount":"0,0,0","subtotal":"380.25","grand_total":"427.78","paid_amount":"427.78","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-3867445521","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":"116829","customer_id":"116829","source_of_creation":"Booking.com","reservation_created_date":"2021-03-14 22:31:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"81.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"126.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":"5312419","reservation_id":"121930","confirmation_number":"SJ12632546432","room_stay_from":"2021-09-10","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,139.30","nightly_discount":"0,0,0","subtotal":"557.90","grand_total":"627.64","paid_amount":"599.52","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3056422772","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":"129467","customer_id":"129467","source_of_creation":"Booking.com","reservation_created_date":"2021-08-25 23:19:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"139.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":"5312268","reservation_id":"122878","confirmation_number":"SJ12696602991","room_stay_from":"2022-10-08","room_stay_to":"2022-10-11","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"347.40,288.90,288.90","nightly_discount":"0,0,0","subtotal":"925.20","grand_total":"1040.85","paid_amount":"434.25","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-3196768254","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":"130541","customer_id":"130541","source_of_creation":"Booking.com","reservation_created_date":"2021-09-11 16:54:14","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"180.03","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":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":"3252320","reservation_id":"115245","confirmation_number":"SJ12640179499","room_stay_from":"2021-09-11","room_stay_to":"2021-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.30,118.30,118.30,118.30,118.30,118.30,174.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"912.10","grand_total":"1026.12","paid_amount":"1026.12","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1771206598","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":"121953","customer_id":"121953","source_of_creation":"Expedia","reservation_created_date":"2021-05-15 01:01:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"118.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":"5030983","reservation_id":"121666","confirmation_number":"SJ12664999426","room_stay_from":"2021-09-09","room_stay_to":"2021-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.80,247.80,247.80,177.80,177.80","nightly_discount":"0,0,0,0,0","subtotal":"1029.00","grand_total":"1157.63","paid_amount":"1157.63","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1819402088","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":"129202","customer_id":"129202","source_of_creation":"Expedia","reservation_created_date":"2021-08-21 20:59:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"177.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5311930","reservation_id":"122312","confirmation_number":"SJ12664605038","room_stay_from":"2021-09-11","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"8","room_stay_child_count":"0","nightly_price":"368.18,362.56","nightly_discount":"0.00,0.00","subtotal":"730.74","grand_total":"877.40","paid_amount":"877.40","room_type_id":"320","product_id":"1714","siteminder_id":"ABB-HM95JW5MYC","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"736.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129900","customer_id":"129900","source_of_creation":"Airbnb","reservation_created_date":"2021-08-31 21:31:57","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"27.54","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1291,1711","currentDayPrice":"362.56","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":"5312301","reservation_id":"120420","confirmation_number":"SJ12633755659","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"301.92,298.30","nightly_discount":"0.00,0.00","subtotal":"600.22","grand_total":"695.57","paid_amount":"695.57","room_type_id":"319","product_id":"1287","siteminder_id":"ABB-HM3EJ8HRPB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"603.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127701","customer_id":"127701","source_of_creation":"Airbnb","reservation_created_date":"2021-07-30 16:58:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"17.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"-3.62","currentDayPrice":0,"currentDayDiscount":0,"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":"5312343","reservation_id":"122769","confirmation_number":"SJ12696374571","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"182.58,182.58","nightly_discount":"0,0","subtotal":"365.16","grand_total":"422.82","paid_amount":"0.00","room_type_id":"413","product_id":"1272","siteminder_id":"ABB-HMH55P9CJJ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"365.16","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130428","customer_id":"130428","source_of_creation":"Airbnb","reservation_created_date":"2021-09-09 01:16:28","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"10.74","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","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":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3273890","reservation_id":"118120","confirmation_number":"SJ12625200294","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"239.25,269.25,269.25,239.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1017.00","grand_total":"1144.13","paid_amount":"1144.13","room_type_id":"320","product_id":"1328","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":"125121","customer_id":"125121","source_of_creation":"FE","reservation_created_date":"2021-06-26 15:11:23","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":"","sub_hotel_id":"0","group_rooms":"1302,1303","currentDayPrice":"239.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":"3286956","reservation_id":"119701","confirmation_number":"SJ12646544802","room_stay_from":"2021-09-11","room_stay_to":"2021-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.00,168.00,168.00","nightly_discount":"0.00,0.00,0.00","subtotal":"534.00","grand_total":"600.75","paid_amount":"600.75","room_type_id":"412","product_id":"1866","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":"125325","customer_id":"125325","source_of_creation":"FE","reservation_created_date":"2021-07-20 11:58:33","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":"0","group_rooms":null,"currentDayPrice":"168.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":"3289196","reservation_id":"115890","confirmation_number":"SJ12692775760","room_stay_from":"2021-09-11","room_stay_to":"2021-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"4","nightly_price":"269.25,239.25,239.25","nightly_discount":"0.00,0.00,0.00","subtotal":"747.75","grand_total":"841.22","paid_amount":"841.22","room_type_id":"320","product_id":"1324","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":"122679","customer_id":"122679","source_of_creation":"FE","reservation_created_date":"2021-05-26 01:37:19","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","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":"1271,1272","currentDayPrice":"239.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3250005","reservation_id":"115004","confirmation_number":"SJ12677525080","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.25,269.25,269.25,239.25","nightly_discount":"11.96,13.46,13.46,11.96","subtotal":"1017.00","grand_total":"1086.93","paid_amount":"1086.93","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":"121716","customer_id":"121716","source_of_creation":"PMS","reservation_created_date":"2021-05-11 17:43:41","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":"AAA","sub_hotel_id":"0","group_rooms":"1307,1308","currentDayPrice":"239.25","currentDayDiscount":"11.96","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3250017","reservation_id":"115004","confirmation_number":"SJ12626577734","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.25,269.25,269.25,239.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"967.00","grand_total":"1087.88","paid_amount":"1087.88","room_type_id":"320","product_id":"1910","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":"121716","customer_id":"121716","source_of_creation":"PMS","reservation_created_date":"2021-05-11 17:43:43","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","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":"1309,1310","currentDayPrice":"239.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":"3250021","reservation_id":"115004","confirmation_number":"SJ12657067827","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.25,269.25,269.25,189.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"967.00","grand_total":"1087.88","paid_amount":"1087.88","room_type_id":"320","product_id":"1332","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":"121716","customer_id":"121716","source_of_creation":"PMS","reservation_created_date":"2021-05-11 17:43:42","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":"","sub_hotel_id":"0","group_rooms":"1311,1312","currentDayPrice":"189.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":"5308493","reservation_id":"122505","confirmation_number":"SJ12638435032","room_stay_from":"2021-09-11","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"381.65,296.65","nightly_discount":"0.00,0.00","subtotal":"678.30","grand_total":"763.09","paid_amount":"763.09","room_type_id":"320","product_id":"1323","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130123","customer_id":"130123","source_of_creation":"PMS","reservation_created_date":"2021-09-04 14:17:00","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1269,1270","currentDayPrice":"296.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":"5312248","reservation_id":"122915","confirmation_number":"SJ12687911532","room_stay_from":"2021-09-12","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"8.46","subtotal":"169.15","grand_total":"180.77","paid_amount":"180.77","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125139","customer_id":"125139","source_of_creation":"PMS","reservation_created_date":"2021-09-12 13:38:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"FLRES","sub_hotel_id":"0","currentDayPrice":"169.15","currentDayDiscount":"8.46","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5312316","reservation_id":"122200","confirmation_number":"SJ12656181210","room_stay_from":"2021-09-12","room_stay_to":"2021-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25","nightly_discount":"0.00","subtotal":"149.25","grand_total":"167.90","paid_amount":"83.53","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129772","customer_id":"129772","source_of_creation":"PMS","reservation_created_date":"2021-08-30 14:44:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"149.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":"5312280","reservation_id":"114090","confirmation_number":"SJ12614072145","room_stay_from":"2021-09-11","room_stay_to":"2021-09-12","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.75","nightly_discount":"0.00","subtotal":"156.75","grand_total":"176.35","paid_amount":"63.85","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":"120729","customer_id":"120729","source_of_creation":"PMS","reservation_created_date":"2021-04-28 18:10:43","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","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3280921","reservation_id":"118984","confirmation_number":"SJ12674249874","room_stay_from":"2021-09-12","room_stay_to":"2021-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.57,109.57,109.57,109.57,109.57,109.57,109.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"767.00","grand_total":"767.00","paid_amount":"0.00","room_type_id":"319","product_id":"1943","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-07-09 12:05:10","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":"109.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303054","reservation_id":"113561","confirmation_number":"SJ12628256823","room_stay_from":"2021-09-09","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"520.02","grand_total":"520.02","paid_amount":"168.75","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-04-21 19:37:44","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":"86.67","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303150","reservation_id":"118490","confirmation_number":"SJ12633296873","room_stay_from":"2021-09-10","room_stay_to":"2021-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-07-01 22:04: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":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5307531","reservation_id":"113552","confirmation_number":"SJ12667926061","room_stay_from":"2021-09-12","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1305","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-21 19:00:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5308102","reservation_id":"122460","confirmation_number":"SJ12623541720","room_stay_from":"2021-09-11","room_stay_to":"2021-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.57,109.57,109.57,109.57,109.57,109.57,109.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"767.00","grand_total":"767.00","paid_amount":"0.00","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-09-03 11:59:44","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":"109.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5309813","reservation_id":"119208","confirmation_number":"SJ12688113451","room_stay_from":"2021-09-10","room_stay_to":"2021-09-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1314","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-07-12 21:59:49","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":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5310601","reservation_id":"121126","confirmation_number":"SJ12628582138","room_stay_from":"2021-09-10","room_stay_to":"2021-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.57,109.57,109.57,109.57,109.57,109.57,109.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"767.00","grand_total":"767.00","paid_amount":"767.00","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-08-13 11:48:00","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"109.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5311778","reservation_id":"119010","confirmation_number":"SJ12616111394","room_stay_from":"2021-09-10","room_stay_to":"2021-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"522.00","grand_total":"522.00","paid_amount":"168.75","room_type_id":"319","product_id":"1277","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-07-09 19:25:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303062","reservation_id":"117440","confirmation_number":"SJ12696542932","room_stay_from":"2021-09-11","room_stay_to":"2021-09-16","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"0.00","room_type_id":"319","product_id":"1916","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-06-16 20:58:00","service_canceled_date_time":"2021-09-12 11:21:26","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"tax_exempted_indicator_1","total_paid_amount":"0.00","sub_hotel_id":"0","deltaChange":-87,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5311378","reservation_id":"122312","confirmation_number":"SJ12638788271","room_confirmation_number":"SJ12664605038","room_stay_from":"2021-09-11","room_stay_to":"2021-09-13","room_stay_status":"Active","nightly_price":"100,100","nightly_discount":"0.00,0.00","subtotal":"200.00","grand_total":"201.20","paid_amount":"201.20","product_id":"1777","service_quantity":"1","customer_traveller_id":"129900","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-09-09 21:42:50","reservation_modified_date_time":"2021-09-09 21:42:50","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129900","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","sub_hotel_id":"126","currentDayPrice":"100","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3250006","reservation_id":"115004","confirmation_number":"SJ12669689039","room_confirmation_number":"SJ12677525080","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","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":"121716","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 17:43:41","reservation_modified_date_time":"2021-05-11 17:43:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121716","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":"3250020","reservation_id":"115004","confirmation_number":"SJ12642668009","room_confirmation_number":"SJ12626577734","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","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":"121716","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 17:43:43","reservation_modified_date_time":"2021-05-11 17:44:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121716","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":"3250024","reservation_id":"115004","confirmation_number":"SJ12636410735","room_confirmation_number":"SJ12657067827","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","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":"121716","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 17:43:42","reservation_modified_date_time":"2021-05-11 17:44:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121716","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":"3252321","reservation_id":"115245","confirmation_number":"SJ12654306436","room_confirmation_number":"SJ12640179499","room_stay_from":"2021-09-11","room_stay_to":"2021-09-18","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":"121953","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-15 01:01:09","reservation_modified_date_time":"2021-05-15 17:44:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121953","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":"3256012","reservation_id":"115744","confirmation_number":"SJ12679855893","room_confirmation_number":"SJ12656389710","room_stay_from":"2021-09-08","room_stay_to":"2021-09-15","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":"122519","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-23 19:44:09","reservation_modified_date_time":"2021-05-23 19:44:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122519","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":"3273891","reservation_id":"118120","confirmation_number":"SJ12680691508","room_confirmation_number":"SJ12625200294","room_stay_from":"2021-09-09","room_stay_to":"2021-09-13","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":"125121","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-26 15:11:23","reservation_modified_date_time":"2021-06-26 15:11:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125121","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":"3280922","reservation_id":"118984","confirmation_number":"SJ12668216002","room_confirmation_number":"SJ12674249874","room_stay_from":"2021-09-12","room_stay_to":"2021-09-19","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126084","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-09 12:05:10","reservation_modified_date_time":"2021-07-09 12:05:10","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3282030","reservation_id":"119114","confirmation_number":"SJ12649043474","room_confirmation_number":"SJ12672168517","room_stay_from":"2021-09-10","room_stay_to":"2021-09-14","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":"126233","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-11 15:27:07","reservation_modified_date_time":"2021-07-11 15:27:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126233","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":"3286957","reservation_id":"119701","confirmation_number":"SJ12655793064","room_confirmation_number":"SJ12646544802","room_stay_from":"2021-09-11","room_stay_to":"2021-09-14","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":"125325","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-20 11:58:33","reservation_modified_date_time":"2021-07-20 11:58:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125325","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":"3289199","reservation_id":"115890","confirmation_number":"SJ12661940294","room_confirmation_number":"SJ12692775760","room_stay_from":"2021-09-11","room_stay_to":"2021-09-14","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":"122679","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-26 01:37:19","reservation_modified_date_time":"2021-07-24 21:18:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122679","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":"3299684","reservation_id":"120898","confirmation_number":"SJ12612690711","room_confirmation_number":"SJ12643492296","room_stay_from":"2021-09-10","room_stay_to":"2021-09-15","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":"128297","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-07 18:17:07","reservation_modified_date_time":"2021-08-07 18:17:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128297","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":"3302911","reservation_id":"120253","confirmation_number":"SJ12661574370","room_confirmation_number":"SJ12672369640","room_stay_from":"2021-09-10","room_stay_to":"2021-09-13","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":"127518","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-28 04:38:13","reservation_modified_date_time":"2021-08-15 15:31:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127518","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":"5030985","reservation_id":"121666","confirmation_number":"SJ12682508468","room_confirmation_number":"SJ12664999426","room_stay_from":"2021-09-09","room_stay_to":"2021-09-14","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":"129202","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-21 20:59:09","reservation_modified_date_time":"2021-08-21 20:59:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129202","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":"5303053","reservation_id":"113561","confirmation_number":"SJ12642397102","room_confirmation_number":"SJ12628256823","room_stay_from":"2021-09-09","room_stay_to":"2021-09-15","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 19:37:44","reservation_modified_date_time":"2021-08-25 19:06:17","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":"5303149","reservation_id":"118490","confirmation_number":"SJ12681797759","room_confirmation_number":"SJ12633296873","room_stay_from":"2021-09-10","room_stay_to":"2021-09-17","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":"125526","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-01 22:04:11","reservation_modified_date_time":"2021-08-25 19:06:18","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":"5305861","reservation_id":"121150","confirmation_number":"SJ12644104128","room_confirmation_number":"SJ12663517871","room_stay_from":"2021-09-08","room_stay_to":"2021-09-15","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":"128605","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-13 22:15:08","reservation_modified_date_time":"2021-08-30 13:17:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128605","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":"5307532","reservation_id":"113552","confirmation_number":"SJ12641537800","room_confirmation_number":"SJ12667926061","room_stay_from":"2021-09-12","room_stay_to":"2021-09-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120152","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 19:00:54","reservation_modified_date_time":"2021-09-02 00:15:59","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":"5307819","reservation_id":"120564","confirmation_number":"SJ12693449767","room_confirmation_number":"SJ12639548493","room_stay_from":"2021-09-12","room_stay_to":"2021-09-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":"127896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-02 01:14:07","reservation_modified_date_time":"2021-09-02 18:09:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127896","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":"5308103","reservation_id":"122460","confirmation_number":"SJ12652283900","room_confirmation_number":"SJ12623541720","room_stay_from":"2021-09-11","room_stay_to":"2021-09-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"130058","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-03 11:59:44","reservation_modified_date_time":"2021-09-03 11:59:44","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5308494","reservation_id":"122505","confirmation_number":"SJ12634478224","room_confirmation_number":"SJ12638435032","room_stay_from":"2021-09-11","room_stay_to":"2021-09-13","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":"130123","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-04 14:17:00","reservation_modified_date_time":"2021-09-04 14:17:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130123","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":"5309814","reservation_id":"119208","confirmation_number":"SJ12666657655","room_confirmation_number":"SJ12688113451","room_stay_from":"2021-09-10","room_stay_to":"2021-09-15","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":"126335","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-12 21:59:49","reservation_modified_date_time":"2021-09-07 12:50:25","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":"5310149","reservation_id":"115521","confirmation_number":"SJ12690933493","room_confirmation_number":"SJ12663046246","room_stay_from":"2021-09-11","room_stay_to":"2021-09-17","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":"122266","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-19 20:08:12","reservation_modified_date_time":"2021-09-07 15:59:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122266","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":"5310602","reservation_id":"121126","confirmation_number":"SJ12692933569","room_confirmation_number":"SJ12628582138","room_stay_from":"2021-09-10","room_stay_to":"2021-09-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"128577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-13 11:48:00","reservation_modified_date_time":"2021-09-08 17:58:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5311779","reservation_id":"119010","confirmation_number":"SJ12672759601","room_confirmation_number":"SJ12616111394","room_stay_from":"2021-09-10","room_stay_to":"2021-09-16","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126114","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-09 19:25:50","reservation_modified_date_time":"2021-09-10 19:50:24","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":"5311927","reservation_id":"116854","confirmation_number":"SJ12671860745","room_confirmation_number":"SJ12695761569","room_stay_from":"2021-09-12","room_stay_to":"2021-09-14","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":"123770","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-09 03:57:10","reservation_modified_date_time":"2021-09-11 13:22:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123770","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":"5311933","reservation_id":"122312","confirmation_number":"SJ12638162857","room_confirmation_number":"SJ12664605038","room_stay_from":"2021-09-11","room_stay_to":"2021-09-13","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129900","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-31 21:31:57","reservation_modified_date_time":"2021-09-11 13:31:34","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129900","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.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":"5312218","reservation_id":"110311","confirmation_number":"SJ12654141346","room_confirmation_number":"SJ12697529305","room_stay_from":"2021-09-12","room_stay_to":"2021-09-15","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":"116829","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-14 22:31:10","reservation_modified_date_time":"2021-09-12 11:37:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116829","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":"5312249","reservation_id":"122915","confirmation_number":"SJ12698680123","room_confirmation_number":"SJ12687911532","room_stay_from":"2021-09-12","room_stay_to":"2021-09-13","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":"125139","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-12 13:38:40","reservation_modified_date_time":"2021-09-12 13:53:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125139","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":"5312317","reservation_id":"122200","confirmation_number":"SJ12639955935","room_confirmation_number":"SJ12656181210","room_stay_from":"2021-09-12","room_stay_to":"2021-09-13","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"129772","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-30 14:44:22","reservation_modified_date_time":"2021-09-12 16:48:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129772","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5312420","reservation_id":"121930","confirmation_number":"SJ12646179874","room_confirmation_number":"SJ12632546432","room_stay_from":"2021-09-10","room_stay_to":"2021-09-13","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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"129467","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-25 23:19:16","reservation_modified_date_time":"2021-09-12 21:33:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129467","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5312269","reservation_id":"122878","confirmation_number":"SJ12645661945","room_confirmation_number":"SJ12696602991","room_stay_from":"2022-10-08","room_stay_to":"2022-10-11","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"130541","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-11 16:54:14","reservation_modified_date_time":"2021-09-12 14:43:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130541","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":"5312281","reservation_id":"114090","confirmation_number":"SJ12618484672","room_confirmation_number":"SJ12614072145","room_stay_from":"2021-09-11","room_stay_to":"2021-09-12","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"120729","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-28 18:10:43","reservation_modified_date_time":"2021-09-12 15:20:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120729","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5312303","reservation_id":"120420","confirmation_number":"SJ12670421225","room_confirmation_number":"SJ12633755659","room_stay_from":"2021-09-10","room_stay_to":"2021-09-12","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"127701","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-30 16:58:10","reservation_modified_date_time":"2021-09-12 15:55:41","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127701","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"-50.00","currentDayPrice":0,"currentDayDiscount":0,"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":"5312344","reservation_id":"122769","confirmation_number":"SJ12690584853","room_confirmation_number":"SJ12696374571","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"130428","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-09-09 01:16:28","reservation_modified_date_time":"2021-09-12 17:20:15","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130428","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","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":"5303061","reservation_id":"117440","confirmation_number":"SJ12630861761","room_confirmation_number":"SJ12696542932","room_stay_from":"2021-09-11","room_stay_to":"2021-09-16","room_stay_status":"Canceled","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-06-16 20:58:00","reservation_modified_date_time":"2021-08-25 19:06:17","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"124409","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-12 11:21:26","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","parentRoomStayFrom":"2021-09-11","sub_hotel_id":"0","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5312258","reservation_id":"115890","confirmation_number":"SJ12689388741","room_confirmation_number":"SJ12692775760","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"30.00","paid_amount":"30.00","product_id":"1662","service_quantity":"3","product_name":"Extra Chair or Umbrella","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-12 13:57:22","reservation_modified_date_time":"2021-09-12 13:57:22","customer_id":"122679","parentCustTravId":"122679","customer_traveller_id":"122679","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-09-11","sub_hotel_id":"0","currentDayPrice":"27.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"5312259","reservation_id":"118120","confirmation_number":"SJ12673595472","room_confirmation_number":"SJ12625200294","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-09-12 14:12:41","reservation_modified_date_time":"2021-09-12 14:12:41","customer_id":"125121","parentCustTravId":"125121","customer_traveller_id":"125121","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-09-09","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"}]},{"room_stay_id":"5312304","reservation_id":"122881","confirmation_number":"SJ12640676651","room_confirmation_number":"SJ12688593260","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.26","paid_amount":"56.26","product_id":"1710","service_quantity":"2","product_name":"Late Departure Check-Out","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-12 15:57:10","reservation_modified_date_time":"2021-09-12 15:57:10","customer_id":"130546","parentCustTravId":"130546","customer_traveller_id":"130546","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-09-11","sub_hotel_id":"126","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]},{"room_stay_id":"5312466","reservation_id":"122944","confirmation_number":"SJ12618066632","room_confirmation_number":"SJ12610106673","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"4.00","paid_amount":"4.00","product_id":"1667","service_quantity":"2","product_name":"Koozie","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-12 23:57:41","reservation_modified_date_time":"2021-09-12 23:57:41","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"}]},{"room_stay_id":"5312504","reservation_id":"122955","confirmation_number":"SJ12628677599","room_confirmation_number":"SJ12691415578","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"4.00","paid_amount":"4.00","product_id":"1667","service_quantity":"2","product_name":"Koozie","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-13 02:37:51","reservation_modified_date_time":"2021-09-13 02:37:51","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":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}