Order Export

Материал из Центр поддержки системы бронировании
Версия от 12:26, 14 мая 2020; Илья Шалетин (обсуждение | вклад)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к навигации Перейти к поиску

Order export is export of order data or orders for various components of the Websky system.

Description

The module allows the external system to obtain order data for further processing.

Export process

The process of order export is schematically presented on the block diagram.

Sofi Nemo export.png

Attention!

  • Order in SOFI format will be exported during synchronization only if there are changes in the order.
  • Order in SOFI format will be exported during cancellation only if the order contains cancelled services.

Settings

Setting up the order uploading process for airline tickets

Order export settings are available via System settings → Integration → Export of bookings.

  • Nemo Backoffice — the possibility to export orders in JSON format, which provides more complete and up-to-date data amount, uses international standards of data format, and is an improved version of data export protocol in Websky format.
  • Address for sending notifications about order changes — if specified, a GET-request is sent to this address when changes are received during the actualization. (Example http://127.0.0.1/?booking_id=ORDER_ID&nemo_id=NEMO_CONNECT_ORDER_ID&locator=LOCATOR). The value format supports variables LOCATOR, ORDER_ID, NEMO_CONNECT_ORDER_ID - (LOCATOR - service identifier in service provider's system, ORDER_ID - Websky order identifier, NEMO_CONNECT_ORDER_ID - order identifier in NEMO Connect).
  • Url of third party script for XML notifications in Websky format — URL to which the data will be uploaded.
  • Url of third party script for XML notifications in SOFI format — URL to which the data will be uploaded.

Websky sends upload files to the http address specified in this field via a POST request (see https://ru.wikipedia.org/wiki/POST_(HTTP) ). The script for processing the received data must be written on the client's side. The script task is to accept the data and process them correctly. All data which can be received through a browser, also are possible to receive via alternative software means (automating export process). It is recommended to use CURL library (see https://ru.wikipedia.org/wiki/CURL). Websky staff does not provide ready-made sample scripts.
If a subagent has a different URL script for export than the root agency URL, the export by order of this subagent will be directed to both addresses. The main agent receives information on all orders of all subagents, the subagent receives the export data only of its orders.

  • Nemo Backoffice export url — URL to which the data will be uploaded.
  • Website code in SOFI — agency ID on the SOFI side. The code is required to connect the agency in SOFI and Websky. If the agency is created in SOFI, its code is specified in this field. Then SOFI will identify orders from specified agency in SOFI unloading.
  • Resending in case of failure — The setting allows you to retry exporting the order at a certain time interval (maximum 3 attempts).
  • A list of addresses for notifications (separated by commas) — This setting allows you to specify one or more email addresses to which a problem order notification will be sent in case all export attempts fail.
  • Export after payment — The setting allows you to additionally export orders after an order payment event.
  • Export order access code — The setting enables you to display the export access code.
  • Send a notification on the need to set a validator code in requisites — The setting allows you to automatically send a notification when an order is exported to SOFI without a validator code.
  • Time zone for dates — The setting allows you to change the time zone in SOFI export.
    "Time zone for dates" setting
    • Use time zone from system settings, through which the time zone specified in "System Settings" will be used.
    • Use time zone from requisites — The time zone is raised individually from each set of GDS connection requisites.
    • Select other time zone enables you to select the time zone independently of other settings.

Order export formats

The system supports order export in formats Websky, SOFI и JSON. It is recommended to use JSON export functionality.

Components supporting order export

Air Tickets Hotels Rail
Websky format + +
SOFI format +
JSON format + + +

Events supporting order export

Авиабилеты Booking Payment* Synchronization** Ticketing Voiding Cancellation*** Exchange/Refund****
Websky format + + + + + + +
SOFI format + + + + +
JSON format + + + + + + +
Отели Booking Payment* Synchronization** Ticketing Voiding Cancellation
JSON format + + + Voiding unavailable +
ЖД Booking Payment Synchronization** Ticketing Voiding Cancellation
Websky format + + + + + +
JSON format + + + + + +

*  A Websky order will be uploaded when paid only if the «Export after payment»' setting is enabled в разделе «Orders»«Order export».
** The order will be exported during synchronization only if there are changes in the order.
***  An order in SOFI format will be exported upon cancellation only if the order contains the cancelled ancillary services.
****  The order will be exported upon exchange or refund when the work with claim is finished (if PNR import is skipped).

Order export statuses

Order export status codes correspond to HTTP status codes. In fact, the last HTTP status code received when uploading data to the address specified in the upload settings is specified. The codes refer to the server to which the orders are exported.

Code Description
0 Unknown response. Export address not available.
200 OK - successful request.
301 The requested document was completely moved to the new URI specified in the Location field of the header.
403 The server has recognized the request, but it refuses to execute it because of the access restrictions to the specified resource for the client.
404 The server has recognized the request but did not find the required resource by the specified URI.
422 Unprocessable Entity - the server has successfully accepted the request, can work with the specified type of data, the XML document in the request body has the correct syntax, but there is some logical error that prevents operation on the resource.
500 Any internal server error.

Order export for the Avia Tickets component

For the «Avia Tickets» component, orders in Websky and/or SOFI formats are available for export (when «SOFI order export» module is enabled).

Websky format

  1 <?xml version="1.0" encoding="UTF-8"?>
  2 <PNR>
  3   <Common>
  4     <id>277749</id>
  5     <Type>FLIGHTS</Type>
  6     <Service>SABRE</Service>
  7     <Locator>SQLJNK</Locator>
  8     <ExternalId>1234567</ExternalId> <!-- External ID -->
  9     <Stamp>123456789</Stamp>
 10     <UtmSource>100</UtmSource> <!-- Source of transition -->
 11     <BeginDateTime>2014.12.18-10:45</BeginDateTime>
 12     <EndDateTime>2014.12.25-16:40</EndDateTime>
 13     <TicketingDateTime>2014.12.09-15:02</TicketingDateTime>
 14     <VoidDateTime/>
 15     <TotalPrice>
 16       <Amount>10773.8</Amount>
 17       <CurrencyCode>RUB</CurrencyCode>
 18     </TotalPrice>
 19     <UserId>2964</UserId>
 20     <EEUserId/>
 21     <UserLogin>userLogin</UserLogin>
 22     <GroupId>2963</GroupId>
 23     <CompanyId>2963</CompanyId>
 24     <UserStatus>Менеджер</UserStatus>
 25     <DateCreate>2014.12.09-14:59</DateCreate>
 26     <ExtServices> <!-- Ancillary services -->
 27       <ExtService>
 28         <Type>ServicePack</Type> <!-- Service packages -->
 29         <Price>
 30           <Amount>200</Amount>
 31           <CurrencyCode>RUB</CurrencyCode>
 32         </Price>
 33       </ExtService>
 34       <ExtService>
 35         <Type>AeroExpress</Type>
 36         <Price>
 37           <Amount>1440</Amount>
 38           <CurrencyCode>RUB</CurrencyCode>
 39         </Price>
 40       </ExtService>
 41       <ExtService>
 42         <Type>AlphaInsurance</Type>
 43         <Price>
 44           <Amount>480</Amount>
 45           <CurrencyCode>RUB</CurrencyCode>
 46         </Price>
 47         <Insurances>
 48           <Insurance>
 49             <Number>Z694.198TEST.2765282</Number>
 50             <Fio>IVANOV IVAN</Fio>
 51           </Insurance>
 52           <Insurance>
 53             <Number>Z694.198TEST.2765283</Number>
 54             <Fio>PETROV PETR</Fio>
 55           </Insurance>
 56         </Insurances>
 57       </ExtService>
 58     </ExtServices>
 59     <isManualStatus>0</isManualStatus>  <!-- Manual ticketing attribute. 1 - manual fixing of the order. 0 - automatic. -->
 60   </Common>
 61   <Payment>
 62     <Title>Testpay</Title>
 63     <Method>Testpay</Method>
 64     <BillingId>117607091</BillingId>
 65     <Date>2014-12-09 15:00:39</Date>
 66     <CreateDate>2014-12-09 15:00:34</CreateDate>
 67     <Status>ticket</Status>
 68     <PenaltyDate/>
 69     <Timelimit>2014-12-10 14:59:55</Timelimit>
 70     <PaymentCharge> <!-- Payment gateway charge -->
 71       <Amount>313.8</Amount>
 72       <CurrencyCode>RUB</CurrencyCode>
 73     </PaymentCharge>
 74     <Charge> <!-- Total charge minus payment gateway charge -->
 75       <Amount>1920</Amount>
 76       <CurrencyCode>RUB</CurrencyCode>
 77     </Charge>
 78     <SubagentCharge> <!-- Subagent charge specified in "Pricing for Subagents" module -->
 79       <Amount>500</Amount>
 80       <CurrencyCode>RUB</CurrencyCode>
 81     </SubagentCharge>
 82     <BaseFare> <!-- Fare -->
 83       <Amount>1600</Amount>
 84       <CurrencyCode>RUB</CurrencyCode>
 85     </BaseFare>
 86     <Book> <!-- Fare plus taxes -->
 87       <Amount>8540</Amount>
 88       <CurrencyCode>RUB</CurrencyCode>
 89     </Book>
 90     <Penalty>
 91       <Amount>0</Amount>
 92       <CurrencyCode>RUB</CurrencyCode>
 93     </Penalty>
 94     <Total>
 95       <Amount>10773.8</Amount>
 96       <CurrencyCode>RUB</CurrencyCode>
 97     </Total>
 98     <Commission>
 99       <Amount>0</Amount>
100       <CurrencyCode>RUB</CurrencyCode>
101     </Commission>
102     <PaidValue>
103       <Amount>10773.8</Amount>
104       <CurrencyCode>RUB</CurrencyCode>
105     </PaidValue>
106   </Payment>
107   <Client>
108     <LastName/>
109     <Name>SIDOROV PETR</Name>
110     <MiddleName/>
111     <Number/>
112     <Birth/>
113     <Email>mail@host.com</Email>
114     <Phone>+74950000000</Phone>
115   </Client>
116   <PassengersCount>2</PassengersCount>
117   <Passengers>
118     <Passenger>
119       <passenger_type>ADT</passenger_type>
120       <lastname>IVANOV</lastname>
121       <name>IVAN</name>
122       <gender>F</gender>
123       <date_of_birth>12.12.1987</date_of_birth>
124       <doc_type>C</doc_type>
125       <passport_number>1234567890</passport_number>
126       <currency_of_passport>24.03.2023</currency_of_passport>
127       <middlename/>
128       <passenger_id>37667</passenger_id>
129       <nationality>RU</nationality>
130       <email>mail@host.com</email>
131       <Tickets>
132         <Active>0</Active> <!-- Ticket status. 0 - ticket voided, 1 - ticket active-->
133         <Seg/>
134         <Num>5553984070962</Num>
135         <Date>2014-12-09 16:01:00</Date>
136       </Tickets>
137       <Tickets>
138         <Active>1</Active> <!-- Ticket status. 0 - ticket voided, 1 - ticket active-->
139         <Seg/>
140         <Num>5553984070964</Num>
141         <Date>2014-12-09 16:03:00</Date>
142       </Tickets>
143       <PriceInfo>
144         <BaseFare>
145           <Amount>800</Amount>
146           <CurrencyCode>RUB</CurrencyCode>
147         </BaseFare>
148         <TotalFare>
149           <Amount>4270</Amount>
150           <CurrencyCode>RUB</CurrencyCode>
151         </TotalFare>
152         <Commission>
153           <Amount>0</Amount>
154           <CurrencyCode>RUB</CurrencyCode>
155         </Commission>
156         <AirlineCommission>
157           <Amount>0</Amount>
158           <CurrencyCode>RUB</CurrencyCode>
159         </AirlineCommission>
160       </PriceInfo>
161     </Passenger>
162     <Passenger>
163       <passenger_type>ADT</passenger_type>
164       <doc_type>C</doc_type>
165       <middlename/>
166       <passenger_id>37668</passenger_id>
167       <lastname>PETROV</lastname>
168       <name>PETR</name>
169       <gender>M</gender>
170       <date_of_birth>20.12.1984</date_of_birth>
171       <passport_number>1234567899</passport_number>
172       <currency_of_passport>20.12.2029</currency_of_passport>
173       <nationality>RU</nationality>
174       <email>mail@host.com</email>
175       <Tickets>
176         <Active>0</Active> <!-- Ticket status. 0 - ticket voided, 1 - ticket active -->
177         <Seg/>
178         <Num>5553984070963</Num>
179         <Date>2014-12-09 16:01:00</Date>
180       </Tickets>
181       <Tickets>
182         <Active>1</Active> <!-- Ticket status. 0 - ticket voided, 1 - ticket active -->
183         <Seg/>
184         <Num>5553984070965</Num>
185         <Date>2014-12-09 16:03:00</Date>
186       </Tickets>
187       <PriceInfo>
188         <BaseFare>
189           <Amount>800</Amount>
190           <CurrencyCode>RUB</CurrencyCode>
191         </BaseFare>
192         <TotalFare>
193           <Amount>4270</Amount>
194           <CurrencyCode>RUB</CurrencyCode>
195         </TotalFare>
196         <Commission>
197           <Amount>0</Amount>
198           <CurrencyCode>RUB</CurrencyCode>
199         </Commission>
200         <AirlineCommission>
201           <Amount>0</Amount>
202           <CurrencyCode>RUB</CurrencyCode>
203         </AirlineCommission>
204       </PriceInfo>
205     </Passenger>
206   </Passengers>
207   <FlightType>Внутренний</FlightType>
208   <Marker/>
209   <BookingCode>4R72Z4</BookingCode> 
210   <OrderInfo>
211     <Info>
212       <Company>Аэрофлот - Российские авиалинии</Company>
213       <CompanyCode>SU</CompanyCode>
214       <OperatingCompanyCode>FV</OperatingCompanyCode>
215       <StartDate>2014.12.18</StartDate>
216       <StartTime>10:45</StartTime>
217       <StartDayOfWeek>Thursday</StartDayOfWeek>
218       <FlightNumber>6128 (FV6128)</FlightNumber>
219       <StartAirportCode>VKO</StartAirportCode>
220       <StartAirportName>Внуково, Москва</StartAirportName>
221       <StartCountry>Россия</StartCountry>
222       <StartCountryCode>RU</StartCountryCode>
223       <EndAirportCode>LED</EndAirportCode>
224       <EndAirportName>Санкт-Петербург, Пулково</EndAirportName>
225       <EndCountry>Россия</EndCountry>
226       <EndCountryCode>RU</EndCountryCode>
227       <Time>1:30</Time>
228       <Equip>
229         <Name>Airbus 319</Name>
230         <Type>319</Type>
231       </Equip>
232       <ClassType>economy</ClassType>
233       <ClassTypeCode>R</ClassTypeCode>
234       <Meal/>
235     </Info>
236     <Info>
237       <Company>Аэрофлот - Российские авиалинии</Company>
238       <CompanyCode>SU</CompanyCode>
239       <OperatingCompanyCode>FV</OperatingCompanyCode>
240       <StartDate>2014.12.25</StartDate>
241       <StartTime>15:10</StartTime>
242       <StartDayOfWeek>Thursday</StartDayOfWeek>
243       <FlightNumber>6153 (FV6153)</FlightNumber>
244       <StartAirportCode>LED</StartAirportCode>
245       <StartAirportName>Санкт-Петербург, Пулково</StartAirportName>
246       <StartCountry>Россия</StartCountry>
247       <StartCountryCode>RU</StartCountryCode>
248       <EndAirportCode>VKO</EndAirportCode>
249       <EndAirportName>Внуково, Москва</EndAirportName>
250       <EndCountry>Россия</EndCountry>
251       <EndCountryCode>RU</EndCountryCode>
252       <Time>1:30</Time>
253       <Equip>
254         <Name>Airbus 319</Name>
255         <Type>319</Type>
256       </Equip>
257       <ClassType>economy</ClassType>
258       <ClassTypeCode>R</ClassTypeCode>
259       <Meal/>
260     </Info>
261   </OrderInfo>
262   <Remarks>Debit</Remarks>
263   <Returns> <!-- Refund claims block -->
264     <Return>
265       <ExpertUserId>2411</ExpertUserId>
266       <Id>458463</Id>
267       <Price>
268         <Amount>-5997.17</Amount> <!-- The amount to be refunded calculated in the refund request -->
269         <CurrencyCode>RUB</CurrencyCode>
270       </Price>
271       <PassengersData>
272         <Data>
273           <PassengerNum>2</PassengerNum>
274           <SegmentNums>
275             <SegmentNum>1</SegmentNum>
276             <SegmentNum>2</SegmentNum>
277           </SegmentNums>
278         </Data>
279       </PassengersData>
280       <IsFull>0</IsFull>
281       <IsCompelled>0</IsCompelled>
282     </Return>
283   </Returns>
284   <Exchanges>  <!-- Exchange Request Block -->
285     <Exchange>
286       <ExpertUserId>2411</ExpertUserId>
287       <Id>458480</Id>
288       <Price>
289         <Amount>2279.06</Amount>  <!-- Amount to the surcharge calculated in the exchange request -->
290         <CurrencyCode>RUB</CurrencyCode>
291       </Price>
292       <Text>Reason for creating the claim</Text>
293     </Exchange>
294   </Exchanges>
295 </PNR>


Attention! If the Service Package selected by the client has a zero value - it will not be displayed in the export.

<Remarks>Debit</Remarks> remark is not obligatory, means that the order was paid with the " Company Balance" payment method; if the order was paid via deposit credit, and the balance was minus even by 1 rub., it will be

<Remarks>Credit</Remarks>.

<TotalFare> element refunds an order already paid for. If the order is booked but not paid, the value will be 0 RUB.

<CreateDate> element, depending on the condition of the booking, refunds the end time of the booking, if it was completed, otherwise returns the time of making the booking.

<Returns> and <Exchanges> blocks contains data on exchange and/or refund claims that are linked to the order. Only the completed exchange and/or refund claims are exported. Note that the amount to be refunded on the claim is indicated with a "-" sign and the amount to be surcharged goes without additional signs.

The format supports the possibility of transmitting several e-ticket numbers per passenger (including those voided and cancelled).

Websky format for composite bookings (MultiOW)

  1 <PNR>
  2 	<ParentBook>
  3 		<ID>508015</ID>
  4 		<Payment>
  5 			<Title>Testpay</Title>
  6 			<Method>Testpay</Method>
  7 			<PaymentGateway>testpay</PaymentGateway>
  8 			<BillingId>117916164</BillingId>
  9 			<Date>2018-05-28 13:03:17</Date>
 10 			<CreateDate>2018-05-28 13:02:51</CreateDate>
 11 			<Status>ticket</Status>
 12 			<PenaltyDate/>
 13 			<Timelimit>2018-05-31 13:00:00</Timelimit>
 14 			<PaymentCharge>
 15 				<Amount>0</Amount>
 16 				<CurrencyCode>RUB</CurrencyCode>
 17 			</PaymentCharge>
 18 			<Charge>
 19 				<Amount>1220</Amount>
 20 				<CurrencyCode>RUB</CurrencyCode>
 21 			</Charge>
 22 			<AgentCharge>
 23 				<Amount>-300</Amount>
 24 				<CurrencyCode>RUB</CurrencyCode>
 25 			</AgentCharge>
 26 			<BaseFare>
 27 				<Amount>6950</Amount>
 28 				<CurrencyCode>RUB</CurrencyCode>
 29 			</BaseFare>
 30 			<Book>
 31 				<Amount>14382</Amount>
 32 				<CurrencyCode>RUB</CurrencyCode>
 33 			</Book>
 34 			<Penalty>
 35 				<Amount>0</Amount>
 36 				<CurrencyCode>RUB</CurrencyCode>
 37 			</Penalty>
 38 			<Total>
 39 				<Amount>15602</Amount>
 40 				<CurrencyCode>RUB</CurrencyCode>
 41 			</Total>
 42 			<Commission>
 43 				<Amount>0</Amount>
 44 				<CurrencyCode>RUB</CurrencyCode>
 45 			</Commission>
 46 			<AirlineCommission>
 47 				<Amount>38.25</Amount>
 48 				<CurrencyCode>RUB</CurrencyCode>
 49 			</AirlineCommission>
 50 			<PaidValue>
 51 				<Amount>15602</Amount>
 52 				<CurrencyCode>RUB</CurrencyCode>
 53 			</PaidValue>
 54 		</Payment>
 55 		<ChildBookIDs>
 56 			<ChildBookID>508019</ChildBookID>
 57 			<ChildBookID>508020</ChildBookID>
 58 		</ChildBookIDs>
 59 		<ExtServices>
 60 			<ExtService>
 61 				<Type>ServicePack</Type>
 62 				<Price>
 63 					<Amount>800</Amount>
 64 					<CurrencyCode>RUB</CurrencyCode>
 65 				</Price>
 66 			</ExtService>
 67 			<ExtService>
 68 				<Type>AlphaInsurance</Type>
 69 				<Price>
 70 					<Amount>720</Amount>
 71 					<CurrencyCode>RUB</CurrencyCode>
 72 				</Price>
 73 				<Insurances>
 74 					<Insurance>
 75 						<Number>Z694.198TEST.26725385</Number>
 76 						<Fio>BAGGINS BILBO</Fio>
 77 					</Insurance>
 78 					<Insurance>
 79 						<Number>Z694.198TEST.26725386</Number>
 80 						<Fio>IVANOV SEMYON</Fio>
 81 					</Insurance>
 82 					<Insurance>
 83 						<Number>Z694.198TEST.26725387</Number>
 84 						<Fio>ORK KIR</Fio>
 85 					</Insurance>
 86 				</Insurances>
 87 			</ExtService>
 88 		</ExtServices>
 89 	</ParentBook>
 90 	<Common>
 91 		<id>508019</id>
 92 		<Type>FLIGHTS</Type>
 93 		<Service>AMADEUS</Service>
 94 		<Locator>LOYYRD</Locator>
 95 		<UtmSource>66</UtmSource>
 96 		<BeginDateTime>2018.06.16-02:00</BeginDateTime>
 97 		<EndDateTime>2018.06.16-06:20</EndDateTime>
 98 		<TicketingDateTime>2018.05.28-13:04</TicketingDateTime>
 99 		<VoidDateTime/>
100 		<TotalPrice>
101 			<Amount>7057</Amount>
102 			<CurrencyCode>RUB</CurrencyCode>
103 		</TotalPrice>
104 		<UserId>10312</UserId>
105 		<EEUserId/>
106 		<UserLogin>test_user_1</UserLogin>
107 		<GroupId>10311</GroupId>
108 		<CompanyId>10309</CompanyId>
109 		<ExternalCompanyId/>
110 		<UserStatus>Пользователь</UserStatus>
111 		<DateCreate>2018.05.28-13:00</DateCreate>
112 		<isManualStatus>0</isManualStatus>
113 	</Common>
114 	<Payment>
115 		<Status>ticket</Status>
116 		<PenaltyDate/>
117 		<Timelimit>2018-06-01 20:59:00</Timelimit>
118 		<PaymentCharge>
119 			<Amount>0</Amount>
120 			<CurrencyCode>RUB</CurrencyCode>
121 		</PaymentCharge>
122 		<Charge>
123 			<Amount>150</Amount>
124 			<CurrencyCode>RUB</CurrencyCode>
125 		</Charge>
126 		<AgentCharge>
127 			<Amount>150</Amount>
128 			<CurrencyCode>RUB</CurrencyCode>
129 		</AgentCharge>
130 		<BaseFare>
131 			<Amount>3625</Amount>
132 			<CurrencyCode>RUB</CurrencyCode>
133 		</BaseFare>
134 		<Book>
135 			<Amount>6907</Amount>
136 			<CurrencyCode>RUB</CurrencyCode>
137 		</Book>
138 		<Penalty>
139 			<Amount>0</Amount>
140 			<CurrencyCode>RUB</CurrencyCode>
141 		</Penalty>
142 		<Total>
143 			<Amount>7057</Amount>
144 			<CurrencyCode>RUB</CurrencyCode>
145 		</Total>
146 		<Commission>
147 			<Amount>0</Amount>
148 			<CurrencyCode>RUB</CurrencyCode>
149 		</Commission>
150 		<AirlineCommission>
151 			<Amount>36.25</Amount>
152 			<CurrencyCode>RUB</CurrencyCode>
153 		</AirlineCommission>
154 		<PaidValue>
155 			<Amount>0</Amount>
156 			<CurrencyCode>RUB</CurrencyCode>
157 		</PaidValue>
158 	</Payment>
159 	<Client>
160 		<LastName/>
161 		<Name> </Name>
162 		<MiddleName/>
163 		<Number/>
164 		<Birth/>
165 		<Email>qddednbavfta@dropmail.me</Email>
166 		<Phone/>
167 	</Client>
168 	<PassengersCount>3</PassengersCount>
169 	<Passengers>
170 		<Passenger>
171 			<name>BILBO</name>
172 			<lastname>BAGGINS</lastname>
173 			<passenger_type>CLD</passenger_type>
174 			<doc_type>P</doc_type>
175 			<date_of_birth>02.01.2015</date_of_birth>
176 			<nationality>RU</nationality>
177 			<gender>M</gender>
178 			<passport_number>985478569</passport_number>
179 			<currency_of_passport>28.05.2023</currency_of_passport>
180 			<Tickets>
181 				<Active>1</Active>
182 				<Seg/>
183 				<Num>5555966876471</Num>
184 				<Date>2018-05-28 13:04:05</Date>
185 			</Tickets>
186 			<PriceInfo>
187 				<BaseFare>
188 					<Amount>1555</Amount>
189 					<CurrencyCode>RUB</CurrencyCode>
190 				</BaseFare>
191 				<TotalFare>
192 					<Amount>3149</Amount>
193 					<CurrencyCode>RUB</CurrencyCode>
194 				</TotalFare>
195 				<Commission>
196 					<Amount>0</Amount>
197 					<CurrencyCode>RUB</CurrencyCode>
198 				</Commission>
199 				<AirlineCommission>
200 					<Amount>12.08</Amount>
201 					<CurrencyCode>RUB</CurrencyCode>
202 				</AirlineCommission>
203 			</PriceInfo>
204 		</Passenger>
205 		<Passenger>
206 			<name>SEMYON</name>
207 			<lastname>IVANOV</lastname>
208 			<passenger_type>ADT</passenger_type>
209 			<doc_type>P</doc_type>
210 			<date_of_birth>05.05.1945</date_of_birth>
211 			<nationality>RU</nationality>
212 			<gender>M</gender>
213 			<passport_number>954563562</passport_number>
214 			<currency_of_passport>25.03.2021</currency_of_passport>
215 			<phone>
216 				<number>+79998884444</number>
217 			</phone>
218 			<email>QDDEDNBAVFTA@DROPMAIL.ME</email>
219 			<Tickets>
220 				<Active>1</Active>
221 				<Seg/>
222 				<Num>5555966876472</Num>
223 				<Date>2018-05-28 13:04:05</Date>
224 			</Tickets>
225 			<PriceInfo>
226 				<BaseFare>
227 					<Amount>2070</Amount>
228 					<CurrencyCode>RUB</CurrencyCode>
229 				</BaseFare>
230 				<TotalFare>
231 					<Amount>3758</Amount>
232 					<CurrencyCode>RUB</CurrencyCode>
233 				</TotalFare>
234 				<Commission>
235 					<Amount>0</Amount>
236 					<CurrencyCode>RUB</CurrencyCode>
237 				</Commission>
238 				<AirlineCommission>
239 					<Amount>12.08</Amount>
240 					<CurrencyCode>RUB</CurrencyCode>
241 				</AirlineCommission>
242 			</PriceInfo>
243 		</Passenger>
244 		<Passenger>
245 			<name>KIR</name>
246 			<lastname>ORK</lastname>
247 			<passenger_type>INF</passenger_type>
248 			<doc_type>P</doc_type>
249 			<date_of_birth>08.09.2017</date_of_birth>
250 			<nationality>RU</nationality>
251 			<gender>M</gender>
252 			<passport_number>859654125</passport_number>
253 			<currency_of_passport>28.05.2023</currency_of_passport>
254 			<Tickets>
255 				<Active>1</Active>
256 				<Seg/>
257 				<Num>5555966876473</Num>
258 				<Date>2018-05-28 13:04:05</Date>
259 			</Tickets>
260 			<PriceInfo>
261 				<BaseFare>
262 					<Amount>0</Amount>
263 					<CurrencyCode>RUB</CurrencyCode>
264 				</BaseFare>
265 				<TotalFare>
266 					<Amount>0</Amount>
267 					<CurrencyCode>RUB</CurrencyCode>
268 				</TotalFare>
269 				<Commission>
270 					<Amount>0</Amount>
271 					<CurrencyCode>RUB</CurrencyCode>
272 				</Commission>
273 				<AirlineCommission>
274 					<Amount>12.08</Amount>
275 					<CurrencyCode>RUB</CurrencyCode>
276 				</AirlineCommission>
277 			</PriceInfo>
278 		</Passenger>
279 	</Passengers>
280 	<FlightType>Внутренний</FlightType>
281 	<Marker/>
282 	<OrderInfo>
283 		<Info>
284 			<Id>0</Id>
285 			<Company>Аэрофлот</Company>
286 			<CompanyCode>SU</CompanyCode>
287 			<OperatingCompanyCode>SU</OperatingCompanyCode>
288 			<StartDate>2018.06.16</StartDate>
289 			<StartTime>02:00</StartTime>
290 			<StartDayOfWeek>Saturday</StartDayOfWeek>
291 			<FlightNumber>1436 (SU1436)</FlightNumber>
292 			<StartAirportCode>SVO</StartAirportCode>
293 			<StartAirportName>Шереметьево, Москва</StartAirportName>
294 			<StartCountry>Россия</StartCountry>
295 			<StartCountryCode>RU</StartCountryCode>
296 			<EndAirportCode>SVX</EndAirportCode>
297 			<EndAirportName>Екатеринбург</EndAirportName>
298 			<EndCountry>Россия</EndCountry>
299 			<EndCountryCode>RU</EndCountryCode>
300 			<Time>2:20</Time>
301 			<Equip>
302 				<Name>Airbus A320 (with Sharklets)</Name>
303 				<Type>32A</Type>
304 			</Equip>
305 			<ClassType>economy</ClassType>
306 			<ClassTypeCode>N</ClassTypeCode>
307 			<Meal/>
308 		</Info>
309 	</OrderInfo>
310 	<Returns/>
311 	<Exchanges/>
312 </PNR>


Attention! The data in the ParentBook block is the same for both real bookings that are part of a composite one. But since a composite booking is a formal one, it cannot be reflected in the XML export.

  • ParentBook - general block, reflects information about the payment for the composite booking; the additional services purchased in the composite booking; and the numbers of both real orders of the composite booking.

SOFI format

  1 <?xml version="1.0" encoding="UTF-8"?>
  2 <order_snapshot xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  3   <header currency="RUB" time_gmt="2018-01-24 13:23:45" time="2018-01-24 16:23:45" ord_id="496571" corp_ord_id="1P2BK4" site="2410" corp_code="2440"/>
  4   <customer email="airjul2404@gmail.com" phone="XXXX0005" name="" corp_code="2440" bonus_card="200200200"/>
  5   <products>
  6     <product>
  7       <air_ticket_prod psg_type="A" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="0" taxes="3005" fare="0" service_fee="356.5" commission="30" origin="SVX" destination="MOW">
  8         <air_seg segment_id="0" carrier="NN" flight_number="200" op_carrier="NN" departure_datetime="2018-03-22 06:00:00" arrival_datetime="2018-03-22 09:00:00" departure_airport="SVX" arrival_airport="DME" fare_basis="YCH">
  9           <air_tax amount="2085" code="YQ"/>
 10           <air_tax amount="70" code="RU"/>
 11           <air_tax amount="850" code="RI"/>
 12         </air_seg>
 13         <fees>
 14           <fee type="commission" code="commission_vcarrier" amount="7.5"/>
 15         </fees>
 16       </air_ticket_prod>
 17     </product>
 18     <product>
 19       <air_ticket_prod psg_type="A" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="1" taxes="698" fare="6100" service_fee="356.5" commission="30" origin="SVX" destination="MOW">
 20         <air_seg segment_id="1" carrier="U6" flight_number="161" op_carrier="U6" departure_datetime="2018-03-24 11:20:00" arrival_datetime="2018-03-24 15:30:00" departure_airport="DME" arrival_airport="SVX" fare_basis="KPROW">
 21           <air_tax amount="185" code="ZZ"/>
 22           <air_tax amount="513" code="RI"/>
 23         </air_seg>
 24         <fees>
 25           <fee type="commission" code="commission_vcarrier" amount="7.5"/>
 26         </fees>
 27       </air_ticket_prod>
 28     </product>
 29     <product>
 30       <air_ticket_prod psg_type="A" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="2" taxes="500" fare="" service_fee="0" commission="0" origin="SVX" destination="MOW"/>
 31     </product>
 32     <product>
 33       <air_ticket_prod psg_type="A" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="3" taxes="3005" fare="0" service_fee="356.5" commission="30" origin="SVX" destination="MOW">
 34         <air_seg segment_id="0" carrier="NN" flight_number="200" op_carrier="NN" departure_datetime="2018-03-22 06:00:00" arrival_datetime="2018-03-22 09:00:00" departure_airport="SVX" arrival_airport="DME" fare_basis="YCH">
 35           <air_tax amount="2085" code="YQ"/>
 36           <air_tax amount="70" code="RU"/>
 37           <air_tax amount="850" code="RI"/>
 38         </air_seg>
 39         <fees>
 40           <fee type="commission" code="commission_vcarrier" amount="7.5"/>
 41         </fees>
 42       </air_ticket_prod>
 43     </product>
 44     <product>
 45       <air_ticket_prod psg_type="A" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="4" taxes="698" fare="6100" service_fee="356.5" commission="30" origin="SVX" destination="MOW">
 46         <air_seg segment_id="1" carrier="U6" flight_number="161" op_carrier="U6" departure_datetime="2018-03-24 11:20:00" arrival_datetime="2018-03-24 15:30:00" departure_airport="DME" arrival_airport="SVX" fare_basis="KPROW">
 47           <air_tax amount="185" code="ZZ"/>
 48           <air_tax amount="513" code="RI"/>
 49         </air_seg>
 50         <fees>
 51           <fee type="commission" code="commission_vcarrier" amount="7.5"/>
 52         </fees>
 53       </air_ticket_prod>
 54     </product>
 55     <product>
 56       <air_ticket_prod psg_type="A" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="5" taxes="500" fare="" service_fee="0" commission="0" origin="SVX" destination="MOW"/>
 57     </product>
 58     <product>
 59       <air_ticket_prod psg_type="C" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="6" taxes="3005" fare="0" service_fee="356.5" commission="30" origin="SVX" destination="MOW">
 60         <air_seg segment_id="0" carrier="NN" flight_number="200" op_carrier="NN" departure_datetime="2018-03-22 06:00:00" arrival_datetime="2018-03-22 09:00:00" departure_airport="SVX" arrival_airport="DME" fare_basis="YCH/CN0">
 61           <air_tax amount="2085" code="YQ"/>
 62           <air_tax amount="70" code="RU"/>
 63           <air_tax amount="850" code="RI"/>
 64         </air_seg>
 65         <fees>
 66           <fee type="commission" code="commission_vcarrier" amount="7.5"/>
 67         </fees>
 68       </air_ticket_prod>
 69     </product>
 70     <product>
 71       <air_ticket_prod psg_type="C" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="7" taxes="698" fare="4575" service_fee="356.5" commission="30" origin="SVX" destination="MOW">
 72         <air_seg segment_id="1" carrier="U6" flight_number="161" op_carrier="U6" departure_datetime="2018-03-24 11:20:00" arrival_datetime="2018-03-24 15:30:00" departure_airport="DME" arrival_airport="SVX" fare_basis="KPROW/CH25">
 73           <air_tax amount="185" code="ZZ"/>
 74           <air_tax amount="513" code="RI"/>
 75         </air_seg>
 76         <fees>
 77           <fee type="commission" code="commission_vcarrier" amount="7.5"/>
 78         </fees>
 79       </air_ticket_prod>
 80     </product>
 81     <product>
 82       <air_ticket_prod psg_type="C" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="8" taxes="250" fare="" service_fee="0" commission="0" origin="SVX" destination="MOW"/>
 83     </product>
 84     <product>
 85       <air_ticket_prod psg_type="I" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="9" taxes="3005" fare="0" service_fee="356.5" commission="30" origin="SVX" destination="MOW">
 86         <air_seg segment_id="0" carrier="NN" flight_number="200" op_carrier="NN" departure_datetime="2018-03-22 06:00:00" arrival_datetime="2018-03-22 09:00:00" departure_airport="SVX" arrival_airport="DME" fare_basis="YCH/IN0">
 87           <air_tax amount="2085" code="YQ"/>
 88           <air_tax amount="70" code="RU"/>
 89           <air_tax amount="850" code="RI"/>
 90         </air_seg>
 91         <fees>
 92           <fee type="commission" code="commission_vcarrier" amount="7.5"/>
 93         </fees>
 94       </air_ticket_prod>
 95     </product>
 96     <product>
 97       <air_ticket_prod psg_type="I" title="Екатеринбург - Москва - Екатеринбург" form_owner="NN" validating_carrier="NN" prod_id="10" taxes="513" fare="0" service_fee="356.5" commission="30" origin="SVX" destination="MOW">
 98         <air_seg segment_id="1" carrier="U6" flight_number="161" op_carrier="U6" departure_datetime="2018-03-24 11:20:00" arrival_datetime="2018-03-24 15:30:00" departure_airport="DME" arrival_airport="SVX" fare_basis="KPROW/IN00">
 99           <air_tax amount="513" code="RI"/>
100         </air_seg>
101         <fees>
102           <fee type="commission" code="commission_vcarrier" amount="7.5"/>
103         </fees>
104       </air_ticket_prod>
105     </product>
106     <product>
107       <ral_ticket_prod rsrv_id="4965710200" prod_id="4965710200200" origin="Домодедово, Москва" destination="Павелецкий вокзал" departure_datetime="2018-03-22 10:00:00" cartype="standart" fare="420"/>
108     </product>
109     <product>
110       <ral_ticket_prod rsrv_id="4965710200" prod_id="4965710200201" origin="Домодедово, Москва" destination="Павелецкий вокзал" departure_datetime="2018-03-22 10:00:00" cartype="standart" fare="420"/>
111     </product>
112     <product>
113       <ral_ticket_prod rsrv_id="4965710200" prod_id="4965710200202" origin="Домодедово, Москва" destination="Павелецкий вокзал" departure_datetime="2018-03-22 10:00:00" cartype="standart" fare="420"/>
114     </product>
115     <product>
116       <ral_ticket_prod rsrv_id="4965710200" prod_id="4965710200203" origin="Павелецкий вокзал" destination="Домодедово, Москва" departure_datetime="2018-03-24 07:20:00" cartype="standart" fare="420"/>
117     </product>
118     <product>
119       <ral_ticket_prod rsrv_id="4965710200" prod_id="4965710200204" origin="Павелецкий вокзал" destination="Домодедово, Москва" departure_datetime="2018-03-24 07:20:00" cartype="standart" fare="420"/>
120     </product>
121     <product>
122       <ral_ticket_prod rsrv_id="4965710200" prod_id="4965710200205" origin="Павелецкий вокзал" destination="Домодедово, Москва" departure_datetime="2018-03-24 07:20:00" cartype="standart" fare="420"/>
123     </product>
124     <product>
125       <payment_prod price="150"/>
126     </product>
127   </products>
128   <reservations>
129     <reservation rsrv_id="496571" crs="SIRENA2000" rloc="1P2BK4" ticketing_pcc=""/>
130     <reservation rsrv_id="4965710200" crs="AeroExpress" rloc="A01XFSZH"/>
131   </reservations>
132   <passengers>
133     <passenger doc_number="1206547892" psgr_id="0" doc_country="RU" psgr_type="A" doc_type="C" birth_date="1974-07-01" name="ALEKSEI" gender="M" first_name="SMIRNOV"/>
134     <passenger doc_number="7896541230" psgr_id="1" doc_country="RU" psgr_type="A" doc_type="C" birth_date="1984-02-02" name="ROMAN" gender="M" first_name="IVANOV"/>
135     <passenger doc_number="IVШЯ224111" psgr_id="2" doc_country="RU" psgr_type="C" doc_type="B" birth_date="2010-07-10" name="ANTON" gender="M" first_name="SMIRNOV"/>
136     <passenger doc_number="IVЕТ789456" psgr_id="3" doc_country="RU" psgr_type="I" doc_type="B" birth_date="2017-02-01" name="ANTON" gender="M" first_name="ROMANOV"/>
137   </passengers>
138   <travel_docs>
139     <travel_doc>
140       <air_ticket_doc tkt_oper="TKT" tkt_number="8236100037848" tkt_date="2018-01-24 16:23:26" prod_id="0" psgr_id="0" issuingAgent="2615" rsrv_id="496571"/>
141     </travel_doc>
142     <travel_doc>
143       <air_ticket_doc tkt_oper="TKT" tkt_number="2626100037849" tkt_date="2018-01-24 16:23:26" prod_id="1" psgr_id="0" issuingAgent="2615" rsrv_id="496571"/>
144     </travel_doc>
145     <travel_doc>
146       <emd_ticket_doc tkt_oper="TKT" tkt_number="99C6160149267" tkt_date="2018-01-24 16:23:26" prod_id="2" psgr_id="0" issuingAgent="2615" rsrv_id="496571" main_prod_id="1" rfic="D"/>
147     </travel_doc>
148     <travel_doc>
149       <air_ticket_doc tkt_oper="TKT" tkt_number="8236100037850" tkt_date="2018-01-24 16:23:26" prod_id="3" psgr_id="1" issuingAgent="2615" rsrv_id="496571"/>
150     </travel_doc>
151     <travel_doc>
152       <air_ticket_doc tkt_oper="TKT" tkt_number="2626100037851" tkt_date="2018-01-24 16:23:26" prod_id="4" psgr_id="1" issuingAgent="2615" rsrv_id="496571"/>
153     </travel_doc>
154     <travel_doc>
155       <emd_ticket_doc tkt_oper="TKT" tkt_number="99C6160149268" tkt_date="2018-01-24 16:23:26" prod_id="5" psgr_id="1" issuingAgent="2615" rsrv_id="496571" main_prod_id="4" rfic="D"/>
156     </travel_doc>
157     <travel_doc>
158       <air_ticket_doc tkt_oper="TKT" tkt_number="8236100037852" tkt_date="2018-01-24 16:23:26" prod_id="6" psgr_id="2" issuingAgent="2615" rsrv_id="496571"/>
159     </travel_doc>
160     <travel_doc>
161       <air_ticket_doc tkt_oper="TKT" tkt_number="2626100037853" tkt_date="2018-01-24 16:23:26" prod_id="7" psgr_id="2" issuingAgent="2615" rsrv_id="496571"/>
162     </travel_doc>
163     <travel_doc>
164       <emd_ticket_doc tkt_oper="TKT" tkt_number="99C6160149269" tkt_date="2018-01-24 16:23:26" prod_id="8" psgr_id="2" issuingAgent="2615" rsrv_id="496571" main_prod_id="7" rfic="D"/>
165     </travel_doc>
166     <travel_doc>
167       <air_ticket_doc tkt_oper="TKT" tkt_number="8236100037854" tkt_date="2018-01-24 16:23:26" prod_id="9" psgr_id="3" issuingAgent="2615" rsrv_id="496571"/>
168     </travel_doc>
169     <travel_doc>
170       <air_ticket_doc tkt_oper="TKT" tkt_number="2626100037855" tkt_date="2018-01-24 16:23:26" prod_id="10" psgr_id="3" issuingAgent="2615" rsrv_id="496571"/>
171     </travel_doc>
172     <travel_doc>
173       <aex_doc rsrv_id="4965710200" prod_id="4965710200200" psgr_id="0" tkt_oper="TKT" tkt_date="2018-01-24 16:23:44" tkt_number="427309"/>
174     </travel_doc>
175     <travel_doc>
176       <emd_ticket_doc tkt_oper="TKT" tkt_number="23K6160148822" tkt_date="16:23 24.01.2018" prod_id="4965710200200" psgr_id="0" issuingAgent="2615" rsrv_id="4965710200"/>
177     </travel_doc>
178     <travel_doc>
179       <aex_doc rsrv_id="4965710200" prod_id="4965710200201" psgr_id="1" tkt_oper="TKT" tkt_date="2018-01-24 16:23:44" tkt_number="427310"/>
180     </travel_doc>
181     <travel_doc>
182       <emd_ticket_doc tkt_oper="TKT" tkt_number="23K6160148823" tkt_date="16:23 24.01.2018" prod_id="4965710200201" psgr_id="1" issuingAgent="2615" rsrv_id="4965710200"/>
183     </travel_doc>
184     <travel_doc>
185       <aex_doc rsrv_id="4965710200" prod_id="4965710200202" psgr_id="2" tkt_oper="TKT" tkt_date="2018-01-24 16:23:44" tkt_number="427311"/>
186     </travel_doc>
187     <travel_doc>
188       <emd_ticket_doc tkt_oper="TKT" tkt_number="23K6160148824" tkt_date="16:23 24.01.2018" prod_id="4965710200202" psgr_id="2" issuingAgent="2615" rsrv_id="4965710200"/>
189     </travel_doc>
190     <travel_doc>
191       <aex_doc rsrv_id="4965710200" prod_id="4965710200203" psgr_id="0" tkt_oper="TKT" tkt_date="2018-01-24 16:23:44" tkt_number="427312"/>
192     </travel_doc>
193     <travel_doc>
194       <emd_ticket_doc tkt_oper="TKT" tkt_number="23K6160148826" tkt_date="16:23 24.01.2018" prod_id="4965710200203" psgr_id="0" issuingAgent="2615" rsrv_id="4965710200"/>
195     </travel_doc>
196     <travel_doc>
197       <aex_doc rsrv_id="4965710200" prod_id="4965710200204" psgr_id="1" tkt_oper="TKT" tkt_date="2018-01-24 16:23:44" tkt_number="427313"/>
198     </travel_doc>
199     <travel_doc>
200       <emd_ticket_doc tkt_oper="TKT" tkt_number="23K6160148825" tkt_date="16:23 24.01.2018" prod_id="4965710200204" psgr_id="1" issuingAgent="2615" rsrv_id="4965710200"/>
201     </travel_doc>
202     <travel_doc>
203       <aex_doc rsrv_id="4965710200" prod_id="4965710200205" psgr_id="2" tkt_oper="TKT" tkt_date="2018-01-24 16:23:44" tkt_number="427314"/>
204     </travel_doc>
205     <travel_doc>
206       <emd_ticket_doc tkt_oper="TKT" tkt_number="23K6160148827" tkt_date="16:23 24.01.2018" prod_id="4965710200205" psgr_id="2" issuingAgent="2615" rsrv_id="4965710200"/>
207     </travel_doc>
208   </travel_docs>
209   <payments>
210     <payment pay_id="117911895" pay_oper="PAY" pay_time="2018-01-24 16:22:41" site="2440" psp_code="011" psp_name="Testpay" psp_pay_id="" amount="38174" fop="CA"/>
211   </payments>
212 </order_snapshot>


Attention! If the Service Package selected by the client has a zero value - it will not be displayed in the export..

  • bonus_card - the number of the bonus card entered by the buyer of the ticket in numerical format.
  • service_fee — agency charge (only service charge, does not include acquiring charge), is displayed on the first ticket only (separately for each passenger).
  • comission - airline comission
  • stamp - Validator code in PCC taken from Websky settings, if it is not specified in the settings, it is not transmitted..
  • ord_id — order identifier in Websky
  • corp_ord_id — PNR from GDS
  • site — agency identifier in Websky
  • payment pay_id — billing number from Websky
  • pay_system — payment system code
    • SB — for Sberbank
    • ES — for Rapida
    • UNT — for Uniteller
  • psp_name — shows the division of the payment gateway fee amount and ticket price
    • Uniteller — Uniteller payment (bank)
    • Uniteller_GDS — payment via GDS processing (Uniteller)
  • cardholder — card holder.
  • expire_date — card expiration date of the card, it is empty for payment gateways that are not received in the response.
  • card_number — card number, in the 415481XXXXXX1734 format
  • approval_code — approval code.
  • payment_prod price — the acquiring fee.
  • main_ticket_prod_id - ticket ID in export, formed as an offset for air tickets (200) + passenger ID;
  • prod_id - id of the service package in export, is formed as offset (400) + number in order;
  • tkt_number - passenger policy number;
  • tkt_date - operation date and time;
  • tkt_oper - operation type (TKT - ticketing/CANX - ticketing cancellation).
  • provider_type - supplier type (INSURANCE).
  • provider_id - AlphaInsurance;
  • offer_type - policy name;
  • price - passenger policy price;
  • rsrv_id - order identifier;
  • rloc - supplier order number;
  • currency - primary currency of the site (currency of settlement, currency of payment);
  • crs_currency - currency of supplier settlements (with GDS);
  • crs_currency_rate - supplier's currency rate;
  • no_conj_tickets – number of additional tickets (displayed when the number of segments exceeds 4 inclusive);
  • surface_seg - transfer of the ground section (if the arrival airport of one segment is not the same as the departure airport of the next one);
  • supplier - PCC number (drawn if specified in the connection details);
  • time_gmt - GMT time;
  • time - date and time of sending information to SOFI (MSC);
  • corp_code - corporate client code;
  • email - client's e-mail address;
  • phone - client's phone number;
  • psg_type - passenger category as a letter: A - adult, C - child, I - infant;
  • title - brief description of the route;
  • form_owner - owner of IATA form;
  • validating_carrier - validating carrier;
  • prod_id - product identifier;
  • taxes - taxes;
  • fare - fare price;
  • origin/destination - point of departure/destination;
  • segment_id - segment identifier in air_ticket_prod corresponding to the service;
  • carrier - marketing carrier;
  • flight_number - flight number;
  • op_carrier - operating carrier;
  • departure_date time - date, time of departure;
  • arrival_datetime - date, time of arrival;
  • departure_airport - airport of departure;
  • arrival_airport - airport of arrival;
  • fare_basis - fare code;
  • amount - tax price;
  • code - tax code;
  • departure_datetime - date, time of departure;
  • cartype - car type;
  • crs - code of the booking system (supplier);
  • doc_number - document number;
  • psgr_id - passenger number;
  • doc_country - nationality;
  • psgr_type - passenger category;
  • doc_type - type of the identity document;
  • doc_date - date of birth of the passenger;
  • name - passenger's name;
  • gender - gender of the passenger;
  • first_name - passenger's surname;
  • issuingAgent - ID of the user who issued the ticket;
  • pay_time - date, time of payment
  • psp_code - code of the payment system through which the payment is made;
  • psp_pay_id - payment identifier in the payment system;
  • amount - amount of the payment;
  • fop - form of payment.

Order export for "Hotels" component

For the «Hotels» component, order export is available in Websky and/or JSON formats.

Order export for "Rail" component

For «Rai» component, order export is available in Websky and/or JSON formats.

Websky format

  1 <?xml version="1.0" encoding="UTF-8"?>
  2 <PNR>
  3    <Common>
  4       <id>123456</id>
  5       <Type>TRAINS</Type>
  6       <Service>UFS</Service>
  7       <Locator>64345987</Locator>
  8       <BeginDateTime>2014.04.26-00:15</BeginDateTime>
  9       <EndDateTime>2014.04.26-13:33</EndDateTime>
 10       <TicketingDateTime>2014.06.06-15:10</TicketingDateTime>
 11       <VoidDateTime>2014.06.07-14:19</VoidDateTime>
 12       <TotalPrice>
 13          <Amount>57505.8</Amount>
 14          <CurrencyCode>RUB</CurrencyCode>
 15       </TotalPrice>
 16       <UserId>123</UserId>
 17       <EEUserId />
 18       <UserLogin>mikhalevtur</UserLogin>
 19       <GroupId>122</GroupId>
 20       <UserStatus>Менеджер</UserStatus>
 21       <DateCreate>2014.04.24-15:03</DateCreate>
 22    </Common>
 23    <Payment>
 24       <Title>Testpay</Title>
 25       <Method>Testpay</Method>
 26       <BillingId>117603370</BillingId>
 27       <Date>2014-04-24 15:10:12</Date>
 28       <CreateDate>2014-06-06 15:10:00</CreateDate>
 29       <Status>cancelled</Status>
 30       <PenaltyDate />
 31       <Timelimit>2014-04-24 15:18:01</Timelimit>
 32       <Charge>
 33          <Amount>52278</Amount>
 34          <CurrencyCode>RUB</CurrencyCode>
 35       </Charge>
 36       <Book>
 37          <Amount>5227.8</Amount>
 38          <CurrencyCode>RUB</CurrencyCode>
 39       </Book>
 40       <Penalty>
 41          <Amount>0</Amount>
 42          <CurrencyCode>RUB</CurrencyCode>
 43       </Penalty>
 44       <TotalAgencyChargeForRefund>
 45          <Amount>100</Amount>
 46          <CurrencyCode>RUB</CurrencyCode>
 47       </TotalAgencyChargeForRefund>
 48       <Total>
 49          <Amount>57505.8</Amount>
 50          <CurrencyCode>RUB</CurrencyCode>
 51       </Total>
 52       <PaidValue>
 53          <Amount>0</Amount>
 54          <CurrencyCode>RUB</CurrencyCode>
 55       </PaidValue>
 56    </Payment>
 57    <Client>
 58       <LastName>Сидоров</LastName>
 59       <Name>Владимир</Name>
 60       <MiddleName>Константинович</MiddleName>
 61       <Number>1806326598</Number>
 62       <Birth>1987-05-20</Birth>
 63       <Email>mail@host.com</Email>
 64       <Phone>+79871234567</Phone>
 65    </Client>
 66    <Passengers>
 67       <Passenger>
 68          <name>Владимир</name>
 69          <middlename>Константинович</middlename>
 70          <phone>
 71             <country />
 72             <city />
 73             <number>+79271031610</number>
 74             <expansion />
 75          </phone>
 76          <email>mlsdsar@gmail.com</email>
 77          <nationality>RU</nationality>
 78          <passenger_type>ADT</passenger_type>
 79          <lastname>Сидоров</lastname>
 80          <doc_type>C</doc_type>
 81          <passport_number>1806326598</passport_number>
 82          <passenger_id>1</passenger_id>
 83          <gender>M</gender>
 84          <date_of_birth>20.04.1984</date_of_birth>
 85          <TotalPrice>28752.9</TotalPrice>
 86          <FarePrice>2613.9</FarePrice>
 87          <Charge>26139</Charge>
 88          <RefundMoney>8649.3</RefundMoney>
 89          <ChargeForRefund>100</ChargeForRefund>
 90          <TicketNumber>74944708487545</TicketNumber>
 91          <SeatNumber>033</SeatNumber>
 92          <HasSeat>true</HasSeat>
 93       </Passenger>
 94       <Passenger>
 95          <nationality>RU</nationality>
 96          <middlename>Константинович</middlename>
 97          <passenger_type>ADT</passenger_type>
 98          <lastname>Сидоров</lastname>
 99          <name>Иван</name>
100          <doc_type>C</doc_type>
101          <passport_number>1806326554</passport_number>
102          <passenger_id>2</passenger_id>
103          <gender>M</gender>
104          <date_of_birth>05.04.1984</date_of_birth>
105          <TotalPrice>28752.9</TotalPrice>
106          <FarePrice>2613.9</FarePrice>
107          <Charge>26139</Charge>
108          <TicketNumber />
109          <SeatNumber>034</SeatNumber>
110          <HasSeat>true</HasSeat>
111       </Passenger>
112    </Passengers>
113    <Info>
114       <trainNumber>098ХА</trainNumber>
115       <trainName />
116       <departureStation>МОСКВА КАЗ</departureStation>
117       <arrivalStation>КАЗАНЬ ПАС</arrivalStation>
118       <trainCategory>1</trainCategory>
119       <beginStation>Москва</beginStation>
120       <endStation>Казань</endStation>
121       <startDate>2014-04-26 00:15:00</startDate>
122       <endDate>2014-04-26 13:33:00</endDate>
123       <timeInRoad>47880</timeInRoad>
124       <carNumber>8</carNumber>
125       <carType>4</carType>
126       <choosenSeats>
127          <type>
128             <lower>1</lower>
129          </type>
130          <type>
131             <upper>1</upper>
132          </type>
133          <type>
134             <lower_side>0</lower_side>
135          </type>
136          <type>
137             <upper_side>0</upper_side>
138          </type>
139          <type>
140             <undefined>0</undefined>
141          </type>
142       </choosenSeats>
143       <choosenRange>
144          <start>0</start>
145          <end>0</end>
146       </choosenRange>
147       <serviceClass>В стоимость входит - постельное белье. Наличие установки кондиционирования воздуха не гарантировано.</serviceClass>
148    </Info>
149 </PNR>

PNR element 'PNR element' — Passenger Name Record — a record consisting of a group of individual elements (fields) containing information about one or more passengers travelling together and travel details.

Element Description Acceptable values
Common General information by the order. Elements: id, Type, Service, Locator, BeginDateTime, EndDateTime, TicketingDateTime, TotalPrice, UserId, EEUserId, UserLogin, GroupId, UserStatus, DateCreate.
Payment Information about prices, penalties, order status. Elements: Status, PenaltyDate, Timelimit, Charge, Book, Penalty, Total, PaidValue.
Client Customer information. Elements: Name, MiddleName, Number, Birth, Email, Phone.
Passengers Passenger records. Passenger elements.
Info Standard order information in the context of the service. Elements: trainNumber, trainName, departureStation, arrivalStation, trainCategory, beginStation, endStation, startDate, endDate, timeInRoad, carNumber, carType, choosenSeats, choosenRange, serviceClass.

“Common” element

Element Description Acceptable values
id Order number in Websky. A number. Example: 268281.
Type Service type. String: Example: FLIGHTS.
Acceptable values:
  • FLIGHTS — авиа,
  • HOTELS — hotels,
  • TRAINS — rail.
Service Service Provider. String. Example: UFS.
Locator Identifier in the supplier system. Number. Example: 65525140.
BeginDateTime Date and time of departure of the first segment. Date and time. Example: 2014.03.06-00:15.
EndDateTime Date and time of arrival of the last segment. Date and time. Example: 2014.03.06-13:33.
TicketingDateTime Date and time of ticketing. Date and time. Example: 2014.10.17-17:23
VoidDateTime Date and time of ticket refund. Date and time. Example: 2014.10.17-17:23
TotalPrice Total order value. "Amount" elements - nominal value, "CurrencyCode" - currency of value.
UserId Identifier of the user who placed the order in Websky system. Number. Example: 123.
UserLogin Login of the user who placed the order in Websky system. String. Example: userLogin.
GroupId Identifier of the user who placed the order in Websky system. Number. Example: 122.
UserStatus User type in the Websky system. String. Example: Manager.
DateCreate Date and time of reservation in the supplier system. Date and time. Example: 2014.03.05-15:08

TotalPrice element

Element Description Acceptable values
Amount Nominal. Number. Example: 1884.
CurrencyCode Currency. String (ISO code 4217 alfa-3). Example: RUB.

Payment element

Element Description Acceptable values
Title Name of the payment gateway*. String. Example: Testpay.
Method Type of payment form*. String. Example: Testpay.
BillingId Transaction identifier in Websky. String. Example: 117603370.
Date Date and time of payment transaction in Websky.com String. Example: 2014-04-24 15:10:12.
CreateDate Date and time of payment transaction creation in Websky. String. Example: 2014-06-06 15:10:00.
Status Order status in in Websky. String. Example: booked.
Acceptable values:
  • pending
  • booked
  • ticket - ticketed,
  • cancelled
PenaltyDate Date and time of the penalty. Date and time. Example: 2014-03-05 15:23:40.
Timelimit Time limit for payment and order confirmation. Date and time. Example: 2014-03-05 15:23:40.
Charge Agency charge. See Common.TotalPrice element.
Book Fare. See Common.TotalPrice element.
Penalty Penalty.


" Attention!' At present the parameter is inactive and always takes zero value during the export.

See Common.TotalPrice element.
TotalAgencyChargeForRefund The agency's total refund charge. See Common.TotalPrice element.
Total Total price. See Common.TotalPrice element.
PaidValue Paid. See Common.TotalPrice element.

* — a list of possible payment gateways:
Acquiro, Chronopay, Copayco, CourierNew, Deposit, EasyPay, GatelineNew, ITransfer, Invoice, Offices, PayU, Payture, Platron, PrivatBank, Qiwi, Rapida, Receipt, Sberbank, Sirena, Sirena2, UnitellerNew, WebMoney.

Client element

Element Description Acceptable values
Name Name and surname of the customer. String. Example: Ivanov Ivan.
MiddleName Customer's middle name. String. Example: Ivanovich.
Number Document series and number. Line. Example: 1806123456.
Birth Customer's date of birth. Date. Example: 1984-06-30.
Email E-mail address of the customer. String. Example: client@host.com.
Phone Customer phone number. String. Example: +74951234567

Passenger element

Element Description Acceptable values
lastname Last name of the passenger. String. Example: Sidorov.
name Passenger name. String. Example: Vladimir.
middlename Passenger's middle name. String. Example: Konstantinovich.
doc_type Document type. String. Example: C.
Permissible values:
  • C - Russian passport
  • P - Foreign passport
  • A - Foreign document
  • S - Sailor's passport
  • M - Military ticket
  • B - Birth Certificate
passport_number Document series and number. Line. Example: 1806123456.
gender Half a passenger. Line. Example: M.
Permissible values:
  • M - male
  • F - female
date_of_birth Passenger's date of birth. Date. Example: 20.05.1987.
Nationality of the passenger. String (ISO 3166-1 Alpha-2). Example: RU.
passenger_type Passenger type. Line. Example: ADT.
Permissible values:
  • ADT - adult
  • CLD - child under 10 years*, **
  • .
  • INF - child under 5 years*, ***
  • .
passenger_id Passenger order number in the order. Number. Example: 2.
TotalPrice The total price of the ticket with charges for this passenger. Number. Example: 1934.
FarePrice Fare price. Number. Example: 1884.
Charge Agency charge. Number. Example: 50.
RefundMoney Amount to refund. The value received from the supplier is reduced by the agency's refund charge. Number. Example: 1643.
ChargeForRefund Agency refund charge. Number. Example: 100.
TicketNumber Ticket number. Number. Example: 73944708472624.
SeatNumber Seat number. number. Example: 21.
TariffType Fare name. String. Example: FULL.
HasSeat Whether a passenger occupies a separate seat. Permissible values:
  • true - with seat,
  • false - without seat.

* — Not including the upper limit. The age of the child is determined on the day of travel.

** - Lower and upper limits are determined by the type of traffic:

  • from 5 to 10 years - Domestic traffic, as well as international communication with the CIS member states, Lithuania, Latvia, Estonia and the Republic of Abkhazia.
  • from 6 to 17 years - International traffic in non-CIS countries at global prices. Russia-Finland direction.
  • from 4 to 12 years - International traffic in the Far Abroad at global prices. East-West direction.

*** - The upper limit is determined by the type of traffic:

  • up to 5 years - Domestic traffic , as well as international communication with the CIS member states, Lithuanian, Latvian, Estonian, Republic of Abkhazia.
  • up to 6 years - International traffic with non-CIS countries at global prices. Direction Russia-Finland.
  • up to 4 years - International traffic with non-CIS countries at global prices. East-West direction.


Passenger element.

Element Description Acceptable values
trainNumber Train number. String. Example: 098XA.
trainName The name of the branded train. Comes from a supplier. String. Example: Russia.
departureStation Passenger departure station. String. Example: MOSCOW KAZ.
arrivalStation Passenger arrival station. String. Example: KAZAN PAS.
trainCategory Train type. Integer. Example: 1.
Permissible values:
  • 0 - unknown train type
  • 1 - fast train
  • 2 - branded train
  • 3 - high-speed train
  • 4 - branded high-speed train
beginStation Start station on the train route. String. Example: Kazan
endStation End station on the train route. String. Example: Moscow
startDate Date and time of departure from the passenger departure station. Date and time. Example: 2014-03-06 00:15:00.
endDate Date and time of arrival from the passenger departure station. Date and time. Example: 2014-03-06 13:33:00.
timeInRoad Travel time from the departure station to the passenger arrival station. Integer (seconds). Example: 47880.
carNumber Wagon number. Integer . Example: 7.
carType Wagon type. Integer . Example: 1.
Permissible values:
  • 1 - shared car
  • 2 - seat car
  • 3 - springboard
  • 4 - coupe
  • 5 - luxury
  • 6 - soft
  • 7 - unknown type
choosenSeats The element describes the number of lower, lower side, upper, upper side seats. Type elements.
choosenRange Selected range of seats in the car. Start, end elements.
serviceClass Description of services. Comes from a supplier. Text. Example: The price includes - bed linen. Availability of air-conditioning installation is not guaranteed.


Type element.

Element Description Acceptable values
lower Number of bottom seats. Integer. Example: 1.
upper Number of top seats. Integer. Example: 0.
lower_side Number of lower side seats. Integer. Example: 1.
upper_side Number of topside seats. Integer. Example: 1.
undefined Number of seats of uncertain type. Integer. Example: 0.

choosenRange element.

Element Description Acceptable values
start Start of the selected range of seats in the car*. Integer. Example: 4.
end End of selected range of seats in the car*. Integer. Example: 17.

* - If the range was not defined by the user at the seat selection stage, the start and end fields will contain zeros.

Package order export in Websky format

Order export service allows you to export the necessary samples by orders in XML, XLS(X) format. For example, you can select orders by date of booking and get information on them in the desired format. Export in XLS(X) format will upload a maximum of 1000 orders at a time. If more orders need to be exported (to get complete statistics on all orders), you need to export orders for successive periods.

When you export order data in XLS(X) format, price parameters will be converted into agency currency at the rates recorded at the time of payment for a particular order.

The export panel is always available for managers and experts.

Exporting orders under an authorized user (in a personal account)

Filters for package export orders in personal account

.

The "Show Export Panel" pseudo link opens a form that allows you to export your orders to an XML, XLS or XLSX file format.

The orders of the selected user/company and their subagents/users are uploaded based on the applied filter parameters.

The order data export request will be displayed in the log system with an XML file containing the upload data.

To export postponed orders in XLS(X) format, the "Booking status" parameter must be set to "Postponed" in order filters.

At the moment the limit for the number of single orders uploaded is set to 1000. In case it is necessary to upload more orders (to get complete statistics on all orders), it is possible to do it by uploading orders for certain periods.

Package Export parameters

Parameter XLS - export XML - export
Ticket number n/a Passengers->Passenger->Tickets->Ticket->Num
Route service_summary OrderInfo
Ticketing date ticketing_date Common->TicketingDateTime
Departure date date_begin OrderInfo->Info->StartDate,StartTime
Fare in the currency of the site (for each ticket) only total for all passengers n/a
Taxes in the currency of the site (for each ticket) только total for all passengers n/a
Fare in the currency of ticketing (for each ticket) n/a n/a
passenger second name (for each ticket) n/a Passengers->Passenger->lastname

Order re-export

If the order export was not successful, the system provides the possibility to export it again. To do this, the manager of the agency needs to go to the page of the problem order in the "Service Information" section, where the link "Re-export order", after clicking on which the order will be re-exported.

Moreover, if the setting of export both Websky and Sophie in the System Settings → Integration → Export of bookings section is enabled, the order will be re-exported in both Websky and SOFI formats.

It is also possible to re-export orders from your Personal Account. To do this, in the "Orders" section, you need to click on the link "Re-export order" for the desired order in the column "Actions".


See also