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)

E.g. for the Amadeus 4427M6:

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 %