Order Export
Order export is export of order data or orders for various components of the Websky system.
Содержание
- 1 Description
- 2 Settings
- 3 Order export formats
- 4 Package order export in Websky format
- 5 See also
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.
Attention!
- An order in SOFI format will be exported during synchronization only if there are changes in the order.
- An order in SOFI format will only be exported when cancelled if the order contains cancelled services.
Settings
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.
- 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.
JSON format
Order export for "Hotels" component
For the «Hotels» component, order export is available in Websky and/or JSON formats.
JSON format
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:
|
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 {Nemo.Travel. | String. Example: 2014-06-06 15:10:00. |
Status | Order status in in Websky. | String. Example: booked. Acceptable values:
|
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.
|
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. |
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:
|
passport_number | Document series and number. | Line. Example: 1806123456. |
gender | Half a passenger. | Line. Example: M. Permissible values:
|
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:
|
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:
|
* — 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:
|
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:
|
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)
.
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".