Mapping of Fields
PenAir	Rezcom	Comments	1034360
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		1034360
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-09
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??	1034360
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 Lewis Foster
Address	Address 1 + Address 2 + Address 3 + City + Province/State + Postal Code/ZIP + Country		44 Furze Lane, Purley, CR8 3EG, GB
Passenger – Map to FlightPassengers
PassengerMaster	Repeat Factor:0 to n
LastName	LastName		Foster
FirstName	FirstName		Lewis
Title	Title		Mr
Type	Adult / Youth / Child / Infant		Adult
DateofBirth	DateOfBirth	DD/MMM/YYYY	2/24/1989
TelePhone	CustomerPhone		7787257799
EMail	CustomerEmail	Passenger Email Id	lewis_foster@hotmail.com
AirSegment
AirSegDetails	Repeat Factor:0 to n
	[ Data picked from Flights.Flight.FlightSectors.FlightSector]
AirlineId	FlightCarrierID	Airways Id from PenAIR	207
AirlineName	FlightCarrier		WOW Air
FlightNumber	FlightCode		WW811
ClassType	FlightClassID		1
ClassName	GDS specific		Data Not Available
Seats	FlightSeats		FlightSeats
Status	Pending / Confirmed		Confirmed
StatusName	NA		NA
DepartureDate	DepartureDate	YYYY-MM-DD	2018-09-09
ArrivalDate	ArrivalDate	YYYY-MM-DD	2018-09-09
DepartureCityId	DepartureAirportCode	Departure City Id from PenAIR	LGW
ArrivalCityId	ArrivalAirportCode	Arrival City Id from PenAIR	KEF
OpenSegment	GDS specific		Data Not Available
DepartureTime	DepartureTime	hh:mm:ss	11:40
ArrivalTime	ArrivalTime	hh:mm:ss	13: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	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		NA
VLocator	Supplier reference		TTTCNV
SupplierUserCode	SupplierCode	Supplier User Code from PenAIR	WW
		Data picked from Flights.Flight
OperatingAIRID	FlightBookingMultiSectorID		54721
OperatingFlightNo	FlightCode		WW811
AirlineId	FlightCarrierID	Airways Id from PenAIR	207
AirlineName	FlightCarrier		WOW Air
FlightNumber	FlightCode		WW161
ClassType	FlightClassID		1
ClassName	GDS specific		GDS specific
Seats	FlightSeats		FlightSeats
Status	Pending / Confirmed		Confirmed
StatusName	NA		NA
DepartureDate	DepartureDate	YYYY-MM-DD	2018-09-09
ArrivalDate	ArrivalDate	YYYY-MM-DD	2018-09-09
DepartureCityId	DepartureAirportCode	Departure City Id from PenAIR	KEF
ArrivalCityId	ArrivalAirportCode	Arrival City Id from PenAIR	SFO
OpenSegment	GDS specific		Data Not Available
DepartureTime	DepartureTime	hh:mm:ss	15:05
ArrivalTime	ArrivalTime	hh:mm:ss	17:15
FareBasis
DepartureTerminal	DepartureTerminal		DepartureTerminal
ArrivalTerminal	ArrivalTerminal		ArrivalTerminal
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	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		TTTCNV
SupplierUserCode	SupplierCode	Supplier User Code from PenAIR	WW
		Data picked from Flights.Flight
OperatingAIRID	FlightBookingMultiSectorID		54722
OperatingFlightNo	FlightCode		WW161
AirlineId	FlightCarrierID	Airways Id from PenAIR	207
AirlineName	FlightCarrier		WOW Air
FlightNumber	FlightCode		WW811
ClassType	FlightClassID		1
ClassName	GDS specific		Data Not Available
Seats	FlightSeats		FlightSeats
Status	Pending / Confirmed		Confirmed
StatusName	NA		NA
DepartureDate	DepartureDate	YYYY-MM-DD	2018-09-18
ArrivalDate	ArrivalDate	YYYY-MM-DD	2018-09-19
DepartureCityId	DepartureAirportCode	Departure City Id from PenAIR	SFO
ArrivalCityId	ArrivalAirportCode	Arrival City Id from PenAIR	KEF
OpenSegment	GDS specific		Data Not Available
DepartureTime	DepartureTime	hh:mm:ss	19:00
ArrivalTime	ArrivalTime	hh:mm:ss	10:35
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		Data Not Available
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		TTTCNV
SupplierUserCode	SupplierCode	Supplier User Code from PenAIR	WW
		Data picked from Flights.Flight
OperatingAIRID	FlightBookingMultiSectorID		54723
OperatingFlightNo	FlightCode		WW162
AirlineId	FlightCarrierID	Airways Id from PenAIR	207
AirlineName	FlightCarrier		WOW Air
FlightNumber	FlightCode		WW814
ClassType	FlightClassID		1
ClassName	GDS specific		Data Not Available
Seats	FlightSeats		Data Not Available
Status	Pending / Confirmed		Confirmed
StatusName	NA		NA
DepartureDate	DepartureDate	YYYY-MM-DD	2018-09-19
ArrivalDate	ArrivalDate	YYYY-MM-DD	2018-09-19
DepartureCityId	DepartureAirportCode	Departure City Id from PenAIR	KEF
ArrivalCityId	ArrivalAirportCode	Arrival City Id from PenAIR	LGW
OpenSegment	GDS specific		Data Not Available
DepartureTime	DepartureTime	hh:mm:ss	15:50
ArrivalTime	ArrivalTime	hh:mm:ss	20:25
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	0
MealsInformation	GDS specific		Data Not Available
SeatInformation	GDS specific		Data Not Available
Stops	Stops		Stops
ItineraryNotes	GDS specific		Data Not Available
PCC	NA		NA
VLocator	Supplier reference		TTTCNV
SupplierUserCode	SupplierCode	Supplier User Code from PenAIR	WW
		Data picked from Flights.Flight
OperatingAIRID	FlightBookingMultiSectorID		54724
OperatingFlightNo	FlightCode		WW814
Airticket
AirTicketDetails	Repeat Factor:0 to n
	[ Data picked from Flights.Flight.FlightSectors.FlightPassengers]
PassengerName	FirstName + LastName		Lewis Foster
TicketNumber	Airline locator		Airline locator
AirlineId	FlightCarrierID	In a multi sector flight, which airline ID will be used	207
DepartureCityId	DepartureAirportCode		LGW
ArrivalCityId	ArrivalAirportCode		SAO
SupplierUserCode	SupplierCode	Suppler UserCode from PenAIR	WW
VLocator	Supplier reference	Optional	Supplier reference
JourneyType	GDS specific		Data Not Available
TicketDate	BookingDate	YYYY-MM-DD	9/3/2018
		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		419
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		Data Not Available
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	Values:Confirmed,Wait listed	N/A
		Values don’t match with what PenAir has shared	N/A
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		Data Not Available
TxAuthNo			Data Not Available
Amount	Amount		425.95
CardType	Card Type		Data Not Available
CardCharge	no cc fees as of Jan 18		Data Not Available
ThreeDSecureStatus	should link with upload, where 3DS is applicable		Data Not Available