| Mapping of Fields |
|
|
| PenAir |
Rezcom |
Comments |
1033061 |
|
| 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 |
|
1033061 |
|
| 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?? |
1033061 |
|
| 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 |
|
Mrs Sandra Harmer |
|
| Address |
Address 1 + Address 2 + Address 3 + City +
Province/State + Postal Code/ZIP + Country |
|
27 Shenfield Place, Shenfield, Brentwood, Essex,
CM15 9AH, GB |
|
|
| Passenger – Map to FlightPassengers |
|
|
| PassengerMaster |
Repeat Factor:0 to n |
|
|
| LastName |
LastName |
|
Harmer |
|
| FirstName |
FirstName |
|
Sandra |
|
| Title |
Title |
|
Mrs |
|
| Type |
Adult / Youth / Child / Infant |
|
Adult |
|
| DateofBirth |
DateOfBirth |
DD/MMM/YYYY |
3/22/1944 |
|
| TelePhone |
CustomerPhone |
|
1277227225 |
|
| EMail |
CustomerEmail |
Passenger Email Id |
sfharmer@hotmail.com |
|
| |
|
|
|
|
| LastName |
LastName |
|
Harmer |
|
| FirstName |
FirstName |
|
Anthony |
|
| Title |
Title |
|
Mr |
|
| Type |
Adult / Youth / Child / Infant |
|
Adult |
|
| DateofBirth |
DateOfBirth |
DD/MMM/YYYY |
12/6/1973 |
|
| TelePhone |
CustomerPhone |
|
Data Not Available |
|
| EMail |
CustomerEmail |
Passenger Email Id |
Data Not Available |
|
| |
|
|
|
|
| LastName |
LastName |
|
Harmer |
|
| FirstName |
FirstName |
|
Raphael |
|
| Title |
Title |
|
Mr |
|
| Type |
Adult / Youth / Child / Infant |
|
Child |
|
| DateofBirth |
DateOfBirth |
DD/MMM/YYYY |
10/1/2008 |
|
| TelePhone |
CustomerPhone |
|
Data Not Available |
|
| EMail |
CustomerEmail |
Passenger Email Id |
Data Not Available |
|
| |
|
|
|
|
| LastName |
LastName |
|
Harmer |
|
| FirstName |
FirstName |
|
Joyce |
|
| Title |
Title |
|
Mrs |
|
| Type |
Adult / Youth / Child / Infant |
|
Adult |
|
| DateofBirth |
DateOfBirth |
DD/MMM/YYYY |
9/7/1973 |
|
| TelePhone |
CustomerPhone |
|
Data Not Available |
|
| EMail |
CustomerEmail |
Passenger Email Id |
Data Not Available |
|
| |
|
|
|
|
| LastName |
LastName |
|
Harmer |
|
| FirstName |
FirstName |
|
Benjamin |
|
| Title |
Title |
|
Mr |
|
| Type |
Adult / Youth / Child / Infant |
|
Child |
|
| DateofBirth |
DateOfBirth |
DD/MMM/YYYY |
6/11/2007 |
|
| TelePhone |
CustomerPhone |
|
Data Not Available |
|
| EMail |
CustomerEmail |
Passenger Email Id |
Data Not Available |
|
| AirSegment |
|
|
| AirSegDetails |
Repeat Factor:0 to n |
|
|
| [ Data picked from
Flights.Flight.FlightSectors.FlightSector] |
|
|
| AirlineId |
FlightCarrierID |
Airways Id from PenAIR |
1 |
|
| AirlineName |
FlightCarrier |
|
EasyJet |
|
| FlightNumber |
FlightCode |
|
EZY7363 |
|
| 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-08-02 |
|
| ArrivalDate |
ArrivalDate |
YYYY-MM-DD |
2018-08-02 |
|
| DepartureCityId |
DepartureAirportCode |
Departure City Id from PenAIR |
SEN |
|
| ArrivalCityId |
ArrivalAirportCode |
Arrival City Id from PenAIR |
FAO |
|
| OpenSegment |
GDS specific |
|
Data Not Available |
|
| DepartureTime |
DepartureTime |
hh:mm:ss |
16:40 |
|
| ArrivalTime |
ArrivalTime |
hh:mm:ss |
19: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 |
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 |
|
Supplier reference |
|
| SupplierUserCode |
SupplierCode |
Supplier User Code from PenAIR |
EVFHBTS |
|
| Data
picked from Flights.Flight |
|
| OperatingAIRID |
FlightBookingMultiSectorID |
|
EZJ |
|
| OperatingFlightNo |
FlightCode |
|
EZY7364 |
|
| |
|
|
|
|
| AirlineId |
FlightCarrierID |
Airways Id from PenAIR |
1 |
|
| AirlineName |
FlightCarrier |
|
EasyJet |
|
| FlightNumber |
FlightCode |
|
EZY7364 |
|
| ClassType |
FlightClassID |
|
1 |
|
| ClassName |
GDS specific |
|
Data Not Available |
|
| Seats |
FlightSeats |
|
Data Not Available |
|
| Status |
Pending / Confirmed - will
always be confirmed |
|
Confirmed |
|
| StatusName |
NA |
|
NA |
|
| DepartureDate |
DepartureDate |
YYYY-MM-DD |
2018-08-07 |
|
| ArrivalDate |
ArrivalDate |
YYYY-MM-DD |
2018-08-07 |
|
| DepartureCityId |
DepartureAirportCode |
Departure City Id from PenAIR |
FAO |
|
| ArrivalCityId |
ArrivalAirportCode |
Arrival City Id from PenAIR |
SEN |
|
| OpenSegment |
GDS specific |
|
Data Not Available |
|
| DepartureTime |
DepartureTime |
hh:mm:ss |
20:05 |
|
| ArrivalTime |
ArrivalTime |
hh:mm:ss |
22:50 |
|
| 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 |
|
Data Not Available |
|
| SupplierUserCode |
SupplierCode |
Supplier User Code from PenAIR |
EVFHBTS |
|
| Data
picked from Flights.Flight |
|
| OperatingAIRID |
FlightBookingMultiSectorID |
|
EZJ |
|
| OperatingFlightNo |
FlightCode |
|
EZY7364 |
|
| Airticket |
|
|
| AirTicketDetails |
Repeat Factor:0 to n |
|
|
| [ Data picked from
Flights.Flight.FlightSectors.FlightPassengers] |
|
|
| PassengerName |
FirstName + LastName |
|
Sandra Harmer |
|
| TicketNumber |
Airline locator |
|
Data Not Available |
|
| AirlineId |
FlightCarrierID |
In a multi sector flight, which
airline ID will be used |
1 |
|
| DepartureCityId |
DepartureAirportCode |
|
SEN |
|
| ArrivalCityId |
ArrivalAirportCode |
|
FAO |
|
| SupplierUserCode |
SupplierCode |
Suppler UserCode from PenAIR |
EZJ |
|
| VLocator |
Supplier reference |
Optional |
EVFHBTS |
|
| JourneyType |
GDS specific |
|
Data Not Available |
|
| TicketDate |
BookingDate |
YYYY-MM-DD |
2018-07-10 |
|
| 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 |
|
1208.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 |
|
Data Not Available |
|
| TicketType |
GDS specific |
|
Data Not Available |
|
| |
|
|
|
|
| PassengerName |
FirstName + LastName |
|
Anthony Harmer |
|
| TicketNumber |
Airline locator |
|
Data Not Available |
|
| AirlineId |
FlightCarrierID |
In a multi sector flight, which
airline ID will be used |
1 |
|
| DepartureCityId |
DepartureAirportCode |
|
SEN |
|
| ArrivalCityId |
ArrivalAirportCode |
|
FAO |
|
| SupplierUserCode |
SupplierCode |
Suppler UserCode from PenAIR |
EZJ |
|
| VLocator |
Supplier reference |
Optional |
EVFHBTS |
|
| JourneyType |
GDS specific |
|
Data Not Available |
|
| TicketDate |
BookingDate |
YYYY-MM-DD |
2018-07-10 |
|
| 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 |
|
1208.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 |
|
Data Not Available |
|
| TicketType |
GDS specific |
|
Data Not Available |
|
| |
|
|
|
|
| PassengerName |
FirstName + LastName |
|
Raphael Harmer |
|
| TicketNumber |
Airline locator |
|
Data Not Available |
|
| AirlineId |
FlightCarrierID |
In a multi sector flight, which
airline ID will be used |
1 |
|
| DepartureCityId |
DepartureAirportCode |
|
SEN |
|
| ArrivalCityId |
ArrivalAirportCode |
|
FAO |
|
| SupplierUserCode |
SupplierCode |
Suppler UserCode from PenAIR |
EZJ |
|
| VLocator |
Supplier reference |
Optional |
EVFHBTS |
|
| JourneyType |
GDS specific |
|
Data Not Available |
|
| TicketDate |
BookingDate |
YYYY-MM-DD |
2018-07-10 |
|
| 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 |
|
1208.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 |
|
Data Not Available |
|
| TicketType |
GDS specific |
|
Data Not Available |
|
| |
|
|
|
|
| PassengerName |
FirstName + LastName |
|
oyce Harmer |
|
| TicketNumber |
Airline locator |
|
Data Not Available |
|
| AirlineId |
FlightCarrierID |
In a multi sector flight, which
airline ID will be used |
1 |
|
| DepartureCityId |
DepartureAirportCode |
|
SEN |
|
| ArrivalCityId |
ArrivalAirportCode |
|
FAO |
|
| SupplierUserCode |
SupplierCode |
Suppler UserCode from PenAIR |
EZJ |
|
| VLocator |
Supplier reference |
Optional |
EVFHBTS |
|
| JourneyType |
GDS specific |
|
Data Not Available |
|
| TicketDate |
BookingDate |
YYYY-MM-DD |
2018-07-10 |
|
| 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 |
|
1208.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 |
|
Data Not Available |
|
| TicketType |
GDS specific |
|
Data Not Available |
|
| |
|
|
|
|
| PassengerName |
FirstName + LastName |
|
Benjamin Harmer |
|
| TicketNumber |
Airline locator |
|
Data Not Available |
|
| AirlineId |
FlightCarrierID |
In a multi sector flight, which
airline ID will be used |
1 |
|
| DepartureCityId |
DepartureAirportCode |
|
SEN |
|
| ArrivalCityId |
ArrivalAirportCode |
|
FAO |
|
| SupplierUserCode |
SupplierCode |
Suppler UserCode from PenAIR |
EZJ |
|
| VLocator |
Supplier reference |
Optional |
EVFHBTS |
|
| JourneyType |
GDS specific |
|
Data Not Available |
|
| TicketDate |
BookingDate |
YYYY-MM-DD |
2018-07-10 |
|
| 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 |
|
1208.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 |
|
Data Not Available |
|
| TicketType |
GDS specific |
|
Data Not Available |
|
| |
|
|
|
|
| PassengerName |
FirstName + LastName |
|
Sandra Harmer |
|
| TicketNumber |
Airline locator |
|
Data Not Available |
|
| AirlineId |
FlightCarrierID |
In a multi sector flight, which
airline ID will be used |
1 |
|
| DepartureCityId |
DepartureAirportCode |
|
FAO |
|
| ArrivalCityId |
ArrivalAirportCode |
|
SEN |
|
| SupplierUserCode |
SupplierCode |
Suppler UserCode from PenAIR |
EZJ |
|
| VLocator |
Supplier reference |
Optional |
EVFHBTS |
|
| JourneyType |
GDS specific |
|
Data Not Available |
|
| TicketDate |
BookingDate |
YYYY-MM-DD |
2018-07-10 |
|
| 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 |
|
1208.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 |
|
Data Not Available |
|
| TicketType |
GDS specific |
|
Data Not Available |
|
| |
|
|
|
|
| PassengerName |
FirstName + LastName |
|
Anthony Harmer |
|
| TicketNumber |
Airline locator |
|
Data Not Available |
|
| AirlineId |
FlightCarrierID |
In a multi sector flight, which
airline ID will be used |
1 |
|
| DepartureCityId |
DepartureAirportCode |
|
FAO |
|
| ArrivalCityId |
ArrivalAirportCode |
|
SEN |
|
| SupplierUserCode |
SupplierCode |
Suppler UserCode from PenAIR |
EZJ |
|
| VLocator |
Supplier reference |
Optional |
EVFHBTS |
|
| JourneyType |
GDS specific |
|
Data Not Available |
|
| TicketDate |
BookingDate |
YYYY-MM-DD |
2018-07-10 |
|
| 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 |
|
1208.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 |
|
Data Not Available |
|
| TicketType |
GDS specific |
|
Data Not Available |
|
| |
|
|
|
|
| PassengerName |
FirstName + LastName |
|
Raphael Harmer |
|
| TicketNumber |
Airline locator |
|
Data Not Available |
|
| AirlineId |
FlightCarrierID |
In a multi sector flight, which
airline ID will be used |
1 |
|
| DepartureCityId |
DepartureAirportCode |
|
FAO |
|
| ArrivalCityId |
ArrivalAirportCode |
|
SEN |
|
| SupplierUserCode |
SupplierCode |
Suppler UserCode from PenAIR |
EZJ |
|
| VLocator |
Supplier reference |
Optional |
EVFHBTS |
|
| JourneyType |
GDS specific |
|
Data Not Available |
|
| TicketDate |
BookingDate |
YYYY-MM-DD |
2018-07-10 |
|
| 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 |
|
1208.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 |
|
Data Not Available |
|
| TicketType |
GDS specific |
|
Data Not Available |
|
| |
|
|
|
|
| PassengerName |
FirstName + LastName |
|
oyce Harmer |
|
| TicketNumber |
Airline locator |
|
Data Not Available |
|
| AirlineId |
FlightCarrierID |
In a multi sector flight, which
airline ID will be used |
1 |
|
| DepartureCityId |
DepartureAirportCode |
|
FAO |
|
| ArrivalCityId |
ArrivalAirportCode |
|
SEN |
|
| SupplierUserCode |
SupplierCode |
Suppler UserCode from PenAIR |
EZJ |
|
| VLocator |
Supplier reference |
Optional |
EVFHBTS |
|
| JourneyType |
GDS specific |
|
Data Not Available |
|
| TicketDate |
BookingDate |
YYYY-MM-DD |
2018-07-10 |
|
| 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 |
|
1208.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 |
|
Data Not Available |
|
| TicketType |
GDS specific |
|
Data Not Available |
|
| |
|
|
|
|
| PassengerName |
FirstName + LastName |
|
Benjamin Harmer |
|
| TicketNumber |
Airline locator |
|
Data Not Available |
|
| AirlineId |
FlightCarrierID |
In a multi sector flight, which
airline ID will be used |
1 |
|
| DepartureCityId |
DepartureAirportCode |
|
FAO |
|
| ArrivalCityId |
ArrivalAirportCode |
|
SEN |
|
| SupplierUserCode |
SupplierCode |
Suppler UserCode from PenAIR |
EZJ |
|
| VLocator |
Supplier reference |
Optional |
EVFHBTS |
|
| JourneyType |
GDS specific |
|
Data Not Available |
|
| TicketDate |
BookingDate |
YYYY-MM-DD |
2018-07-10 |
|
| 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 |
|
1208.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 |
|
Data Not Available |
|
| TicketType |
GDS specific |
|
Data Not Available |
|
| Hotel |
|
|
| HotelDetails |
[ Data
picked from Properties.Property] |
|
|
| SupplierUserCode |
SupplierCode |
Supplier UserCode from PenAIR |
EZJ |
|
| HotelName |
HotelName |
|
Pestana Algarve Race Hotel & Resort |
|
| RoomType |
RoomType |
|
Double Or Twin Deluxe |
|
| Rooms |
Rooms |
|
2 |
|
| DateIn |
ArrivalDate |
YYYY-MM-DD |
2018-08-02 |
|
| DateOut |
ReturnDate |
YYYY-MM-DD |
2018-08-07 |
|
| Status |
Pending / Confirmed - will always be confirmed |
Values:Confirmed,Wait listed |
Confirmed |
|
| Values
don’t match with what PenAir has shared |
|
| VoucherNumber |
PropertyBookingReference |
|
1033061A |
|
| HotelId |
PropertyReferenceID |
Hotel ID from PenAIR |
98791 |
|
| CityCode |
CityCode |
City Code from PenAIR |
Data Not Available |
|
| CurrencyCode |
CurrencyCode |
|
GBP |
|
| DocCurrencyAmt |
|
|
|
|
| NoOfPax |
No. Of Pax |
Adults + Children?? |
5 |
|
| PaymentMethod |
PaymentMethod |
Values:Company Card,Customer
Card,Customer Pay Locally,Credit |
Data Not Available |
|
| RoomDescription |
Room Description |
|
Double Or Twin Deluxe |
|
| ConfirmationNo |
PropertyRoomBookingID |
|
1235 |
|
| GeneralInfo |
|
|
|
|
| Address |
Property/Hotel Address |
|
Data Not Available |
|
| Phone |
Property/Hotel Phone |
|
Data Not Available |
|
| Fax |
Property/Hotel Fax ( if
available ? ) |
|
Data Not Available |
|
| RoomRateDescription |
|
|
Double Or Twin Deluxe |
|
| CancellationPolicy |
NA |
|
Data Not Available |
|
| ExchangeRate |
GBP as this stage |
|
GBP |
|
| GuestName |
FirstName + LastName |
Data picked from Properties.Property. Rooms.Room. GuestDetails |
Sandra Harmer |
|
| CommissionPercentage |
not preset |
|
Data Not Available |
|
| CommissionAmount |
not preset |
|
Data Not Available |
|
| CheckInTime |
CheckInTime |
hh:mm:ss |
Data Not Available |
|
| Checkouttime |
Checkouttime |
hh:mm:ss |
Data Not Available |
|
| Email |
CustomerEmail |
Data picked from LeadCustomer.CustomerEmail |
sfharmer@hotmail.com |
|
| MealPlan |
MealBasisID |
Optional |
Bed & Breakfast |
|
| Car |
|
|
| CarDetails |
[ Data
to be picked from CarHireBookings] |
|
|
| 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 |
Data Not Available |
|
| Provider |
Source |
|
HolidayTaxis |
|
| FromCity |
CityCode |
City Code from PenAIR |
Faro - Algarve (FAO) |
|
| ToCity |
CityCode |
City Code from PenAIR |
Pestana Algarve Race Hotel & Resort |
|
| DepartureDate |
DepartureDate |
YYYY-MM-DD |
2018-08-02 |
|
| DepartureTime |
DepartureTime |
hh:mm:ss |
19:35 |
2018-08-07 |
| VehicleType |
Vehicle Type |
|
Shuttle Transfer with Wi-Fi |
|
| FlightDetails |
DepartureFlightCode |
|
EZY7363 |
|
| Status |
Status |
Values:OK,Pending |
OK |
|
| Payable |
|
|
|
|
| PaymentMethod |
PaymentMethod |
Values:Company Card,Customer
Card,Customer Pay Locally,Credit |
Data Not Available |
|
| SupplierRef |
SourceReference |
|
CTS-9294945 |
|
| Comments |
|
|
|
|
| CurrencyCode |
CurrencyCode |
|
GBP |
|
| ExchangeRate |
GBP only at this stage |
|
GBP |
|
| CommissionOn |
not preset |
Value:Purchase |
Data Not Available |
|
| DocCurrencyAmt |
|
|
179.00 |
|
| CommissionPercentage |
not preset |
|
Data Not Available |
|
| CommissionAmount |
not preset |
|
Data Not Available |
|
| Notes |
|
|
Data Not Available |
|
| FolderAlert |
alert for diary completed post
upload |
|
Data Not Available |
|
| |
|
|
|
|
| |
|
|
|
|
| SupplierUserCode |
Supplier Usercode from PenAIR |
Supplier Usercode from PenAIR |
Data Not Available |
|
| Provider |
Source |
|
HolidayTaxis |
|
| FromCity |
CityCode |
City Code from PenAIR |
Pestana Algarve Race Hotel & Resort |
|
| ToCity |
CityCode |
City Code from PenAIR |
Faro - Algarve (FAO) |
|
| DepartureDate |
DepartureDate |
YYYY-MM-DD |
2018-08-07 |
|
| DepartureTime |
DepartureTime |
hh:mm:ss |
20:05 |
|
| VehicleType |
Vehicle Type |
|
Shuttle Transfer with Wi-Fi |
|
| FlightDetails |
DepartureFlightCode |
|
EZY7363 |
|
| Status |
Status |
Values:OK,Pending |
OK |
|
| Payable |
|
|
|
|
| PaymentMethod |
PaymentMethod |
Values:Company Card,Customer
Card,Customer Pay Locally,Credit |
Data Not Available |
|
| SupplierRef |
SourceReference |
|
CTS-9294945 |
|
| Comments |
|
|
|
|
| CurrencyCode |
CurrencyCode |
|
GBP |
|
| ExchangeRate |
GBP only at this stage |
|
GBP |
|
| CommissionOn |
not preset |
Value:Purchase |
Data Not Available |
|
| DocCurrencyAmt |
|
|
179.00 |
|
| CommissionPercentage |
not preset |
|
Data Not Available |
|
| CommissionAmount |
not preset |
|
Data Not Available |
|
| Notes |
|
|
Data Not Available |
|
| FolderAlert |
alert for diary completed post
upload |
|
Data Not Available |
|
| Payment |
|
|
| PaymentDetails |
[ Data
picked from ??] |
|
|
| PaymentDetails |
|
|
|
|
| VendorTxCode |
|
|
Data Not Available |
|
| TransactionId |
WorldpayTransId |
|
Data Not Available |
|
| TxAuthNo |
|
|
Data Not Available |
|
| Amount |
Amount |
|
Data Not Available |
|
| CardType |
Card Type |
|
2684.70 |
|
| CardCharge |
no cc fees as of Jan 18 |
|
Data Not Available |
|
| ThreeDSecureStatus |
should link with upload, where
3DS is applicable |
|
Data Not Available |
|
|
|
|
|
|