{ "metric": "recon_open", "label": "Still open", "note": "Not yet explained or resolved.", "table": "recon_item", "sort": null, "dir": "desc", "filters": {}, "total": 83, "sums": { "nights": 187, "booking_amount": 54841.87, "folio_amount": 47979.68, "variance": 10008.87 }, "rows": [ { "item_id": "RI-8854236", "period": "2026-08", "booking_id": "RS-8854236", "duty_id": "D-514236", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "R. Maes", "station": "LGG", "property_id": "P-110", "hotel": "Van der Valk Liege", "check_in": "2026-08-16", "check_out": "2026-08-20", "nights": 4, "booking_amount": 1198.05, "card_auth": 1223.05, "card_settled": 2507.86, "folio_amount": 1253.93, "variance": 1253.93, "variance_pct": 104.66, "variance_category": "unexplained", "match_state": "duplicate", "exception_type": "duplicate_charge", "state": "open", "resolution": null, "opened_at": "2026-08-20T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-19", "age_days": 24, "auto_resolved": 0 }, { "item_id": "RI-8854998", "period": "2026-08", "booking_id": "RS-8854998", "duty_id": "D-514998", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "G. Berger", "station": "MAD", "property_id": "P-136", "hotel": "Novotel Madrid Barajas", "check_in": "2026-08-28", "check_out": "2026-08-30", "nights": 2, "booking_amount": 595.41, "card_auth": 620.41, "card_settled": 1262.34, "folio_amount": 631.17, "variance": 631.17, "variance_pct": 106.01, "variance_category": "unexplained", "match_state": "duplicate", "exception_type": "duplicate_charge", "state": "investigating", "resolution": null, "opened_at": "2026-08-30T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-29", "age_days": 2, "auto_resolved": 0 }, { "item_id": "RI-8855007", "period": "2026-08", "booking_id": "RS-8855007", "duty_id": "D-515007", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "P. Fontaine", "station": "MAD", "property_id": "P-136", "hotel": "Novotel Madrid Barajas", "check_in": "2026-08-23", "check_out": "2026-08-25", "nights": 2, "booking_amount": 629.25, "card_auth": 654.25, "card_settled": 1258.5, "folio_amount": 629.25, "variance": 629.25, "variance_pct": 100, "variance_category": "unexplained", "match_state": "duplicate", "exception_type": "duplicate_charge", "state": "investigating", "resolution": null, "opened_at": "2026-08-25T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-24", "age_days": 12, "auto_resolved": 0 }, { "item_id": "RI-8853545", "period": "2026-08", "booking_id": "RS-8853545", "duty_id": "D-513545", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "A. Quinn", "station": "LGG", "property_id": "P-111", "hotel": "Ibis Liege Centre", "check_in": "2026-08-09", "check_out": "2026-08-11", "nights": 2, "booking_amount": 554.28, "card_auth": 579.28, "card_settled": 554.28, "folio_amount": 998.79, "variance": 444.51, "variance_pct": 80.2, "variance_category": "extra_night", "match_state": "unmatched", "exception_type": "off_platform_modification", "state": "investigating", "resolution": null, "opened_at": "2026-08-11T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-10", "age_days": 9, "auto_resolved": 0 }, { "item_id": "RI-8853758", "period": "2026-08", "booking_id": "RS-8853758", "duty_id": "D-513758", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "K. Mulligan", "station": "LGG", "property_id": "P-110", "hotel": "Van der Valk Liege", "check_in": "2026-08-11", "check_out": "2026-08-14", "nights": 3, "booking_amount": 781.38, "card_auth": 806.38, "card_settled": 1223.91, "folio_amount": 1223.91, "variance": 410.42, "variance_pct": 52.53, "variance_category": "incidentals", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-14T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-13", "age_days": 15, "auto_resolved": 0 }, { "item_id": "RI-8854730", "period": "2026-08", "booking_id": "RS-8854730", "duty_id": "D-514730", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "J. Delacroix", "station": "CDG", "property_id": "P-126", "hotel": "Novotel Paris CDG", "check_in": "2026-08-17", "check_out": "2026-08-18", "nights": 1, "booking_amount": 296.64, "card_auth": 321.64, "card_settled": 716.58, "folio_amount": 716.58, "variance": 390.9, "variance_pct": 131.78, "variance_category": "rate_change", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-18T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-17", "age_days": 35, "auto_resolved": 0 }, { "item_id": "RI-8854152", "period": "2026-08", "booking_id": "RS-8854152", "duty_id": "D-514152", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "B. Dubois", "station": "JNB", "property_id": "P-125", "hotel": "InterContinental OR Tambo", "check_in": "2026-08-26", "check_out": "2026-08-27", "nights": 1, "booking_amount": 278.92, "card_auth": 303.92, "card_settled": 676.69, "folio_amount": 676.69, "variance": 375.36, "variance_pct": 134.58, "variance_category": "incidentals", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-27T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-26", "age_days": 32, "auto_resolved": 0 }, { "item_id": "RI-8854146", "period": "2026-08", "booking_id": "RS-8854146", "duty_id": "D-514146", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "S. Declerck", "station": "DXB", "property_id": "P-122", "hotel": "Millennium Airport Hotel Dubai", "check_in": "2026-08-05", "check_out": "2026-08-09", "nights": 4, "booking_amount": 1198.34, "card_auth": 1223.34, "card_settled": 1579.13, "folio_amount": 1579.13, "variance": 354.29, "variance_pct": 29.57, "variance_category": "rate_change", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-09T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-08", "age_days": 31, "auto_resolved": 0 }, { "item_id": "RI-8854621", "period": "2026-08", "booking_id": "RS-8854621", "duty_id": "D-514621", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "R. Verhoeven", "station": "BRU", "property_id": "P-118", "hotel": "NH Brussels Airport", "check_in": "2026-08-22", "check_out": "2026-08-25", "nights": 3, "booking_amount": 978.06, "card_auth": 1003.06, "card_settled": 1320.6, "folio_amount": 1320.6, "variance": 331.62, "variance_pct": 33.91, "variance_category": "early_departure", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-25T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-24", "age_days": 1, "auto_resolved": 0 }, { "item_id": "RI-8853882", "period": "2026-08", "booking_id": "RS-8853882", "duty_id": "D-513882", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "L. Janssens", "station": "JNB", "property_id": "P-125", "hotel": "InterContinental OR Tambo", "check_in": "2026-08-11", "check_out": "2026-08-14", "nights": 3, "booking_amount": 719.76, "card_auth": 450.89, "card_settled": 450.89, "folio_amount": 762.82, "variance": 311.93, "variance_pct": 43.34, "variance_category": "unexplained", "match_state": "unmatched", "exception_type": "partial_authorization", "state": "open", "resolution": null, "opened_at": "2026-08-14T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-13", "age_days": 2, "auto_resolved": 0 }, { "item_id": "RI-8853593", "period": "2026-08", "booking_id": "RS-8853593", "duty_id": "D-513593", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "D. Doyle", "station": "BHX", "property_id": "P-113", "hotel": "Novotel Birmingham Airport", "check_in": "2026-08-24", "check_out": "2026-08-26", "nights": 2, "booking_amount": 648.61, "card_auth": 673.61, "card_settled": 957.27, "folio_amount": 957.27, "variance": 308.66, "variance_pct": 47.59, "variance_category": "extra_night", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-26T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-25", "age_days": 25, "auto_resolved": 0 }, { "item_id": "RI-8853014", "period": "2026-08", "booking_id": "RS-8853014", "duty_id": "D-513014", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "D. Nolan", "station": "BHX", "property_id": "P-114", "hotel": "Ibis Birmingham Airport", "check_in": "2026-08-17", "check_out": "2026-08-21", "nights": 4, "booking_amount": 1344.38, "card_auth": 1369.38, "card_settled": 1651.68, "folio_amount": 1651.68, "variance": 307.3, "variance_pct": 22.86, "variance_category": "early_departure", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-21T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-20", "age_days": 12, "auto_resolved": 0 }, { "item_id": "RI-8854855", "period": "2026-08", "booking_id": "RS-8854855", "duty_id": "D-514855", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "O. Delacroix", "station": "LYS", "property_id": "P-129", "hotel": "NH Lyon Airport", "check_in": "2026-08-14", "check_out": "2026-08-17", "nights": 3, "booking_amount": 800.4, "card_auth": 523.7, "card_settled": 523.7, "folio_amount": 828.63, "variance": 304.93, "variance_pct": 38.1, "variance_category": "unexplained", "match_state": "unmatched", "exception_type": "partial_authorization", "state": "investigating", "resolution": null, "opened_at": "2026-08-17T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-16", "age_days": 37, "auto_resolved": 0 }, { "item_id": "RI-8852921", "period": "2026-08", "booking_id": "RS-8852921", "duty_id": "D-512921", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "O. Cassidy", "station": "LGG", "property_id": "P-111", "hotel": "Ibis Liege Centre", "check_in": "2026-08-25", "check_out": "2026-08-28", "nights": 3, "booking_amount": 1016.9, "card_auth": 1041.9, "card_settled": 1340.68, "folio_amount": 1340.68, "variance": 271.18, "variance_pct": 26.67, "variance_category": "incidentals", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-28T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-27", "age_days": 25, "auto_resolved": 0 }, { "item_id": "RI-8852861", "period": "2026-08", "booking_id": "RS-8852861", "duty_id": "D-512861", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "D. Kavanagh", "station": "CGN", "property_id": "P-108", "hotel": "Leonardo Hotel Koln", "check_in": "2026-08-03", "check_out": "2026-08-06", "nights": 3, "booking_amount": 815.88, "card_auth": 840.88, "card_settled": 1116.03, "folio_amount": 1116.03, "variance": 270.83, "variance_pct": 33.19, "variance_category": "rate_change", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-06T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-05", "age_days": 20, "auto_resolved": 0 }, { "item_id": "RI-8853304", "period": "2026-08", "booking_id": "RS-8853304", "duty_id": "D-513304", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "G. Healy", "station": "CGN", "property_id": "P-109", "hotel": "Novotel Koln City", "check_in": "2026-08-05", "check_out": "2026-08-07", "nights": 2, "booking_amount": 583.65, "card_auth": 608.65, "card_settled": 883.04, "folio_amount": 883.04, "variance": 267.13, "variance_pct": 45.77, "variance_category": "extra_night", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-07T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-06", "age_days": 29, "auto_resolved": 0 }, { "item_id": "RI-8852867", "period": "2026-08", "booking_id": "RS-8852867", "duty_id": "D-512867", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "R. Cassidy", "station": "EMA", "property_id": "P-104", "hotel": "Hilton East Midlands", "check_in": "2026-08-16", "check_out": "2026-08-19", "nights": 3, "booking_amount": 884.49, "card_auth": 909.49, "card_settled": 1168.13, "folio_amount": 1168.13, "variance": 255.55, "variance_pct": 28.89, "variance_category": "early_departure", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-19T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-18", "age_days": 3, "auto_resolved": 0 }, { "item_id": "RI-8855091", "period": "2026-08", "booking_id": "RS-8855091", "duty_id": "D-515091", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "E. Berger", "station": "MRS", "property_id": "P-131", "hotel": "Best Western Marseille Airport", "check_in": "2026-08-01", "check_out": "2026-08-02", "nights": 1, "booking_amount": 272.11, "card_auth": 297.11, "card_settled": 508.3, "folio_amount": 508.3, "variance": 236.19, "variance_pct": 86.8, "variance_category": "rate_change", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-02T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-01", "age_days": 7, "auto_resolved": 0 }, { "item_id": "RI-8855162", "period": "2026-08", "booking_id": "RS-8855162", "duty_id": "D-515162", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "T. Perrin", "station": "CDG", "property_id": "P-126", "hotel": "Novotel Paris CDG", "check_in": "2026-08-12", "check_out": "2026-08-15", "nights": 3, "booking_amount": 890.04, "card_auth": 915.04, "card_settled": 1116.63, "folio_amount": 1116.63, "variance": 226.59, "variance_pct": 25.46, "variance_category": "incidentals", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-15T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-14", "age_days": 37, "auto_resolved": 0 }, { "item_id": "RI-8855098", "period": "2026-08", "booking_id": "RS-8855098", "duty_id": "D-515098", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "T. Chevalier", "station": "CDG", "property_id": "P-127", "hotel": "Pullman Paris CDG", "check_in": "2026-08-05", "check_out": "2026-08-07", "nights": 2, "booking_amount": 653.93, "card_auth": 678.93, "card_settled": 882.29, "folio_amount": 882.29, "variance": 217.46, "variance_pct": 33.25, "variance_category": "incidentals", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-07T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-06", "age_days": 19, "auto_resolved": 0 }, { "item_id": "RI-8852930", "period": "2026-08", "booking_id": "RS-8852930", "duty_id": "D-512930", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "N. O Conaill", "station": "STN", "property_id": "P-116", "hotel": "Hampton by Hilton Stansted", "check_in": "2026-08-16", "check_out": "2026-08-19", "nights": 3, "booking_amount": 905.25, "card_auth": 702.97, "card_settled": 702.97, "folio_amount": 905.25, "variance": 202.28, "variance_pct": 22.35, "variance_category": "unexplained", "match_state": "unmatched", "exception_type": "partial_authorization", "state": "investigating", "resolution": null, "opened_at": "2026-08-19T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-18", "age_days": 26, "auto_resolved": 0 }, { "item_id": "RI-8854219", "period": "2026-08", "booking_id": "RS-8854219", "duty_id": "D-514219", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "R. Lambert", "station": "LGG", "property_id": "P-111", "hotel": "Ibis Liege Centre", "check_in": "2026-08-20", "check_out": "2026-08-23", "nights": 3, "booking_amount": 827.46, "card_auth": 852.46, "card_settled": 1058.13, "folio_amount": 1058.13, "variance": 181.9, "variance_pct": 21.98, "variance_category": "early_departure", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-23T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-22", "age_days": 33, "auto_resolved": 0 }, { "item_id": "RI-8853034", "period": "2026-08", "booking_id": "RS-8853034", "duty_id": "D-513034", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "B. Brennan", "station": "DUB", "property_id": "P-101", "hotel": "Clayton Hotel Dublin Airport", "check_in": "2026-08-02", "check_out": "2026-08-05", "nights": 3, "booking_amount": 713.91, "card_auth": 738.91, "card_settled": 888.95, "folio_amount": 888.95, "variance": 175.04, "variance_pct": 24.52, "variance_category": "rate_change", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-05T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-04", "age_days": 24, "auto_resolved": 0 }, { "item_id": "RI-8854945", "period": "2026-08", "booking_id": "RS-8854945", "duty_id": "D-514945", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "B. Chevalier", "station": "CDG", "property_id": "P-127", "hotel": "Pullman Paris CDG", "check_in": "2026-08-12", "check_out": "2026-08-13", "nights": 1, "booking_amount": 294.52, "card_auth": 319.52, "card_settled": 468.54, "folio_amount": 468.54, "variance": 163.04, "variance_pct": 55.36, "variance_category": "tax_fees", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-13T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-12", "age_days": 24, "auto_resolved": 0 }, { "item_id": "RI-8853960", "period": "2026-08", "booking_id": "RS-8853960", "duty_id": "D-513960", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "H. De Smet", "station": "DXB", "property_id": "P-123", "hotel": "Le Meridien Dubai", "check_in": "2026-08-11", "check_out": "2026-08-14", "nights": 3, "booking_amount": 1053.32, "card_auth": 1078.32, "card_settled": 1230.49, "folio_amount": 1230.49, "variance": 162.41, "variance_pct": 15.42, "variance_category": "incidentals", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-14T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-13", "age_days": 23, "auto_resolved": 0 }, { "item_id": "RI-8853050", "period": "2026-08", "booking_id": "RS-8853050", "duty_id": "D-513050", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "C. Kavanagh", "station": "CGN", "property_id": "P-107", "hotel": "Ibis Koln Messe", "check_in": "2026-08-30", "check_out": "2026-09-01", "nights": 2, "booking_amount": 529.02, "card_auth": 554.02, "card_settled": 675.35, "folio_amount": 675.35, "variance": 146.33, "variance_pct": 27.66, "variance_category": "tax_fees", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-09-01T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-10-01", "age_days": 26, "auto_resolved": 0 }, { "item_id": "RI-8854043", "period": "2026-08", "booking_id": "RS-8854043", "duty_id": "D-514043", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "C. Vermeulen", "station": "LGG", "property_id": "P-110", "hotel": "Van der Valk Liege", "check_in": "2026-08-22", "check_out": "2026-08-25", "nights": 3, "booking_amount": 874.68, "card_auth": 899.68, "card_settled": 1013.86, "folio_amount": 1013.86, "variance": 139.18, "variance_pct": 15.91, "variance_category": "rate_change", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-25T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-24", "age_days": 11, "auto_resolved": 0 }, { "item_id": "RI-8853325", "period": "2026-08", "booking_id": "RS-8853325", "duty_id": "D-513325", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "N. Nolan", "station": "STN", "property_id": "P-115", "hotel": "Radisson Blu Stansted", "check_in": "2026-08-31", "check_out": "2026-09-01", "nights": 1, "booking_amount": 318.05, "card_auth": 179.14, "card_settled": 179.14, "folio_amount": 318.05, "variance": 138.91, "variance_pct": 43.68, "variance_category": "unexplained", "match_state": "unmatched", "exception_type": "partial_authorization", "state": "open", "resolution": null, "opened_at": "2026-09-01T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-10-01", "age_days": 19, "auto_resolved": 0 }, { "item_id": "RI-8854642", "period": "2026-08", "booking_id": "RS-8854642", "duty_id": "D-514642", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "E. Maes", "station": "HKG", "property_id": "P-121", "hotel": "Hong Kong SkyCity Marriott", "check_in": "2026-08-13", "check_out": "2026-08-16", "nights": 3, "booking_amount": 890.13, "card_auth": 915.13, "card_settled": 1021.38, "folio_amount": 1021.38, "variance": 131.25, "variance_pct": 14.75, "variance_category": "early_departure", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-16T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-15", "age_days": 36, "auto_resolved": 0 }, { "item_id": "RI-8853466", "period": "2026-08", "booking_id": "RS-8853466", "duty_id": "D-513466", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "O. Byrne", "station": "LGG", "property_id": "P-110", "hotel": "Van der Valk Liege", "check_in": "2026-08-28", "check_out": "2026-08-30", "nights": 2, "booking_amount": 522.74, "card_auth": 547.74, "card_settled": 669.6, "folio_amount": 669.6, "variance": 120.42, "variance_pct": 23.04, "variance_category": "extra_night", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-30T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-29", "age_days": 28, "auto_resolved": 0 }, { "item_id": "RI-8853845", "period": "2026-08", "booking_id": "RS-8853845", "duty_id": "D-513845", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "A. Vermeulen", "station": "CDG", "property_id": "P-128", "hotel": "Ibis Paris CDG", "check_in": "2026-08-13", "check_out": "2026-08-15", "nights": 2, "booking_amount": 629.98, "card_auth": 654.98, "card_settled": 774.14, "folio_amount": 774.14, "variance": 113.25, "variance_pct": 17.98, "variance_category": "tax_fees", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-15T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-14", "age_days": 20, "auto_resolved": 0 }, { "item_id": "RI-8853521", "period": "2026-08", "booking_id": "RS-8853521", "duty_id": "D-513521", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "S. Nolan", "station": "EMA", "property_id": "P-104", "hotel": "Hilton East Midlands", "check_in": "2026-08-07", "check_out": "2026-08-09", "nights": 2, "booking_amount": 583.34, "card_auth": 608.34, "card_settled": 705.4, "folio_amount": 705.4, "variance": 85.14, "variance_pct": 14.6, "variance_category": "extra_night", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-09T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-08", "age_days": 4, "auto_resolved": 0 }, { "item_id": "RI-8855170", "period": "2026-08", "booking_id": "RS-8855170", "duty_id": "D-515170", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "G. Marchand", "station": "LYS", "property_id": "P-129", "hotel": "NH Lyon Airport", "check_in": "2026-08-02", "check_out": "2026-08-05", "nights": 3, "booking_amount": 973.07, "card_auth": 998.07, "card_settled": 1051.69, "folio_amount": 1051.69, "variance": 66.58, "variance_pct": 6.84, "variance_category": "tax_fees", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-05T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-04", "age_days": 10, "auto_resolved": 0 }, { "item_id": "RI-8855175", "period": "2026-08", "booking_id": "RS-8855175", "duty_id": "D-515175", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "D. Aubert", "station": "MRS", "property_id": "P-132", "hotel": "Holiday Inn Marseille", "check_in": "2026-08-25", "check_out": "2026-08-29", "nights": 4, "booking_amount": 1060.84, "card_auth": 1085.84, "card_settled": 1125.29, "folio_amount": 1125.29, "variance": 64.45, "variance_pct": 6.08, "variance_category": "extra_night", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-29T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-28", "age_days": 17, "auto_resolved": 0 }, { "item_id": "RI-8852843", "period": "2026-08", "booking_id": "RS-8852843", "duty_id": "D-512843", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "H. Kavanagh", "station": "DUB", "property_id": "P-101", "hotel": "Clayton Hotel Dublin Airport", "check_in": "2026-08-05", "check_out": "2026-08-08", "nights": 3, "booking_amount": 799.14, "card_auth": 824.14, "card_settled": 890.61, "folio_amount": 890.61, "variance": 60.82, "variance_pct": 7.61, "variance_category": "extra_night", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-08T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-07", "age_days": 33, "auto_resolved": 0 }, { "item_id": "RI-8853507", "period": "2026-08", "booking_id": "RS-8853507", "duty_id": "D-513507", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "V. Doyle", "station": "LGG", "property_id": "P-111", "hotel": "Ibis Liege Centre", "check_in": "2026-08-23", "check_out": "2026-08-24", "nights": 1, "booking_amount": 278.32, "card_auth": 303.32, "card_settled": 328.93, "folio_amount": 328.93, "variance": 50.61, "variance_pct": 18.18, "variance_category": "tax_fees", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-24T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-23", "age_days": 36, "auto_resolved": 0 }, { "item_id": "RI-8852927", "period": "2026-08", "booking_id": "RS-8852927", "duty_id": "D-512927", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "C. Kavanagh", "station": "EMA", "property_id": "P-104", "hotel": "Hilton East Midlands", "check_in": "2026-08-15", "check_out": "2026-08-16", "nights": 1, "booking_amount": 298.37, "card_auth": 323.37, "card_settled": 342.01, "folio_amount": 342.01, "variance": 43.64, "variance_pct": 14.63, "variance_category": "tax_fees", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-16T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-15", "age_days": 14, "auto_resolved": 0 }, { "item_id": "RI-8853287", "period": "2026-08", "booking_id": "RS-8853287", "duty_id": "D-513287", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "B. Brennan", "station": "CGN", "property_id": "P-107", "hotel": "Ibis Koln Messe", "check_in": "2026-08-16", "check_out": "2026-08-20", "nights": 4, "booking_amount": 1012.68, "card_auth": 1037.68, "card_settled": 1063.8, "folio_amount": 1063.8, "variance": 39.84, "variance_pct": 3.93, "variance_category": "tax_fees", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-20T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-19", "age_days": 14, "auto_resolved": 0 }, { "item_id": "RI-8853478", "period": "2026-08", "booking_id": "RS-8853478", "duty_id": "D-513478", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "D. Nolan", "station": "LGG", "property_id": "P-110", "hotel": "Van der Valk Liege", "check_in": "2026-08-08", "check_out": "2026-08-09", "nights": 1, "booking_amount": 262.54, "card_auth": 287.54, "card_settled": 320.4, "folio_amount": 320.4, "variance": 38.1, "variance_pct": 14.51, "variance_category": "rate_change", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-09T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-08", "age_days": 11, "auto_resolved": 0 }, { "item_id": "RI-8854441", "period": "2026-08", "booking_id": "RS-8854441", "duty_id": "D-514441", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "T. Maes", "station": "BRU", "property_id": "P-118", "hotel": "NH Brussels Airport", "check_in": "2026-08-17", "check_out": "2026-08-18", "nights": 1, "booking_amount": 326.9, "card_auth": 351.9, "card_settled": 357.27, "folio_amount": 357.27, "variance": 30.37, "variance_pct": 9.29, "variance_category": "early_departure", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-18T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-17", "age_days": 28, "auto_resolved": 0 }, { "item_id": "RI-8854810", "period": "2026-08", "booking_id": "RS-8854810", "duty_id": "D-514810", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "M. Marchand", "station": "MRS", "property_id": "P-132", "hotel": "Holiday Inn Marseille", "check_in": "2026-08-04", "check_out": "2026-08-05", "nights": 1, "booking_amount": 290.59, "card_auth": 315.59, "card_settled": 320.42, "folio_amount": 320.42, "variance": 29.83, "variance_pct": 10.27, "variance_category": "rate_change", "match_state": "variance", "exception_type": "amount_variance", "state": "open", "resolution": null, "opened_at": "2026-08-05T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-04", "age_days": 40, "auto_resolved": 0 }, { "item_id": "RI-8853108", "period": "2026-08", "booking_id": "RS-8853108", "duty_id": "D-513108", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "N. Byrne", "station": "DUB", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "check_in": "2026-08-22", "check_out": "2026-08-26", "nights": 4, "booking_amount": 1045.88, "card_auth": 1070.88, "card_settled": 1089.32, "folio_amount": 1089.32, "variance": 26.28, "variance_pct": 2.51, "variance_category": "tax_fees", "match_state": "variance", "exception_type": "amount_variance", "state": "investigating", "resolution": null, "opened_at": "2026-08-26T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-25", "age_days": 13, "auto_resolved": 0 }, { "item_id": "RI-8852948", "period": "2026-08", "booking_id": "RS-8852948", "duty_id": "D-512948", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "K. Nolan", "station": "BHX", "property_id": "P-114", "hotel": "Ibis Birmingham Airport", "check_in": "2026-08-18", "check_out": "2026-08-20", "nights": 2, "booking_amount": 564.5, "card_auth": 589.5, "card_settled": null, "folio_amount": 585.47, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "declined_not_reissued", "state": "open", "resolution": null, "opened_at": "2026-08-20T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-19", "age_days": 37, "auto_resolved": 0 }, { "item_id": "RI-8853206", "period": "2026-08", "booking_id": "RS-8853206", "duty_id": "D-513206", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "A. Cassidy", "station": "DUB", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "check_in": "2026-08-05", "check_out": "2026-08-06", "nights": 1, "booking_amount": 292.76, "card_auth": 317.76, "card_settled": null, "folio_amount": 292.76, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "charge_after_expiry", "state": "investigating", "resolution": null, "opened_at": "2026-08-06T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-05", "age_days": 39, "auto_resolved": 0 }, { "item_id": "RI-8853229", "period": "2026-08", "booking_id": "RS-8853229", "duty_id": "D-513229", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "T. Doyle", "station": "CGN", "property_id": "P-108", "hotel": "Leonardo Hotel Koln", "check_in": "2026-08-23", "check_out": "2026-08-27", "nights": 4, "booking_amount": 1093.44, "card_auth": 1118.44, "card_settled": 1128.6, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "investigating", "resolution": null, "opened_at": "2026-08-27T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-26", "age_days": 34, "auto_resolved": 0 }, { "item_id": "RI-8853339", "period": "2026-08", "booking_id": "RS-8853339", "duty_id": "D-513339", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "A. Quinn", "station": "LGG", "property_id": "P-110", "hotel": "Van der Valk Liege", "check_in": "2026-08-31", "check_out": "2026-09-01", "nights": 1, "booking_amount": 262.17, "card_auth": 287.17, "card_settled": null, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "card_never_charged", "state": "open", "resolution": null, "opened_at": "2026-09-01T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-10-01", "age_days": 18, "auto_resolved": 0 }, { "item_id": "RI-8853426", "period": "2026-08", "booking_id": "RS-8853426", "duty_id": "D-513426", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "O. Byrne", "station": "CGN", "property_id": "P-107", "hotel": "Ibis Koln Messe", "check_in": "2026-08-19", "check_out": "2026-08-21", "nights": 2, "booking_amount": 510.78, "card_auth": 535.78, "card_settled": null, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "card_never_charged", "state": "investigating", "resolution": null, "opened_at": "2026-08-21T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-20", "age_days": 23, "auto_resolved": 0 }, { "item_id": "RI-8853438", "period": "2026-08", "booking_id": "RS-8853438", "duty_id": "D-513438", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "G. Byrne", "station": "CGN", "property_id": "P-108", "hotel": "Leonardo Hotel Koln", "check_in": "2026-08-24", "check_out": "2026-08-28", "nights": 4, "booking_amount": 1237.81, "card_auth": 1262.81, "card_settled": null, "folio_amount": 1247.46, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "declined_not_reissued", "state": "investigating", "resolution": null, "opened_at": "2026-08-28T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-27", "age_days": 17, "auto_resolved": 0 }, { "item_id": "RI-8853467", "period": "2026-08", "booking_id": "RS-8853467", "duty_id": "D-513467", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "B. Byrne", "station": "CGN", "property_id": "P-108", "hotel": "Leonardo Hotel Koln", "check_in": "2026-08-01", "check_out": "2026-08-04", "nights": 3, "booking_amount": 848.01, "card_auth": 873.01, "card_settled": null, "folio_amount": 857.68, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "charge_after_expiry", "state": "investigating", "resolution": null, "opened_at": "2026-08-04T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-03", "age_days": 37, "auto_resolved": 0 }, { "item_id": "RI-8853486", "period": "2026-08", "booking_id": "RS-8853486", "duty_id": "D-513486", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "O. Quinn", "station": "CGN", "property_id": "P-107", "hotel": "Ibis Koln Messe", "check_in": "2026-08-15", "check_out": "2026-08-16", "nights": 1, "booking_amount": 253.41, "card_auth": 278.41, "card_settled": 253.41, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "open", "resolution": null, "opened_at": "2026-08-16T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-15", "age_days": 12, "auto_resolved": 0 }, { "item_id": "RI-8853533", "period": "2026-08", "booking_id": "RS-8853533", "duty_id": "D-513533", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "E. Doyle", "station": "CGN", "property_id": "P-107", "hotel": "Ibis Koln Messe", "check_in": "2026-08-26", "check_out": "2026-08-27", "nights": 1, "booking_amount": 318.82, "card_auth": 343.82, "card_settled": null, "folio_amount": 318.82, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "declined_not_reissued", "state": "investigating", "resolution": null, "opened_at": "2026-08-27T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-26", "age_days": 27, "auto_resolved": 0 }, { "item_id": "RI-8853602", "period": "2026-08", "booking_id": "RS-8853602", "duty_id": "D-513602", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "G. Healy", "station": "EMA", "property_id": "P-104", "hotel": "Hilton East Midlands", "check_in": "2026-08-26", "check_out": "2026-08-28", "nights": 2, "booking_amount": 694.93, "card_auth": 719.93, "card_settled": 694.93, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "open", "resolution": null, "opened_at": "2026-08-28T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-27", "age_days": 20, "auto_resolved": 0 }, { "item_id": "RI-8853642", "period": "2026-08", "booking_id": "RS-8853642", "duty_id": "D-513642", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "M. O Conaill", "station": "DUB", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "check_in": "2026-08-20", "check_out": "2026-08-22", "nights": 2, "booking_amount": 553.19, "card_auth": 578.19, "card_settled": 587.37, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "investigating", "resolution": null, "opened_at": "2026-08-22T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-21", "age_days": 8, "auto_resolved": 0 }, { "item_id": "RI-8853682", "period": "2026-08", "booking_id": "RS-8853682", "duty_id": "D-513682", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "T. Quinn", "station": "EMA", "property_id": "P-105", "hotel": "Holiday Inn Castle Donington", "check_in": "2026-08-15", "check_out": "2026-08-17", "nights": 2, "booking_amount": 583.96, "card_auth": 608.96, "card_settled": 583.96, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "open", "resolution": null, "opened_at": "2026-08-17T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-16", "age_days": 16, "auto_resolved": 0 }, { "item_id": "RI-8853684", "period": "2026-08", "booking_id": "RS-8853684", "duty_id": "D-513684", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "G. Mulligan", "station": "EMA", "property_id": "P-106", "hotel": "Premier Inn Kegworth", "check_in": "2026-08-06", "check_out": "2026-08-09", "nights": 3, "booking_amount": 898.82, "card_auth": 923.82, "card_settled": 931.36, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "open", "resolution": null, "opened_at": "2026-08-09T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-08", "age_days": 22, "auto_resolved": 0 }, { "item_id": "RI-8853763", "period": "2026-08", "booking_id": "RS-8853763", "duty_id": "D-513763", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "P. Byrne", "station": "STN", "property_id": "P-116", "hotel": "Hampton by Hilton Stansted", "check_in": "2026-08-11", "check_out": "2026-08-13", "nights": 2, "booking_amount": 607.22, "card_auth": 632.22, "card_settled": null, "folio_amount": 607.22, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "declined_not_reissued", "state": "investigating", "resolution": null, "opened_at": "2026-08-13T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-12", "age_days": 1, "auto_resolved": 0 }, { "item_id": "RI-8853787", "period": "2026-08", "booking_id": "RS-8853787", "duty_id": "D-513787", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "O. Healy", "station": "LGG", "property_id": "P-111", "hotel": "Ibis Liege Centre", "check_in": "2026-08-20", "check_out": "2026-08-21", "nights": 1, "booking_amount": 277.43, "card_auth": 302.43, "card_settled": null, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "card_never_charged", "state": "open", "resolution": null, "opened_at": "2026-08-21T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-20", "age_days": 21, "auto_resolved": 0 }, { "item_id": "RI-8853810", "period": "2026-08", "booking_id": "RS-8853810", "duty_id": "D-513810", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "crew_name": "O. Byrne", "station": "BHX", "property_id": "P-113", "hotel": "Novotel Birmingham Airport", "check_in": "2026-08-16", "check_out": "2026-08-17", "nights": 1, "booking_amount": 279.93, "card_auth": 304.93, "card_settled": 279.93, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "investigating", "resolution": null, "opened_at": "2026-08-17T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-16", "age_days": 27, "auto_resolved": 0 }, { "item_id": "RI-8853907", "period": "2026-08", "booking_id": "RS-8853907", "duty_id": "D-513907", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "J. De Smet", "station": "DXB", "property_id": "P-123", "hotel": "Le Meridien Dubai", "check_in": "2026-08-20", "check_out": "2026-08-24", "nights": 4, "booking_amount": 1339.92, "card_auth": 1364.92, "card_settled": null, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "card_never_charged", "state": "investigating", "resolution": null, "opened_at": "2026-08-24T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-23", "age_days": 8, "auto_resolved": 0 }, { "item_id": "RI-8853929", "period": "2026-08", "booking_id": "RS-8853929", "duty_id": "D-513929", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "H. De Smet", "station": "DXB", "property_id": "P-122", "hotel": "Millennium Airport Hotel Dubai", "check_in": "2026-08-20", "check_out": "2026-08-21", "nights": 1, "booking_amount": 289.11, "card_auth": 314.11, "card_settled": 289.11, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "investigating", "resolution": null, "opened_at": "2026-08-21T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-20", "age_days": 21, "auto_resolved": 0 }, { "item_id": "RI-8853932", "period": "2026-08", "booking_id": "RS-8853932", "duty_id": "D-513932", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "M. Maes", "station": "DXB", "property_id": "P-123", "hotel": "Le Meridien Dubai", "check_in": "2026-08-14", "check_out": "2026-08-18", "nights": 4, "booking_amount": 1218.82, "card_auth": 1243.82, "card_settled": null, "folio_amount": 1269.49, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "declined_not_reissued", "state": "investigating", "resolution": null, "opened_at": "2026-08-18T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-17", "age_days": 19, "auto_resolved": 0 }, { "item_id": "RI-8853968", "period": "2026-08", "booking_id": "RS-8853968", "duty_id": "D-513968", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "T. Maes", "station": "BRU", "property_id": "P-118", "hotel": "NH Brussels Airport", "check_in": "2026-08-25", "check_out": "2026-08-27", "nights": 2, "booking_amount": 654.82, "card_auth": 679.82, "card_settled": 654.82, "folio_amount": 654.82, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "orphan", "exception_type": "orphan_charge", "state": "open", "resolution": null, "opened_at": "2026-08-27T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-26", "age_days": 31, "auto_resolved": 0 }, { "item_id": "RI-8853970", "period": "2026-08", "booking_id": "RS-8853970", "duty_id": "D-513970", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "Y. Lambert", "station": "DXB", "property_id": "P-123", "hotel": "Le Meridien Dubai", "check_in": "2026-08-16", "check_out": "2026-08-18", "nights": 2, "booking_amount": 585.32, "card_auth": 610.32, "card_settled": null, "folio_amount": 613, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "charge_after_expiry", "state": "open", "resolution": null, "opened_at": "2026-08-18T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-17", "age_days": 35, "auto_resolved": 0 }, { "item_id": "RI-8854055", "period": "2026-08", "booking_id": "RS-8854055", "duty_id": "D-514055", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "D. Declerck", "station": "HKG", "property_id": "P-121", "hotel": "Hong Kong SkyCity Marriott", "check_in": "2026-08-24", "check_out": "2026-08-26", "nights": 2, "booking_amount": 592.5, "card_auth": 617.5, "card_settled": null, "folio_amount": 601.21, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "declined_not_reissued", "state": "investigating", "resolution": null, "opened_at": "2026-08-26T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-25", "age_days": 21, "auto_resolved": 0 }, { "item_id": "RI-8854070", "period": "2026-08", "booking_id": "RS-8854070", "duty_id": "D-514070", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "H. De Smet", "station": "JNB", "property_id": "P-125", "hotel": "InterContinental OR Tambo", "check_in": "2026-08-21", "check_out": "2026-08-22", "nights": 1, "booking_amount": 237.23, "card_auth": 262.23, "card_settled": 263.26, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "investigating", "resolution": null, "opened_at": "2026-08-22T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-21", "age_days": 27, "auto_resolved": 0 }, { "item_id": "RI-8854253", "period": "2026-08", "booking_id": "RS-8854253", "duty_id": "D-514253", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "R. Lambert", "station": "CDG", "property_id": "P-126", "hotel": "Novotel Paris CDG", "check_in": "2026-08-27", "check_out": "2026-08-28", "nights": 1, "booking_amount": 326.73, "card_auth": 351.73, "card_settled": null, "folio_amount": 360.51, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "declined_not_reissued", "state": "investigating", "resolution": null, "opened_at": "2026-08-28T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-27", "age_days": 29, "auto_resolved": 0 }, { "item_id": "RI-8854284", "period": "2026-08", "booking_id": "RS-8854284", "duty_id": "D-514284", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "N. Wouters", "station": "CDG", "property_id": "P-127", "hotel": "Pullman Paris CDG", "check_in": "2026-08-11", "check_out": "2026-08-12", "nights": 1, "booking_amount": 294.07, "card_auth": 319.07, "card_settled": null, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "card_never_charged", "state": "investigating", "resolution": null, "opened_at": "2026-08-12T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-11", "age_days": 34, "auto_resolved": 0 }, { "item_id": "RI-8854361", "period": "2026-08", "booking_id": "RS-8854361", "duty_id": "D-514361", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "Y. Lambert", "station": "LGG", "property_id": "P-110", "hotel": "Van der Valk Liege", "check_in": "2026-08-28", "check_out": "2026-08-30", "nights": 2, "booking_amount": 518.78, "card_auth": 543.78, "card_settled": 518.78, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "investigating", "resolution": null, "opened_at": "2026-08-30T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-29", "age_days": 34, "auto_resolved": 0 }, { "item_id": "RI-8854413", "period": "2026-08", "booking_id": "RS-8854413", "duty_id": "D-514413", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "M. Willems", "station": "DXB", "property_id": "P-123", "hotel": "Le Meridien Dubai", "check_in": "2026-08-16", "check_out": "2026-08-18", "nights": 2, "booking_amount": 583.5, "card_auth": 608.5, "card_settled": null, "folio_amount": 613.97, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "charge_after_expiry", "state": "investigating", "resolution": null, "opened_at": "2026-08-18T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-17", "age_days": 5, "auto_resolved": 0 }, { "item_id": "RI-8854424", "period": "2026-08", "booking_id": "RS-8854424", "duty_id": "D-514424", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "R. Peeters", "station": "BRU", "property_id": "P-117", "hotel": "Thon Hotel EU", "check_in": "2026-08-23", "check_out": "2026-08-26", "nights": 3, "booking_amount": 980.46, "card_auth": 1005.46, "card_settled": null, "folio_amount": 980.46, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "charge_after_expiry", "state": "open", "resolution": null, "opened_at": "2026-08-26T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-25", "age_days": 30, "auto_resolved": 0 }, { "item_id": "RI-8854425", "period": "2026-08", "booking_id": "RS-8854425", "duty_id": "D-514425", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "G. Maes", "station": "LGG", "property_id": "P-110", "hotel": "Van der Valk Liege", "check_in": "2026-08-16", "check_out": "2026-08-17", "nights": 1, "booking_amount": 259, "card_auth": 284, "card_settled": null, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "card_never_charged", "state": "open", "resolution": null, "opened_at": "2026-08-17T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-16", "age_days": 28, "auto_resolved": 0 }, { "item_id": "RI-8854454", "period": "2026-08", "booking_id": "RS-8854454", "duty_id": "D-514454", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "P. Verhoeven", "station": "HKG", "property_id": "P-121", "hotel": "Hong Kong SkyCity Marriott", "check_in": "2026-08-19", "check_out": "2026-08-20", "nights": 1, "booking_amount": 357.83, "card_auth": 382.83, "card_settled": null, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "card_never_charged", "state": "open", "resolution": null, "opened_at": "2026-08-20T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-19", "age_days": 31, "auto_resolved": 0 }, { "item_id": "RI-8854487", "period": "2026-08", "booking_id": "RS-8854487", "duty_id": "D-514487", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "O. Maes", "station": "CDG", "property_id": "P-127", "hotel": "Pullman Paris CDG", "check_in": "2026-08-21", "check_out": "2026-08-23", "nights": 2, "booking_amount": 588.04, "card_auth": 613.04, "card_settled": 606.64, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "open", "resolution": null, "opened_at": "2026-08-23T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-22", "age_days": 3, "auto_resolved": 0 }, { "item_id": "RI-8854590", "period": "2026-08", "booking_id": "RS-8854590", "duty_id": "D-514590", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "H. Janssens", "station": "HKG", "property_id": "P-121", "hotel": "Hong Kong SkyCity Marriott", "check_in": "2026-08-06", "check_out": "2026-08-08", "nights": 2, "booking_amount": 596.72, "card_auth": 621.72, "card_settled": 596.72, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "open", "resolution": null, "opened_at": "2026-08-08T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-07", "age_days": 30, "auto_resolved": 0 }, { "item_id": "RI-8854626", "period": "2026-08", "booking_id": "RS-8854626", "duty_id": "D-514626", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "crew_name": "R. Peeters", "station": "BRU", "property_id": "P-118", "hotel": "NH Brussels Airport", "check_in": "2026-08-21", "check_out": "2026-08-24", "nights": 3, "booking_amount": 978.69, "card_auth": 1003.69, "card_settled": null, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "card_never_charged", "state": "open", "resolution": null, "opened_at": "2026-08-24T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-23", "age_days": 14, "auto_resolved": 0 }, { "item_id": "RI-8854720", "period": "2026-08", "booking_id": "RS-8854720", "duty_id": "D-514720", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "Y. Fontaine", "station": "CDG", "property_id": "P-126", "hotel": "Novotel Paris CDG", "check_in": "2026-08-15", "check_out": "2026-08-18", "nights": 3, "booking_amount": 877.56, "card_auth": 902.56, "card_settled": 895.97, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "open", "resolution": null, "opened_at": "2026-08-18T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-17", "age_days": 17, "auto_resolved": 0 }, { "item_id": "RI-8854773", "period": "2026-08", "booking_id": "RS-8854773", "duty_id": "D-514773", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "V. Roussel", "station": "MRS", "property_id": "P-131", "hotel": "Best Western Marseille Airport", "check_in": "2026-08-18", "check_out": "2026-08-21", "nights": 3, "booking_amount": 812.07, "card_auth": 837.07, "card_settled": 831.93, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "investigating", "resolution": null, "opened_at": "2026-08-21T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-20", "age_days": 34, "auto_resolved": 0 }, { "item_id": "RI-8854789", "period": "2026-08", "booking_id": "RS-8854789", "duty_id": "D-514789", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "O. Lefevre", "station": "MAD", "property_id": "P-136", "hotel": "Novotel Madrid Barajas", "check_in": "2026-08-17", "check_out": "2026-08-18", "nights": 1, "booking_amount": 276.47, "card_auth": 301.47, "card_settled": 276.47, "folio_amount": 276.47, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "orphan", "exception_type": "orphan_charge", "state": "open", "resolution": null, "opened_at": "2026-08-18T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-17", "age_days": 36, "auto_resolved": 0 }, { "item_id": "RI-8854901", "period": "2026-08", "booking_id": "RS-8854901", "duty_id": "D-514901", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "P. Berger", "station": "LYS", "property_id": "P-130", "hotel": "Comfort Hotel Lyon", "check_in": "2026-08-06", "check_out": "2026-08-09", "nights": 3, "booking_amount": 824.52, "card_auth": 849.52, "card_settled": null, "folio_amount": 857.41, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "charge_after_expiry", "state": "investigating", "resolution": null, "opened_at": "2026-08-09T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-08", "age_days": 15, "auto_resolved": 0 }, { "item_id": "RI-8854915", "period": "2026-08", "booking_id": "RS-8854915", "duty_id": "D-514915", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "O. Lefevre", "station": "CDG", "property_id": "P-126", "hotel": "Novotel Paris CDG", "check_in": "2026-08-27", "check_out": "2026-08-30", "nights": 3, "booking_amount": 978.5, "card_auth": 1003.5, "card_settled": null, "folio_amount": 978.5, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "charge_after_expiry", "state": "investigating", "resolution": null, "opened_at": "2026-08-30T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-29", "age_days": 11, "auto_resolved": 0 }, { "item_id": "RI-8854987", "period": "2026-08", "booking_id": "RS-8854987", "duty_id": "D-514987", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "V. Girard", "station": "LYS", "property_id": "P-130", "hotel": "Comfort Hotel Lyon", "check_in": "2026-08-01", "check_out": "2026-08-02", "nights": 1, "booking_amount": 251.88, "card_auth": 276.88, "card_settled": null, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "card_never_charged", "state": "open", "resolution": null, "opened_at": "2026-08-02T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-01", "age_days": 29, "auto_resolved": 0 }, { "item_id": "RI-8855126", "period": "2026-08", "booking_id": "RS-8855126", "duty_id": "D-515126", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "R. Fontaine", "station": "CDG", "property_id": "P-127", "hotel": "Pullman Paris CDG", "check_in": "2026-08-22", "check_out": "2026-08-26", "nights": 4, "booking_amount": 1186.04, "card_auth": 1211.04, "card_settled": 1215.05, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "folio_not_received", "state": "investigating", "resolution": null, "opened_at": "2026-08-26T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-25", "age_days": 26, "auto_resolved": 0 }, { "item_id": "RI-8855128", "period": "2026-08", "booking_id": "RS-8855128", "duty_id": "D-515128", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "crew_name": "E. Aubert", "station": "BRU", "property_id": "P-118", "hotel": "NH Brussels Airport", "check_in": "2026-08-14", "check_out": "2026-08-15", "nights": 1, "booking_amount": 324.9, "card_auth": 349.9, "card_settled": null, "folio_amount": null, "variance": 0, "variance_pct": 0, "variance_category": null, "match_state": "unmatched", "exception_type": "card_never_charged", "state": "open", "resolution": null, "opened_at": "2026-08-15T02:10:00Z", "resolved_at": null, "final_at": null, "final_due_at": "2026-09-14", "age_days": 20, "auto_resolved": 0 } ] }