=== CSV HEADERS + NAME COLLISION DIAGNOSTIC ===

Document #2: BMP_Sales_Report_-_2025-12-31

=== HEADERS ({91} colonnes) ===
  [0] "PNR creation date"
  [1] "Record Locator"
  [2] "OfficeId Bk"
  [3] "Ticketing terminal ID"
  [4] "SignInBooking"
  [5] "SignInTicketing"
  [6] "IATA agency"
  [7] "Subagent"
  [8] "Booking terminal ID"
  [9] "GDS"
  [10] "Passenger"
  [11] "LastName"
  [12] "FirstName"
  [13] "Title"
  [14] "PaxType"
  [15] "Contacts"
  [16] "SSR DOCS"
  [17] "TravelDates"
  [18] "DepDate"
  [19] "ArrDate"
  [20] "NumberOfSegments"
  [21] "Fare basis(es)"
  [22] "Booking class(es)"
  [23] "Service class(es)"
  [24] "Route"
  [25] "Flight numbers"
  [26] "Mileage"
  [27] "Baggage"
  [28] "CO2"
  [29] "PnrStatus"
  [30] "NumberOfStops"
  [31] "NotValidBefore"
  [32] "NotValidAfter"
  [33] "FLWN"
  [34] "Date"
  [35] "No"
  [36] "Carrier"
  [37] "Airline code"
  [38] "Number"
  [39] "Type"
  [40] "Action"
  [41] "Issue type"
  [42] "IsoCountryCode"
  [43] "ItineraryOriginCode"
  [44] "ItineraryDestinationCode"
  [45] "Remark"
  [46] "Fare"
  [47] "Fare currency"
  [48] "Net fare"
  [49] "Fare equiv"
  [50] "Fare equiv. currency"
  [51] "Commission"
  [52] "Commission equiv"
  [53] "Taxes"
  [54] "Taxes details"
  [55] "Taxes currency"
  [56] "SFDiscount"
  [57] "HF"
  [58] "Service fee"
  [59] "SfTotal"
  [60] "MarkUpTotal"
  [61] "MarkUpVat"
  [62] "MarkUpDiscount"
  [63] "Service fee VAT"
  [64] "Total"
  [65] "Total currency"
  [66] "National total"
  [67] "National currency"
  [68] "Misc. fees"
  [69] "Grand total"
  [70] "Currency rate"
  [71] "Tour code"
  [72] "FOP"
  [73] "Actual FOP"
  [74] "Credit currency"
  [75] "Credit currency rate"
  [76] "Document credit total"
  [77] "SF subagent"
  [78] "SF credit total"
  [79] "Refund Fee"
  [80] "Interline"
  [81] "Order"
  [82] "Order creation date"
  [83] "Order modification date"
  [84] "Customer"
  [85] "Proforma number"
  [86] "Proforma billing date"
  [87] "Invoice number"
  [88] "Invoice billing date"
  [89] "Credit note number"
  [90] "Credit note billing date"

=== COLONNES CLES ===
  'Date' present: OUI
  'Number' present: OUI
  'No' present: OUI

=== PARSING ===
  Lignes parsees OK: 6
  Lignes parse errors (col mismatch): 0

=== NAME COLLISIONS ===
  Noms uniques: 6
  Total records: 6
  Collisions (meme name, ecrasement): 0 noms avec doublons

=== PREMIER RECORD (5 premiers champs) ===
  PNR creation date = "2025-12-30"
  Record Locator = "XRVBAI"
  OfficeId Bk = "DKR272470"
  Ticketing terminal ID = "ABJ26222P"
  SignInBooking = "0000BB"
  SignInTicketing = "0000BB"
  IATA agency = "CETERIS TOURS CI"
  Subagent = "A&B TRAVEL SOLUTION"
  Booking terminal ID = ""
  GDS = "amadeus"