| Ticket no. | Ticket status remarks | Ticket type | Ticket date | Ticket date [month-year] | Ticket date [year] | Issue user office id | Process status | Blocking time | Blocking user id | Blocking user name | Blocking comments | Tkt. issue type | Tkt. issue date | Issue user Amadeus Login | Issue user Amadeus Office id | Issue user IATA code | Issue user id | Issue user name | Issue user office name | Reservation date | Reservation date [month-year] | Reservation date [year] | Reservation user Amadeus login | Reservation user Amadeus office id | Reservation user IATA code | Reservation user id | Reservation user name | Reservation user office id | Reservation user office name | Passenger full name | Passenger last name | Passenger first name | Passenger title | PNR | Departure airport code | Departure airport name | Departure city code | Destination airport code | Destination airport name | Destination city code | Destination airports names | International indicator | Flight segments no. | Airports segments | Flight(s) number(s) | Flight type | Ticket class code | Ticket class name | Segments class codes | Departure date | Arrival date | Airline code | Airline number | Airline name | Original form of payment | Ticket form of payment | Tour code | Remarks | Supplier price (AIR) | Commission (AIR) | Ticket price (AIR) | Service Fee (AIR) | Tax (AIR) | Supplier total (AIR) | Total tkt (AIR) | Estimated revenue (AIR) | Tkt. currency (AIR) | Supplier price [eqv.def.curr.] (AIR) | Commission [eqv.def.curr.] (AIR) | Ticket price [eqv.def.curr.] (AIR) | Service fee [eqv.def.curr.] (AIR) | Tax [eqv.def.curr.] (AIR) | Supplier total [eqv.def.curr.] (AIR) | Total tkt [eqv.def.curr.] (AIR) | Estimated revenue [eqv.def.curr.] (AIR) | Default currency (AIR) | Supplier price [eqv.work curr.] (AIR) | Commission [eqv.work curr.] (AIR) | Ticket price [eqv.work curr.] (AIR) | Service fee [eqv.work curr.] (AIR) | Tax [eqv.work curr.] (AIR) | Supplier total [eqv.work curr.] (AIR) | Total tkt [eqv.work curr.] (AIR) | Estimated revenue [eqv.work curr.] (AIR) | Working currency (AIR) | Reservation id | Converted reservation id | Reservation code | Reservation number | Reservation date | Reservation date [month-year] | Reservation date [year] | Reservation service type | Reservation owner id (psg) | Reservation owner name (psg) | Reservation owner last name (psg) | Reservation owner first name (psg) | Reservation owner id (corp) | Reservation owner name (corp) | Contact person id | Contact person name | Operational status | Financial status | Reservation description | Reservation comments | Reservation responsible user id | Reservation responsible user name | Reservation responsible office id | Reservation responsible office name | Reservation responsible department id | Reservation responsible department name | Reservation add time | Reservation add user id | Reservation add user name | Reservation add office id | Reservation add office name | Reservation add department id | Reservation add department name | Service id | Package service type | Package subservice | Service imported from | Service passenger name | Service passenger type | Service passenger id | Passenger PNC | Service passenger department | Product type | OJ type | Service source | Flight number | Flight distance | Flight duration | Flight total distance (value) | Flight total distance (unit measure) | Service description | Service comments | Service preferences | Service remarks | Service tkt date | External reservation id | External reservation date | Service operational status | Service financial status | Service balanced | Service start date | Service start date [month-year] | Service start date [year] | Service and time start date | Service end date | Service end date [month-year] | Service end date [year] | Service and time end date | Service duration | Departure country code | Departure country name | Departure country zone | Departure city id | Departure city name | Departure city district | Departure city region | Departure airport code | Departure airport name | Destination country code | Destination country name | Destination country zone | Destination city id | Destination city name | Destination city district | Destination city region | Destination airport code | Destination airport name | Service itinerary | Itinerary airports codes | Itinerary airports name | Service responsible user id | Service responsible user name | Service responsible office id | Service responsible office name | Responsible department id | Service responsible department name | Service add time | Service add date | Service add date [month-year] | Service add date [year] | Service add user id | Service add user name | Service add office id | Service add office | Service add department id | Service add department name | Offer id | Offer supplier id | Offer supplier name | Offer type | Offer location | Calculation offer | Offer currency exchange type | Offer currency exchange date | Agency commission invoice | Offer comments | Supplier net price without VAT (offer) | VAT net price (offer) | Supplier price (offer) | Commission value without VAT (offer) | VAT commission (offer) | Commission (offer) | Ticket price value without VAT (offer) | VAT ticket price (offer) | Ticket price (offer) | Discount value without VAT (offer) | VAT discount (offer) | Discount (offer) | Service fee value without VAT (offer) | VAT service fee (offer) | Service fee (offer) | Airport taxes value without VAT (offer) | VAT airport taxes (offer) | Airport taxes (offer) | Supplier total (offer) | Total price value without VAT (offer) | VAT total price (offer) | Total price (offer) | Estimated revenue (offer) | Offer currency | Supplier price [eqv. def. curr.] (offer) | Commission [eqv. def. curr.] (offer) | Ticket price [eqv. def. curr.] (offer) | Discount [eqv. def. curr.] (offer) | Service fee [eqv. def. curr.] (offer) | Airport taxes [eqv. def. curr.] (offer) | Net company [eqv. def. curr.] (offer) | Total price [eqv. def. curr.] (offer) | Estimated revenue [eqv. def. curr.] (offer) | Supplier price [eqv. work curr.] (offer) | Commission [eqv. work curr.] (offer) | Ticket price [eqv. work curr.] (offer) | Discount [eqv. work curr.] (offer) | Service fee [eqv. work curr.] (offer) | Airport taxes [eqv. work curr.] (offer) | Net company [eqv. work curr.] (offer) | Total price [eqv. work curr.] (offer) | Estimated revenue [eqv. work curr.] (offer) | Add time (offer) | Add date (offer) | Add user id (offer) | Add user name (offer) | Add office id (offer) | Add office name (offer) | Add department id (offer) | Add department name (offer) | Service fee client profile (value) | Service fee client profile (currency) | Invoice id | Invoice no. | Invoice numbers list | Invoice date | Invoice date [month-year] | Invoice date [year] | Issued invoice | Temporary invoice | Cumulative invoice | Cashed value [eqv. invoice value] | Not cashed value [eqv. invoice value] | Cashing percent | Agency name | Invoice client id | Invoice client type | Invoice client name | Invoice client id (legal entity) | Invoice client alias (legal entity) | Invoice client trust id | Invoice client trust | Invoice client key account id (legal entity) | Invoice client key account name (legal entity) | Invoice client id (legal ent.) (duplicate) | Invoice client alias (legal ent.) (duplicate) | Invoice client id (individual) | Invoice client name (individual) | Invoice client id (indv.) (duplicate) | Invoice client name (indv.) (duplicate) | Proforma no. | Proforma list | Balance invoice no. | Balance invoice list | Invoice annex no. | Invoice annexes list | Invoice currency exchange type | Invoice currency exchange date | Refer. currency exch. rate | Supplier net price without VAT (inv) | VAT supplier price (inv) | Supplier price (inv) | Commission value without VAT (inv) | VAT commission (inv) | Commission (inv) | Ticket price value without VAT (inv) | VAT ticket price (inv) | Ticket price (inv) | Discount value without VAT (inv) | VAT discount (inv) | Discount (inv) | Service fee value without VAT (inv) | VAT service fee (inv) | Service fee (inv) | Airport taxes value without VAT (inv) | VAT airport taxes (inv) | Airport taxes (inv) | Penalties value without VAT (inv) | VAT penalties (inv) | Penalties (inv) | Advance value without VAT (inv) | VAT advance (inv) | Advance (inv) | Supplier total (inv) | Invoice total | Total invoice value without VAT | VAT total invoice | Invoice estimated revenue | Invoice currency | Supplier price [eqv.def.curr.] (inv) | Commission [eqv.def.curr.] (inv) | Ticket price [eqv.def.curr.] (inv) | Discount [eqv.def.curr.] (inv) | Service fee [eqv.def.curr.] (inv) | Tax [eqv.def.curr.] (inv) | Penalty [eqv.def.curr.] (inv) | Advance [eqv.def.curr.] (inv) | Supplier total [eqv.def.curr.] (inv) | Invoice total [eqv.def.curr.] | Invoice value without VAT [eqv.def.curr.] | Invoice VAT [eqv.def.curr.] | Invoice estimated revenue [eqv.def.curr.] | Default currency | Supplier price [eqv.work curr.] (inv) | Commission [eqv.work curr.] (inv) | Ticket price [eqv.work curr.] (inv) | Discount [eqv.work curr.] (inv) | Service fee [eqv.work curr.] (inv) | Airport taxes [eqv.work curr.] (inv) | Penalty [eqv.work curr.] (inv) | Advance [eqv.work curr.] (inv) | Supplier total [eqv.work curr.] (inv) | Invoice total [eqv.work curr.] | Invoice value without VAT [eqv.work curr.] | Invoice VAT [eqv.work curr.] | Invoice estimated revenue [eqv.work curr.] | Working currency | Real revenue (inv. curr.) | Invoice currency (for the real revenue) | Real revenue (offer curr.) | Offer currency (for the real revenue) | Real revenue [work curr.] | Working currency (for the real revenue) | Real revenue [def. curr.] | Ticket balance id | Balance type (code) | Balance type | Balance number | Balance date | Balance status (code) | Balance status | Balance code | Balance name | Balance revenue | More supplier invoices in the balance | Supplier invoice number | Supplier invoice date | Balance responsible user id | Balance responsible user name | Balance responsible office id | Balance responsible office | Balance responsible department id | Balance responsible department | Balance add user id | Balance add user | Balance add office id | Balance add office | Balance add date & time | Balance add date | Confirmed balance | Balance confirmation user id | Balance confirmation user | Balance confirmation office id | Balance confirmation office | Balance confirmation date & time | Balance confirmation date | Cost center (RM) | Approval code (RM) | CS Data 1 (RM) | CS Data 5 (RM) | Project number (RM) | Valoare full fare | Valuta full fare | Cod booker (RM) | Cost center corp. (RM) | Valoare pret minim (RM) | Valuta pret minim (RM) | Valoare pret mediu (RM) | Valuta pret mediu (RM) | Valoare pret maxim (RM) | Valuta pret maxim (RM) | Include weekend | Centru de cost | Numar delegatie | E-power | Afiliat e-power | Cod corporatie RM Air | Nume corporatie RM Air | Published fare value (RM) | Published fare currency (RM) | Low fare value (RM) | Low fare currency (RM) | Cost center (RM) | Job code (RM) | Project name (RM) | X |
| 1793714803 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1793714803 | TICKET | 30-May-2016 | 05-2016 | 2016 | processed | electronic | 30-May-2016 | 0504OCSU | BUHPD212B | 27-May-2016 | 05-2016 | 2016 | 0504OCSU | BUHPD212B | BIRTA/BOGDAN MR | BIRTA | BOGDAN | MR | 646MMN | OTP | HENRI COANDA | BUH | CDG | CHARLES DE GAULLE | PAR | CDG | I | 2 | OTP/CDG/OTP | 1589/1088 | RT | N | economy | N/N | 03-Jul-2016 | 07-Jul-2016 | AF | 57 | AIR FRANCE | CASH | CASH | AN=NZ - NP - ELS // DR=RES//BUSINESS PERFORMANCE & QUALITY//20112//37160//27/05/2016 // TRC=LAUNCH OF THE PILOT PHASE OF THE RISK UNIVERSE PROJECT-4-7 JULY - WORKSHOP TO BE HELD IN PLACE D'ALLERAY,PARIS // RC:BUHPD212B-W/440 // RC:BUHPD212B-W//EDP=440 | 211,98 | 0,02 | 212,00 | 0,00 | 52,32 | 264,30 | 264,32 | 0,02 | EUR | 955,48 | 0,09 | 955,57 | 0,00 | 235,83 | 1.191,31 | 1.191,40 | 0,09 | RON | 211,98 | 0,02 | 212,00 | 0,00 | 52,32 | 264,30 | 264,32 | 0,02 | EUR | 1990000001 | WWSLTT | 000167 | 06-Jul-2016 | 07-2016 | 2016 | test | 133300 | BIRTA BOGDAN | BIRTA | BOGDAN | OK | NI | 154 | Lucian l | 35 | Sediul Unirii | 100 | Test department | 06-07-2016 15:23:12 | 154 | Lucian l | 35 | Sediul Unirii | 100 | Test department | 1990000001 | No | Amadeus | BIRTA BOGDAN | Adult | 133300 | RT | RT | Amadeus AIR | 1589 / 1088 | 1155miles / 1155miles | 03:05:00 / 02:50:00 | 2310 | miles | AN=NZ - NP - ELS // DR=RES//BUSINESS PERFORMANCE & QUALITY//20112//37160//27/05/2016 // TRC=LAUNCH OF THE PILOT PHASE OF THE RISK UNIVERSE PROJECT-4-7 JULY - WORKSHOP TO BE HELD IN PLACE D'ALLERAY,PARIS // RC:BUHPD212B-W/440 // RC:BUHPD212B-W//EDP=440 // gg=1 | 30-May-2016 | 646MMN | 2016-05-30 | OK | NI | No | 03-Jul-2016 | 07-2016 | 2016 | 03-07-2016 17:55:00 | 07-Jul-2016 | 07-2016 | 2016 | 07-07-2016 23:00:00 | 5 | FR | France | Regional | 3831 | Paris | CDG | Charles De Gaulle | BUCURESTI (03-07-2016 17:55) - Paris (03-07-2016 20:00) ; Paris (07-07-2016 19:10) - BUCURESTI (07-07-2016 23:00) | OTP//CDG//OTP | Henri Coanda//Charles De Gaulle//Henri Coanda | 154 | Lucian l | 35 | Sediul Unirii | 100 | Test department | 06-07-2016 15:23:12 | 06-Jul-2016 | 07-2016 | 2016 | 154 | Lucian l | 35 | Sediul Unirii | 100 | Test department | 1990000001 | 128 | AIR FRANCE AF AFR 57 | pe serviciu | ext EU | extern | BNR | 30-Jun-2016 | No | 211,98 | 0,00 | 211,98 | 0,02 | 0,00 | 0,02 | 212,00 | 0,00 | 212,00 | 20,00 | 0,00 | 20,00 | 30,00 | 0,00 | 30,00 | 52,32 | 0,00 | 52,32 | 264,30 | 274,32 | 0,00 | 274,32 | 10,02 | EUR | 958,36 | 0,09 | 958,45 | 90,42 | 135,63 | 236,54 | 1.194,90 | 1.240,20 | 45,30 | 211,98 | 0,02 | 212,00 | 20,00 | 30,00 | 52,32 | 264,30 | 274,32 | 10,02 | 06-07-2016 15:23:12 | 06-Jul-2016 | 154 | Lucian l | 35 | Sediul Unirii | 100 | Test department | 30,00 | EUR | No | No | No | 0,00 | 0,00 | 0,00% | Çocukluğunda | 0 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | RON | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | EUR | 0,00 | 0,00 | EUR | 0,00 | EUR | 0,00 | 0 | 0,00 | No | No | 0,00 | 0,00 | 0,00 | 0,00 | Yes | No | 0,00 | 0,00 | 16.924,44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2,00 | 955,48 | 0,09 | 955,57 | 0,00 | 235,83 | 1.191,31 | 1.191,40 | 0,09 | 211,98 | 0,02 | 212,00 | 0,00 | 52,32 | 264,30 | 264,32 | 0,02 | 958,36 | 0,09 | 958,45 | 90,42 | 135,63 | 236,54 | 1.194,90 | 1.240,20 | 45,30 | 211,98 | 0,02 | 212,00 | 20,00 | 30,00 | 52,32 | 264,30 | 274,32 | 10,02 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 9377608719 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 9377608719 | TICKET | 10-Feb-2016 | 02-2016 | 2016 | not processed | electronic | 10-Feb-2016 | LK | 5PW9 | 11-Feb-2016 | 02-2016 | 2016 | MK | 7K1 | UUSSAAR/LIA | UUSSAAR | LIA | JTHKSN | BUD | FERIHEGY | BUD | RIX/BUD/RIX | I | 4 | TLL/RIX/BUD/RIX/TLL | 312/491/492/317 | RT | V | economy | V/V/V/V | 24-Apr-2016 | 28-Apr-2016 | 657 | AIR BALTIC CORPORATION S | CC | CC | VL-220710FEBMUCRM1AZFKOFT | 42,00 | 0,00 | 42,00 | 0,00 | 148,79 | 0,00 | 190,79 | 0,00 | EUR | 188,61 | 0,00 | 188,61 | 0,00 | 668,17 | 0,00 | 856,78 | 0,00 | RON | 42,00 | 0,00 | 42,00 | 0,00 | 148,79 | 0,00 | 190,79 | 0,00 | EUR | No | 0000-00-00 | No | No | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | No | No | No | 0,00 | 0,00 | 0,00% | Çocukluğunda | 0 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | RON | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | EUR | 0,00 | 0,00 | 0,00 | EUR | 0,00 | 0 | 0,00 | No | No | 0,00 | 0,00 | 0,00 | 0,00 | Yes | No | 0,00 | 0,00 | 3.666,00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 4,00 | 188,61 | 0,00 | 188,61 | 0,00 | 668,17 | 0,00 | 856,78 | 0,00 | 42,00 | 0,00 | 42,00 | 0,00 | 148,79 | 0,00 | 190,79 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 6,00 | 1.144,09 | 0,09 | 1.144,18 | 0,00 | 904,00 | 1.191,31 | 2.048,18 | 0,09 | 253,98 | 0,02 | 254,00 | 0,00 | 201,11 | 264,30 | 455,11 | 0,02 | 958,36 | 0,09 | 958,45 | 90,42 | 135,63 | 236,54 | 1.194,90 | 1.240,20 | 45,30 | 211,98 | 0,02 | 212,00 | 20,00 | 30,00 | 52,32 | 264,30 | 274,32 | 10,02 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | 0,00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||