Mapping of Fields    
  PenAir Rezcom Comments 1034464  
  Login    
  Username o2c   o2c  
  Password 216A3E712E6D Encrypted value for o2c 216A3E712E6D  
  Version 1 Static value 1  
  Provider Rezcom I have assumed Rezcom as static value Rezcom  
  PNRLocator BookingReference   1034464  
  FolderMaster    
  CustomerUserCode 2002   2002  
  BookedBy 131 I have assumed Rezcom as static value 131  
  DestinationCityId BrandCode 3 letter standard city airport id LGW  
  MarketingCode IGNORE FIELD Will we get this data later or we do not need to send it at all?? IGNORE FIELD  
  TravelDate FirstDepartureDate YYYY-MM-DD 2018-09-16  
  BranchId IGNORE FIELD Will we get this data later or we do not need to send it at all?? IGNORE FIELD  
  BusinessAreaId ADT Will we get this data later or we do not need to send it at all?? ADT  
  PassengerProfileId IGNORE FIELD Will we get this data later or we do not need to send it at all?? IGNORE FIELD  
  InetRef Online Booking Reference Will we get this data later or we do not need to send it at all?? 1034464  
  YourRef IGNORE FIELD Will we get this data later or we do not need to send it at all?? IGNORE FIELD  
  Notes IGNORE FIELD Will we get this data later or we do not need to send it at all?? IGNORE FIELD  
  DeliveryAddress LeadCustomer   Mr Peter Radmall  
  Address Address 1 + Address 2 + Address 3 + City + Province/State + Postal Code/ZIP + Country   Firbank, Ashdown Road, Forest Row, RH18 5BW, GB  
   
  Passenger – Map to FlightPassengers    
  PassengerMaster Repeat Factor:0 to n    
  LastName LastName   Radmall  
  FirstName FirstName   Peter  
  Title Title   Mr  
  Type Adult / Youth / Child / Infant   Adult  
  DateofBirth DateOfBirth DD/MMM/YYYY 30/08/1955  
  TelePhone CustomerPhone   01342 822278  
  EMail CustomerEmail Passenger Email Id peterradmall@outlook.com  
  AirSegment    
  AirSegDetails Repeat Factor:0 to n     
  [ Data picked from Flights.Flight.FlightSectors.FlightSector]    
  AirlineId FlightCarrierID Airways Id from PenAIR 25  
  AirlineName FlightCarrier   British Airways  
  FlightNumber FlightCode   BA2774  
  ClassType FlightClassID   1  
  ClassName GDS specific   GDS specific  
  Seats FlightSeats   FlightSeats  
  Status Pending / Confirmed - will always be confirmed   Confirmed - will always be confirmed  
  StatusName NA   Data Not Available  
  DepartureDate DepartureDate YYYY-MM-DD 2018-09-16  
  ArrivalDate ArrivalDate YYYY-MM-DD 2018-09-16  
  DepartureCityId DepartureAirportCode Departure City Id from PenAIR LGW  
  ArrivalCityId ArrivalAirportCode Arrival City Id from PenAIR JER  
  OpenSegment GDS specific   Data Not Available  
  DepartureTime DepartureTime hh:mm:ss 16:15  
  ArrivalTime ArrivalTime hh:mm:ss 17:15  
  FareBasis     Data Not Available  
  DepartureTerminal DepartureTerminal   Data Not Available  
  ArrivalTerminal ArrivalTerminal   Data Not Available  
  BaggageAllowance GDS specific, unsure if baggage would pull through the feed    Data Not Available  
  CheckIn GDS specific   Data Not Available  
  BookedVia GDS specific   Jetset  
  FlightTime TravelTime hh:mm:ss 0  
  MealsInformation GDS specific   Data Not Available  
  SeatInformation GDS specific   Data Not Available  
  Stops Stops   Data Not Available  
  ItineraryNotes GDS specific   Data Not Available  
  PCC NA   Data Not Available  
  VLocator Supplier reference   3825447  
  SupplierUserCode SupplierCode Supplier User Code from PenAIR JST  
  Data picked from Flights.Flight  
  OperatingAIRID FlightBookingMultiSectorID   54911  
  OperatingFlightNo FlightCode   BA2774  
       
  AirSegDetails Repeat Factor:0 to n     
  [ Data picked from Flights.Flight.FlightSectors.FlightSector]    
  AirlineId FlightCarrierID Airways Id from PenAIR 25  
  AirlineName FlightCarrier   British Airways  
  FlightNumber FlightCode   BA2771  
  ClassType FlightClassID   1  
  ClassName GDS specific   Data Not Available  
  Seats FlightSeats   FlightSeats  
  Status Pending / Confirmed - will always be confirmed   Confirmed - will always be confirmed  
  StatusName NA   Data Not Available  
  DepartureDate DepartureDate YYYY-MM-DD 2018-09-19  
  ArrivalDate ArrivalDate YYYY-MM-DD 2018-09-19  
  DepartureCityId DepartureAirportCode Departure City Id from PenAIR JER  
  ArrivalCityId ArrivalAirportCode Arrival City Id from PenAIR JGW  
  OpenSegment GDS specific   Data Not Available  
  DepartureTime DepartureTime hh:mm:ss 9:50  
  ArrivalTime ArrivalTime hh:mm:ss 10:55  
  FareBasis        
  DepartureTerminal DepartureTerminal   Data Not Available  
  ArrivalTerminal ArrivalTerminal   Data Not Available  
  BaggageAllowance GDS specific, unsure if baggage would pull through the feed    Data Not Available  
  CheckIn GDS specific   Data Not Available  
  BookedVia GDS specific   Data Not Available  
  FlightTime TravelTime hh:mm:ss Data Not Available  
  MealsInformation GDS specific   Data Not Available  
  SeatInformation GDS specific   Data Not Available  
  Stops Stops   Data Not Available  
  ItineraryNotes GDS specific   Data Not Available  
  PCC NA   Data Not Available  
  VLocator Supplier reference   3825447  
  SupplierUserCode SupplierCode Supplier User Code from PenAIR JST  
  Data picked from Flights.Flight  
  OperatingAIRID FlightBookingMultiSectorID   54912  
  OperatingFlightNo FlightCode   BA2771  
  Airticket    
  AirTicketDetails Repeat Factor:0 to n     
  [ Data picked from Flights.Flight.FlightSectors.FlightPassengers]    
  PassengerName FirstName + LastName   Peter Radmall  
  TicketNumber Airline locator   Airline locator  
  AirlineId FlightCarrierID In a multi sector flight, which airline ID will be used 25  
  DepartureCityId DepartureAirportCode   LGW  
  ArrivalCityId ArrivalAirportCode   JER  
  SupplierUserCode SupplierCode Suppler UserCode from PenAIR JST  
  VLocator Supplier reference Optional 3825447  
  JourneyType GDS specific   Data Not Available  
  TicketDate BookingDate YYYY-MM-DD 2018-09-07  
  Data picked from top field  
  Issuer GDS specific   Data Not Available  
  IATANumber GDS specific   Data Not Available  
  Currency GBP Currency Code Values:GBP GBP  
  Fare Price   590.00  
  Exchange GDS specific   Data Not Available  
  FareBasis GDS specific   Data Not Available  
  FareType GDS specific   Data Not Available  
  FareDescription GDS specific   Data Not Available  
  FareCommPer GDS specific   Data Not Available  
  FareCommAmt GDS specific   Data Not Available  
  FareSellAmt GDS specific   Data Not Available  
  Tax GDS specific   Data Not Available  
  TaxType GDS specific   Data Not Available  
  TaxDescription GDS specific   Data Not Available  
  TaxSellAmt GDS specific   Data Not Available  
  TaxCommissionPercentage GDS specific   Data Not Available  
  TaxCommissionAmount GDS specific   Data Not Available  
  ValidatingAirlineId GDS specific Airline Code Values:UX Data Not Available  
  CommissionOn GDS specific Values:Purchase,Sales Data Not Available  
  PayMode GDS specific Values:Company Card,Customer Card,Customer Pay Locally,Credit Data Not Available  
  TicketingDeadline GDS specific YYYY-MM-DD Data Not Available  
  ValidBeforeDate GDS specific YYYY-MM-DD Data Not Available  
  ValidAfterDate GDS specific YYYY-MM-DD Data Not Available  
  FareName GDS specific   Data Not Available  
  FareRemarks GDS specific   Data Not Available  
  SupplierNotesToBePrinted GDS specific   Data Not Available  
  TotalSellAmt GDS specific   596.95  
  TicketType GDS specific   Data Not Available  
  Hotel    
  HotelDetails  [ Data picked from Properties.Property]    
  SupplierUserCode SupplierCode Supplier UserCode from PenAIR N/A  
  HotelName HotelName   N/A  
  RoomType RoomType   N/A  
  Rooms Rooms   N/A  
  DateIn ArrivalDate YYYY-MM-DD N/A  
  DateOut ReturnDate YYYY-MM-DD N/A  
  Status Pending / Confirmed - will always be confirmed Values:Confirmed,Wait listed N/A  
  Values don’t match with what PenAir has shared  
  VoucherNumber PropertyBookingReference   N/A  
  HotelId PropertyReferenceID Hotel ID from PenAIR N/A  
  CityCode CityCode City Code from PenAIR N/A  
  CurrencyCode CurrencyCode   N/A  
  DocCurrencyAmt     N/A  
  NoOfPax No. Of Pax Adults + Children?? N/A  
  PaymentMethod PaymentMethod Values:Company Card,Customer Card,Customer Pay Locally,Credit N/A  
  RoomDescription Room Description   N/A  
  ConfirmationNo PropertyRoomBookingID   N/A  
  GeneralInfo     N/A  
  Address Property/Hotel Address   N/A  
  Phone Property/Hotel Phone   N/A  
  Fax Property/Hotel Fax ( if available ? )   N/A  
  RoomRateDescription     N/A  
  CancellationPolicy NA   N/A  
  ExchangeRate GBP as this stage   N/A  
  GuestName FirstName + LastName  Data picked from Properties.Property. Rooms.Room. GuestDetails N/A  
  CommissionPercentage not preset   N/A  
  CommissionAmount not preset   N/A  
  CheckInTime CheckInTime hh:mm:ss N/A  
  Checkouttime Checkouttime hh:mm:ss N/A  
  Email CustomerEmail Data picked from LeadCustomer.CustomerEmail N/A  
  MealPlan MealBasisID Optional N/A  
  Car N/A  
  CarDetails  [ Data to be picked from CarHireBookings] N/A  
  SupplierUserCode Supplier User Code from PenAIR Supplier User Code from PenAIR N/A  
  Provider Provider Name   N/A  
  Type Vehicle Type   N/A  
  PickUp Pickup Location Name   N/A  
  DropOff Drop Off Location Name   N/A  
  DateIn Pickup Date YYYY-MM-DD N/A  
  DateOut Drop Off Date YYYY-MM-DD N/A  
  TimeIn Pickup Time hh:mm:ss N/A  
  TimeOut Drop Off Time hh:mm:ss N/A  
  RatePerKM     N/A  
  KM     N/A  
  Status   Values:OK,Pending N/A  
  VoucherNumber Confirmation Number   N/A  
  DocCurrencyAmt     N/A  
  CommissionPercentage     N/A  
  CommissionAmount     N/A  
  CurrencyCode CurrencyCode   N/A  
  ExchangeRate     N/A  
  PaymentMethod PaymentMethod Values:Company Card,Customer Card,Customer Pay Locally,Credit N/A  
  CommissionOn   Values:Purchase N/A  
  Payable     N/A  
  Tour ( Does Not Apply to Rezcomm in current scheme of things )     
  TourDetails      
  SupplierUserCode N/A Supplier Usercode from PenAIR N/A  
  Type N/A   N/A  
  PickUp N/A   N/A  
  DropOff N/A   N/A  
  DepartureDate N/A YYYY-MM-DD N/A  
  ArrivalDate N/A YYYY-MM-DD N/A  
  Status N/A Values:OK,Pending N/A  
  Payable N/A   N/A  
  VatCode N/A   N/A  
  Voucher N/A   N/A  
  PaymentMethod N/A Values:Company Card,Customer Card,Customer Pay Locally,Credit N/A  
  CurrencyCode N/A   N/A  
  DocCurrencyAmt N/A   N/A  
  CommissionOn N/A Value:Purchase N/A  
  Provider N/A   N/A  
  DepartureTime N/A hh:mm:ss N/A  
  ArrivalTime N/A hh:mm:ss N/A  
  CurrencyExchangeRate N/A   N/A  
  CommissionPercentage N/A   N/A  
  CommissionAmount N/A   N/A  
  Notes N/A   N/A  
  Rail ( Does Not Apply to Rezcomm in current scheme of things )     
  RailDetails      
  SupplierUserCode N/A Supplier Usercode from PenAIR N/A  
  Type N/A   N/A  
  PickUp N/A   N/A  
  DepartureDate N/A YYYY-MM-DD N/A  
  ArrivalDate N/A YYYY-MM-DD N/A  
  Status N/A Values:OK,Pending N/A  
  Payable N/A   N/A  
  VatCode N/A   N/A  
  Voucher N/A   N/A  
  PaymentMethod N/A Values:Company Card,Customer Card,Customer Pay Locally,Credit N/A  
  CurrencyCode N/A   N/A  
  DocCurrencyAmt N/A   N/A  
  CommissionOn N/A Value:Purchase N/A  
  Provider N/A   N/A  
  DepartureTime N/A hh:mm:ss N/A  
  ArrivalTime N/A hh:mm:ss N/A  
  CurrencyExchangeRate N/A   N/A  
  CommissionPercentage N/A   N/A  
  CommissionAmount N/A   N/A  
  Notes N/A   N/A  
  TicketNumber N/A   N/A  
  TicketDate N/A   N/A  
  Remarks N/A   N/A  
  Cruise ( Does Not Apply to Rezcomm in current scheme of things )     
  CruiseDetails      
  SupplierUserCode N/A   N/A  
  Type N/A   N/A  
  DepartureCity N/A   N/A  
  DepartureDate N/A YYYY-MM-DD N/A  
  DepartureTime N/A hh:mm:ss N/A  
  ArrivalCity N/A   N/A  
  ArrivalDate N/A YYYY-MM-DD N/A  
  ArrivalTime N/A hh:mm:ss N/A  
  Status N/A Values:OK,Pending N/A  
  Amount N/A   N/A  
  VatCode N/A   N/A  
  VatPercentage N/A   N/A  
  Voucher N/A   N/A  
  PayMode N/A Values:Company Card,Customer Card,Customer Pay Locally,Credit N/A  
  Remarks N/A   N/A  
  CurrencyCode N/A   N/A  
  Notes N/A   N/A  
  CommissionPercentage N/A   N/A  
  CommissionAmount N/A   N/A  
  CommOn N/A Value:Purchase N/A  
  DocCurrencyAmt N/A   N/A  
  Provider N/A Provider Name ;Default Supplier Name N/A  
  CabinType N/A   N/A  
  Catagory N/A   N/A  
  StateroomNo N/A   N/A  
  EmbarkationTime N/A   N/A  
  DisembarkationTime N/A   N/A  
  ExchangeRate N/A   N/A  
  Insurance ( Does Not Apply to Rezcomm in current scheme of things )     
  InsuranceDetails      
  SupplierUserCode N/A   N/A  
  Passenger N/A Passenger Name N/A  
  Region N/A   N/A  
  Type N/A   N/A  
  Status N/A Values:OK,Pending N/A  
  Gross N/A   N/A  
  DateFrom N/A YYYY-MM-DD N/A  
  DateTo N/A YYYY-MM-DD N/A  
  PolicyNumber N/A   N/A  
  PaymentMethod N/A Values:Company Card,Customer Card,Customer Pay Locally,Credit N/A  
  CurrencyCode N/A Currency code from PenAIR N/A  
  ExchangeRate N/A   N/A  
  CommissionOn N/A Values:Purchase N/A  
  DocCurrencyAmt N/A   N/A  
  CommissionPercentage N/A   N/A  
  CommissionAmount N/A   N/A  
  Notes N/A   N/A  
  Others  ( Does Not Apply to Rezcomm in current scheme of things )     
  OthersDetails      
  ProductUserCode N/A Product Usercode from PenAIR N/A  
  Quantity N/A   N/A  
  Rate N/A   N/A  
  Discount N/A   N/A  
  Amount N/A   N/A  
  SellAmount N/A   N/A  
  VATCode N/A   N/A  
  SupplierUserCode N/A Supplier Usercode from PenAIR N/A  
  VATPercentage N/A   N/A  
  PNRLocator N/A   N/A  
  PrintonInvoice N/A   N/A  
  OthersType N/A Values:Default N/A  
  CurrencyId N/A   N/A  
  ForeignCurrencyAMount N/A   N/A  
  DefaultDepositPer N/A   N/A  
  DefaultDepositAmt N/A   N/A  
  Status N/A Values:OK,Pending N/A  
  PaymentMode N/A Values:Company Card,Customer Card,Customer Pay Locally,Credit N/A  
  CommissionOn N/A   N/A  
  ItineraryNotes N/A   N/A  
  Transfers    
  TransferDetails Repeat Factor:0 to n     
  [ Data picked from Transfers.Transfer]    
  SupplierUserCode Supplier Usercode from PenAIR Supplier Usercode from PenAIR N/A  
  Provider Source   N/A  
  FromCity CityCode City Code from PenAIR N/A  
  ToCity CityCode City Code from PenAIR N/A  
  DepartureDate DepartureDate YYYY-MM-DD N/A  
  DepartureTime DepartureTime hh:mm:ss N/A  
  VehicleType Vehicle Type   N/A  
  FlightDetails DepartureFlightCode   N/A  
  Status Status Values:OK,Pending N/A  
  Payable     N/A  
  PaymentMethod PaymentMethod Values:Company Card,Customer Card,Customer Pay Locally,Credit N/A  
  SupplierRef SourceReference   N/A  
  Comments     N/A  
  CurrencyCode CurrencyCode   N/A  
  ExchangeRate GBP only at this stage   N/A  
  CommissionOn not preset Value:Purchase N/A  
  DocCurrencyAmt     N/A  
  CommissionPercentage not preset   N/A  
  CommissionAmount not preset   N/A  
  Notes     N/A  
  FolderAlert alert for diary completed post upload   N/A  
  Payment    
  PaymentDetails  [ Data picked from ??]    
  PaymentDetails        
  VendorTxCode     Data Not Available  
  TransactionId WorldpayTransId   110_80041076  
  TxAuthNo     Data Not Available  
  Amount Amount   596.95  
  CardType Card Type   Card Type  
  CardCharge no cc fees as of Jan 18   Data Not Available  
  ThreeDSecureStatus should link with upload, where 3DS is applicable   Data Not Available