Inputs & Definitions

1 1NB: this version replaces all earlier versionsAmsterdam, April 6, 2018 Inputs & Definitions2 Inputs participating airlines Data are delivered to WorldACD 1x per month Individual air way bill (AWB) data Airlines deliver the following monthly data for ALL AWB s sold by or on behalf of the airline (own prefix): origin / final destination on AWB routing of AWB actual / chargeable weight type of product net turnover (as defined) + surcharges + other charges due carrier agent name and number resp. shipper name in case of direct sale, resp. GSA-name if no agent (forwarder) name and number known applicable currency InputsMethod & frequency of data delivery3 Delivery method: upload on secure website, FTP, e-mail or other airline preference File type: preferably Tab delimited (*.txt) Data for month X should contain all AWBs with a FLOWN DATE in month X Delivery of data for month X: before the 21st day of month (X+1) For monthly updating purposes, it is advised to always send data for month X AND for months (X-1) and (X-2) (different arrangements possible depending on individual airline's updating policies)InputsCurrency information4 All net turnover to be reported in one currency selected by the airline Official currency abbreviation(3 letters) to be usedNB-1: in the monthlyoutput, turnover andyieldcanbeviewedin manydifferent currenciesNB-2: foreverysingle monthshown, WorldACD establishesthe turnover/yieldin eachof the currenciesshownin the database.

2 The necessaryconversionfromthe variousreportingcurrencies(as usedbythe participants) tothecurrenciesshown, is donebyapplyingthe averageRates-of-Exchange, asprovidedbythe European Central Bank, foreachmonthInputsDefinitions (1)5 Definitions Actual Weight:total gross weight reported on the AWB Chargeable Weight:total volume weight reported on the AWB, or the minimum weight, whichever is higher Net Turnover: see Definitions (2) Charges: see Definitions (2) Mailto be excludedfrom reported figures Charters-on-AWB to be includedin reported figures Only AWB'sto be reported sold by the reporting airline(this means participants report turnover from own AWB's only, includingthe part of the turnover which may have to be paid to other airline(s) / carriers, carrying the goods for part of the way between the Origin and Final Destination as shown on the AWB, under an interline agreement )6 Definitions (2)Definitions4 Turnover Elements to be reported to WorldACDGROSSMINUSMINUSMINUSNET 1 MINUS=MINUST urnoverMINUSINCLUDINGNET 2 MINUS surcharges=MINUSand otherTurnoverMINUSNET 3chargesEXCLUDINGdue carriersurchargesand otherchargesdue carrierTURNOVERRateNETAll OtherNETI nterlineOther Other NET NETacc.

3 To TACTR eductionsTURNOVERC hargesTURNOVERP aymentPaymentsIncentivesTURNOVER includingagreedCommis-incl. ChargesFuel SecurityDue Carrier(Freightto Other(s)to Other(s)( on-line all chargeswith Chargessiondue carrierSurchargeSurchargeAWB Box 23 Charges)for Part of( Trucking Volumeportion of (Total AWB)Agt/Shprdue Agent(Forwarder)(Total AWB)AppliedAppliedAWB Box 28(Total AWB)TransportCost) Discounts)AWBP lease note: the GSA commission must NOTbe subtracted from the turnover amount. For example, take a specific AWB for which the forwarder is charged USD 800 freight charges plus USD 200 surcharges. The AWB is sold via a GSA and the GSA commission for this AWB is USD 40. For this specific AWB, the NET TURNOVER (NET 2) to be reported is USD 800 and not USD (3)7 DefinitionsTypes of Cargo to be reported:-General Cargo, Express Cargo, Special Cargo, Service Cargo : YES-Mail: NOAWB s to be reported:-All AWB s with airline s own prefix, IRRESPECTIVE of who actually carried the shipment: YESIn other words: if the shipment is partly (or totally) carried by another airline, the AWB still has to be reported in full, Origin, Final Destination, full net turnover & charges for the entire stretch, s of other airlines, EVEN if part of transport performed by reporting airline: NONB-1: interline payments should NOT be subtracted from turnover to calculate thenet turnover to be reported to WorldACDNB-2: cost items ( trucking cost) should NOT be subtracted from turnover to calculate the net turnover to be reported to WorldACDNB-3.

4 General incentives, not related to one specific AWB (such as volume incentives) should NOT be subtracted from turnover to calculate the net turnover to be reported to WorldACDNB-4: GSA commission should not be deducted from reported turnovercomponents (see note previous page) Inputs Transaction Table8 InputsField nameExampleairline_codeAAsold_date06/17/ 2010flown_date06/19/2010awb_prefix001awb _nr13144283originAMSrouting AMS AA DFW DL ATLfinal destinationATLagent_nameDHL Global Forwardingspecial_handling_code PIL COLcommodity_code 6500product_code CLDnature_of_goods Pharmaceuticalsactual_weight preferably as tab-delimited text-file with column headers8-digit AWB nragent_code 57470010010internal code, if any, for non-iata agentNote2-letter airline codemm/dd/yyyy OR dd/mm/yyyymm/dd/yyyy OR dd/mm/yyyy3-digit prefixcommission paid to GSA (with 2 decimals)3-letter origin airport or city codeall intermediate airport or city codes, as reported on the AWB, including carrier code per stretch3-letter destination airport or city codename as it appears in carrier data - name of agent11-digit IATA-code (7 digit IATA number followed by 4 digit CASS number); all SHC's mentioned on AWB.

5 If >1 all in one field with space between codes(if available)type of service (airline specific)description of nature of goodstotal gross weight reported on the AWB (with 2 decimals)total volume weight reported on the AWB, or the minimum weight, whichever is higher (with 2 decimals)as explained on slide 6: NET2 (freight charges, with 2 decimals)surcharges to be reported separately (with 2 decimals)surcharges to be reported separately (with 2 decimals)surcharges to be reported separately (with 2 decimals)delivery preferably in local currencyField nameExampleairline_codeAAsold_date06/17/ 2010flown_date06/19/2010awb_prefix001awb _nr13144283originAMSrouting AMS AA DFW DL ATLfinal destinationATLagent_nameDHL Global Forwardingspecial_handling_code PIL COLcommodity_code 6500product_code CLDnature_of_goods Pharmaceuticalsactual_weight preferably as tab-delimited text-file with column headers8-digit AWB nragent_code 57470010010internal code, if any, for non-iata agentNote2-letter airline codemm/dd/yyyy OR dd/mm/yyyymm/dd/yyyy OR dd/mm/yyyy3-digit prefixcommission paid to GSA (with 2 decimals)

6 3-letter origin airport or city codeall intermediate airport or city codes, as reported on the AWB, including carrier code per stretch3-letter destination airport or city codename as it appears in carrier data - name of agent11-digit IATA-code (7 digit IATA number followed by 4 digit CASS number); all SHC's mentioned on AWB; if >1 all in one field with space between codes(if available)type of service (airline specific)description of nature of goodstotal gross weight reported on the AWB (with 2 decimals)total volume weight reported on the AWB, or the minimum weight, whichever is higher (with 2 decimals)as explained on slide 6: NET2 (freight charges, with 2 decimals)surcharges to be reported separately (with 2 decimals)surcharges to be reported separately (with 2 decimals)surcharges to be reported separately (with 2 decimals)delivery preferably in local currency