Table of Contents
Fares
Sell price
Amadeus
Sell Fare comes in K- or KS- lines:
K-FDKK2555 ;;;;;;;;;;;;DKK4562 ;;;
Another example 227HR3:
K-IDKK1410 ;;;;;;;;;;;;DKK1706 ;;;
and 46TWZV
KS-IDKK8450 ;;;;;;;;;;;;DKK10478 ;;;
and YARZ23
KS-WDKK6570 ;;;;;;;;;;;;DKK0
Fare can come in a foreign currency as well as in domestic. In such cases the domestic equivalent should be transferred.
Example 4G6SRI
K-FUSD48.00 ;DKK280 ;;;;;;;;;;;DKK280 ;5.7946 ;;
MCO ticket (Amadeus)
YECFTP.2 – OLD format:
MCO253;012KL;0744;KLM ROYAL DUTCH AIRLINES;CPH;TO-KLM ROYAL DUTCH AIRLINES;AT-COPENHAGEN;02SEP;M;A;AIR TRANSPORTATION;* *-;VACT8DK IN90 BLL KL X/AMS KL X/MMEM KL MIA14.18/-LAX KL X/AMS KL BLL15.55NUC 29.73END ROE5.305240;F;DKK 160;N;; DKK 29YC ; DKK 84US ; DKK 84US ; DKK 26XA ; DKK 37XY ; DKK 26AY ;;;;;;;;;;;;;;;;;;;;;;;;;;DKK 446;;;;;;;DKK 446;;;; ;P3
65CQV3.0 - NEW format:
EMD099;016QI;6473;CIMBER STERLING;25MAR;D8;1;QI;;QI;LGW;BLL;TO-;AT-;S;C;BAGGAGE;0AA;PRE-PAID BAGGAGE;;;;;1;PC;DKK 0;;F;DKK 65;N;;DKK 65;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;DKK 65; ;;I;P4;S6
WorldSpan
GDKK00005630\XZO00000135\XUB00000356\XYR00000512\DKK00006633\*
Fare in a foreign currency (76LWXH), the domestic equivalent (1860) is transferred:
GEUR00249.00\XXT00000853\XZO00000123\XPT00000043\DKK00002879\DKK00001860
Sabre
M201STU77208867516X 2 RST DKK 1735 PD 336XT PD 155ZO PD 261YR DKK 661A 0 400 F 261 ESB N O704 A CI O704 A CI 0201TK38042693000
0102
01
CASH
2353804269247CPH31MAR1017210664
2353804269247/2
NONEND/TK ONLY/NONEND/TK ONLY
Fare in a foreign currency (PMDVPW), the domestic equivalent = 195
M201ADT54108471003X 2 RST SAR 140.00 DKK 195 DKK 195 0 195 F JED N O704 A TM O704 A TM 0101SV17562209700
01
01
NONREF
NOTE:
In case the option Use unticketed pricing is ON (checked) in TairReader Manager then ticket fares are >transferred from M5 line (CTVXBY.0)
M50101 SK#2766528185/ 0/ 540/ 519/ONE/CA 1.1LIAQAT RUBIA MRS/1/F/E
M50202 SK#2766528186/ 0/ 540/ 519/ONE/CA 2.1NAEEM SALMA MRS/1/F/E
M50303 SK#2766528187/ 0/ 405/ 519/ONE/CA 3.1MEHRIA SEKANDARI MISS CHD/1/F/E
M50404 SK#2766528188/ 0/ 405/ 519/ONE/CA 4.1NAEEM M TAYYAB MSTR CHD/1/F/E
M50505 SK#2766528189/ 0/ 60/ 0/ONE/CA 5.1NAEEM M AZAAN INF/1/F/E
In TW
- Order → ‘Tickets’ tab → FareAmount
- PNREdit → ‘Tickets’ tab → ‘Finance’ groupbox: Fare Amount
- E-Ticket → For airline only → Fare ( ‘Fare’ (and ‘Total’) is shown only when ‘Show Fare prices in E-Tickets’ checkbox is checked on Invoice form)
Net price
Amadeus
Net price comes in KN– line:
KN-FDKK2480 ;;;;;;;;;;;;DKK4487 ;;;
Another example (46TWZV)
KN-IDKK8450 ;;;;;;;;;;;;DKK10478 ;;;
and (YARZ23)
KN-WDKK6570 ;;;;;;;;;;;;DKK6570 ;;;
WorldSpan
Net Price comes in U- line and is including taxes! E.g. OSQ79L:
GDKK00005230\XXT00000301\XZO00000123\XDQ00000034\DKK00005688\*
…
U\EZEI\CSK\ITCON\NN5438\*R
5438 is NetPriceAmount+Taxes. Since Taxes = 458,00 (according to G-line) then Net Price is transferred as 5438,00-458,00=4980,00
Sabre
M201STU77208867516X 2 RST DKK 1735 PD 336XT PD 155ZO PD 261YR DKK 661A 0 400 F 261 ESB N O704 A CI O704 A CI 0201TK38042693000
0102
01
CASH
2353804269247CPH31MAR1017210664
2353804269247/2
NONEND/TK ONLY/NONEND/TK ONLY
In TW
- Order → ‘Tickets’ tab → NetPriceAmount
- PNREdit → ‘Tickets’ tab → ‘Finance’ groupbox Net Price
Taxes
Amadeus
Unpaid taxes:
KFTF; DKK1564 YQ AC; DKK135 ZO AE; DKK30 YC AE; DKK87 US AP; DKK87 US AS; DKK27 XA CO; DKK38 XY CR; DKK14 AY SE; DKK25 XF ;;;;;;;;;;;;;;;;;;;;;
Another example (227HR3):
KFTI; DKK155 ZO ; DKK111 YP ; DKK30 PT ;;;;;;;;;;;;;;;;;;;;;;;;;;;
and (46TWZV)
KSTI; DKK1730 YQ AC; DKK58 YQ AD; DKK123 ZO AE; DKK117 TS LA;;;;;;;;;;;;;;;;;;;;;;;;;;
Paid taxes (YARZ23):
KSTW;ODKK1936 YQ AC;ODKK155 ZO AE;ODKK98 JD AE;ODKK28 QV DP;ODKK161 XR AE;ODKK56 QO DP;ODKK141 XD AP;ODKK116 UK TO;;;;;;;;;;;;;;;;;;;;;;
MCO ticket
YECFTP.2 – OLD format:
MCO253;012KL;0744;KLM ROYAL DUTCH AIRLINES;CPH;TO-KLM ROYAL DUTCH AIRLINES;AT-COPENHAGEN;02SEP;M;A;AIR TRANSPORTATION;* *-;VACT8DK IN90 BLL KL X/AMS KL X/MMEM KL MIA14.18/-LAX KL X/AMS KL BLL15.55NUC 29.73END ROE5.305240;F;DKK 160;N;; DKK 29YC ; DKK 84US ; DKK 84US ; DKK 26XA ; DKK 37XY ; DKK 26AY ;;;;;;;;;;;;;;;;;;;;;;;;;;DKK 446;;;;;;;DKK 446;;;; ;P3
WorldSpan
Unpaid taxes:
GDKK00005630\XZO00000135\XUB00000356\XYR00000512\DKK00006633\*
Paid taxes:
2LIIY5.1:
X\E\RFC-DKK\RF-1095\PC-DKK\T1-AT068PD\T2-ZO158PD\T3-AE112PD\TFC- \TF-NOADC
Sabre
Paid taxes:
M201STU77208867516X 2 RST DKK 1735 PD 336XT PD 155ZO PD 261YR DKK 661A 0 400 F 261 ESB N O704 A CI O704 A CI 0201TK38042693000
0102
01
CASH
2353804269247CPH31MAR1017210664
2353804269247/2
NONEND/TK ONLY/NONEND/TK ONLY
NOTE:
For WorldSpan and Sabre: No more than 3 taxes can be listed in G- (WS) and M2 (Sabre) lines of >airfile. In case we get 4 and more taxes >for a ticket then only 2 taxes are listed in the lines and all the >rest are summarized as XT tax. To see which >taxes is XT collected from look at the specific lines. Examples >are below
Example WorldSpan (76RGQC):
GDKK00003150\XXT00001115\XZO00000155\XAT00000060\DKK00004480\* BADT CPH OS X/VIE OS CAI >402.68OS \X/VIE OS CPH 173.88NUC576.56\END ROE5.46339OS XT256ZY6EQ\54JK91QH708YQ
Example Sabre (OTNMGT, with XT tax):
M201ADT17025853005X 2 RST DKK 4220 123ZO 180US 146XT DKK 4669 >4220 F 449 CPH N O704 A IP O704 A IP 0201CO17562205120
0102 01 INV
…
M6ADT1 CPH CO EWR Q156.67 245.93IL5SX17W CO CPH Q156.67 245.93IL5SX17W NUC805.20END ROE5.23518 XT33YC41XY 30XA15AY 27XFEWR4.5
NOTE:
Sabre: In case the option Use unticketed pricing is ON (checked) in TairReader Manager then taxes are >transferred from M5 line (CTVXBY.0)
M50101 SK#2766528185/ 0/ 540/ 519/ONE/CA 1.1LIAQAT RUBIA MRS/1/F/E
M50202 SK#2766528186/ 0/ 540/ 519/ONE/CA 2.1NAEEM SALMA MRS/1/F/E
M50303 SK#2766528187/ 0/ 405/ 519/ONE/CA 3.1MEHRIA SEKANDARI MISS CHD/1/F/E
M50404 SK#2766528188/ 0/ 405/ 519/ONE/CA 4.1NAEEM M TAYYAB MSTR CHD/1/F/E
M50505 SK#2766528189/ 0/ 60/ 0/ONE/CA 5.1NAEEM M AZAAN INF/1/F/E
In TW
- Order → ‘Tickets’ tab → Tax amount (sum of all taxes is shown in the filled)
- PNREdit → ‘Tickets’ tab → Taxes groupbox (each tax is displayed separately there, Paid checkbox shows if the tax is paid or not)
- E-Ticket → For airline only → Tax/Fee/Charge
Commission
(In all below examples commission percent = 14)
Amadeus
4VZJEW
FM*M* 14;S3-5,8-10;P1-2
WorldSpan
M3VE65
8\ADT\CP-14
Sabre
CDBWIV
M201ADT39326064505X RST NOK 6015 113ZN 134FR 483XT NOK 6745 14 842 6015 F 730 OSL N M2IA A AF M2IA A AF 0601JJ69229634631
In TW
- Invoice form→ Comm %