Alternate Form of Payment (AFP) via UATP Rails 8 July 2014 Alternate Form of Payment (AFP) via UATP Rails 8 July 2014 UATP - AFP Integration Agenda • • • • Introduction Merchant AFP integration Customer Experience UATP PSS reconciliation support UATP - AFP Partners UATP - AFP Integration Background • First AFP Processing launched in 2007 • 16 carriers currently utilizing UATP AFP Processing – AA, AB, AC, AM, BA, B6, DL, EY, FL, IB, JJ, LH, WN, UA, US, VA – 70+ national markets and currencies enabled • 4 new AFP Airline implementations in progress UATP - AFP Integration Benefits to Merchants • Simplifies integration allowing use of existing UATP connectivity and acceptance methods • UATP provides reports to assist with daily reconciliation of AFP payments • UATP processing minimizes Merchant modifications • UATP reacts so Merchants don’t have to • Transaction irregularities handled with normal UATP processes • No UATP processing cost to Merchant UATP - AFP Integration Differences • Looks like but is not a UATP transaction • Private agreement between Merchant carrier and AFP – UATP supports implementation – UATP not involved with commercial terms • Settlement outside of ACH/ICH/USS UATP - AFP Integration Merchant Integration Highlights • Connectivity to UATP Authorization and Acquiring services remain unchanged • New development work limited to API connection to AFP for initial customer authentication • AFP transactions are included with normal UATP transactions and appear on standard daily reports • AFP processes under a unique UATP IIN – Single-use UATP number generated by AFP • Reconciliation of AFP transactions may require PSS reports 8 UATP – Gift Card SVS & Wirecard GDS Authorization ATCAN Airline Air.com Consumer 9 SVS / Wirecard UATP – AFP Process Alipay, Giropay & SafetyPay GDS Authorization ATCAN Airline Air.com PSS Consumer 10 AP, GP, SP UATP – PayPal Process GDS Authorization ATCAN Airline Air.com PSS Consumer 11 PayPal UATP / PayPal – OTA Process OnlineTravel Agent.com Authorization GDS ATCAN ARC/BSP PSS Airline Consumer 12 PayPal AFP Refunds • Process just like a UATP Refund/Credit transaction. • Use the UATP card number and Original Ticket Number from the transaction being refunded. • The AFP will handle transferring money back to the Customer’s original funding source. 13 PSS Reports • • • • • • • • Summary.xls file contains the sum of each of the supporting detail files. ATCANTransactions.csv file contains all of the sales and refunds submitted to ATCAN on that day. Debits.csv file is a subset of the ATCANTransactions file containing only sales. Credits.csv is a subset of the ATCANTransactions file containing only the refunds. PendingTransaction.csv file contains Unprocessed AFP transactions. Exceptions.csv file is a subset of the Pending file containing transactions failed to process with AFP. PreviouslyPendingTransactions.csv file contains any transactions from a previous days which have now processed. ChargebacksAndReversals.csv file contains AFP transactions that are being charged back. 14 Summary Description Debits Credits Total ATCAN Transactions Chargebacks Previously Pending Total transfer to Merchant Transaction Gross AFP Fees Transaction Net Transaction Count 19364.88 51 -871.86 7 18493.02 58 14.51 -1595.19 7 16.1 16404.87 329.44 -822.4 5 16075.43 0 19745.37 380.49 -892.3 20.44 18853.07 360.05 -1609.7 -838.5 Pending Transactions -918.57 Non-settled Reversals 0 15 27 0 0 0 Summary vs Form 1 AIR TRAVEL PLAN - UATP BILLINGS IATA FORM ONE TO: PayPal #1112 FR: ABC Airlines #0999 ATCAN Orig Invoice Curr Amt. Local CR Exchange Convert. to 18,853.07 PSS – ATCAN Total Invoice Number Number 9993169910 999011613 - Code AUD Currency Rate Curr.of Clr. 470.00 1.534900 306.20 918.57 PSS – Pending Total 999020512 AUD 312.00 1.534900 203.27 999020409 AUD 1340.00 1.534900 873.02 17,934.50 Form 1 – Gross Total 999020509 AUD 592.00 CR 1.534900 385.69 .................................................................................. Totals 17934.50 11984.47 Less 1.75% Discount 204.48 Net Settlement 11479.99 16 ATCAN • Contains new transactions reported and processed on that day. • Transactions also reported separately in Debits and Credits file. Merchant Code Issuer Code Processing Date 999 112 6/10/2013 999 112 6/10/2013 999 112 6/10/2013 999 112 999 112 6/10/2013 Total Signed For 6/10/2013 Amt -10 -45 45 Invoice Invoice Date of Signed Currency Issue For Amt of Sale Date Number CINN Ticket Number 6/8/201 9991611 999061000000 3 306 0 6/7/2013 13159 1000 USD2 6/9/201 9991611 999062000000 AFP 3 306 0 6/8/2013 13160 Settlement 4500 USD2 AFP 6/8/201 9991611 999062000000 Fees Currency AFP Customer ID AFP Transaction ID 306 0 6/7/201361A88710AW898884 3 13159 4500 USD2 L9Z2CC32GYLP 6/8/201 9991611 999062000000 G Q USD2 0.38 3 306 0 6/7/2013 13159 4500 USD2 QNDE896HFQT8 AFP 9991611 999062000000 6/8/201 U Total USD2 4Q893027FC084761Y 1.01 Settlement Exchange Settlement Settlement DBCR 306 0 3 6/7/2013 3500 USD2 13159 9BW82DVJT8V3 Rate Amt Currency Settlement Amt Amt Code G USD2 89444639CP428400E -1.01 1 1000 USD2 -10 CR -10 9BW82DVJT8V3 1 4500 USD2 -45 CR -45 G USD2 00T89739NQ247013K -1.01 1 4500 USD2 45 DB 45 RHP8WLQJNU4 45 1 4500 USD2USD2 35 1 3500 NG USD2 17 45 DB 70A72832U2634104Y45 35 DB 35 -0.83 Merchant Net Total -9.62 -43.99 43.99 43.99 34.17 Pending • File contains the pending AFP transactions reported on that day. • Transactions specifically returned by AFP as an error will also appear in the Exceptions file. Merchant Code 999 Total Signed For Amt Exchange 999 Rate Issuer Code Processing Date Invoice Date Invoice Number 999 1 112 15000 6/10/2013 USD2 6/9/2013 -15013160 CR 65 1 999 1 6500 USD2 112 6/10/2013 6390 USD2 6/8/2013 1 999 1 999 1 USD2 1129690 6/10/2013 29180 USD2 112 77150 6/10/2013 USD2 DB 6/8/2013 96.913159 -291.8 CR 6/8/2013 771.513159 DB 854.38 1 999 1 42060 USD2 112 6/10/2013 85438 USD2 420.6 DB 6/9/2013 13160 854.38 DB -274.5 1 999 27450 6/10/2013 USD2 112 CR 6/9/2013-274.513160 667.6 1 999 66760 USD2 112 6/10/2013 999 112 96.9 -291.8 771.5 420.6 Signed For Amt CINN Ticket Number 999161 999062953238 1306 6 6/7/2013 112 6/10/2013 6/8/2013 13159 15000 Total AFP 999062953478 AFP AFP AFP 6/10/201 999161 Settlement Settlement Settlement Customer Tran Settlement Settlement DBCR 3 1306 6 6/9/2013 112 6/10/2013 13161 6500 Amt Currency Code 999161 Amt Amt Currency ID . ID 999062967478 -150 -63.9 Date of Issue 6/10/2013 6/9/2013 6/10/201 3 65 DB 13159 -63.9 CR 667.6 DB 13160 13161 1306 -150 USD2 6 999161 999062986297 65 USD2 1306 0 -63.9 USD2 999161 999062996334 1306 96.9 USD2 6 USD2 999161 -291.8 999219351640 1306 771.5 USD2 1 999161 999219002199 420.6 USD2 1306 0 USD2 999161854.38 999219369423 1306 -274.5 USD2 6 999161 667.6 999219963724 USD2 1306 8 999161 999219321660 1306 1 18 Currency of Sale USD2 AFP USD2 Fees Merchant Net Total 6/8/2013 Pending 6390 USD2 0 0 Pending 6/7/2013 Pending 0 USD2 0 0 9690 Pending 29180 6/7/2013 Pending 6/7/2013 Pending 77150 0 USD2 0 USD2 0 0 Pending 6/8/2013 42060 Pending 0 USD2 0 0 0 Pending 85438 6/8/2013 0 USD2 0 Pending 6/8/2013 27450 0 USD2 0 6/9/2013 USD2 66760 0 0 0 Exceptions • File contains transactions that have been rejected by the AFP. • These transactions will not be resubmitted for capture. Provider Code Merchant Code DBCR Code Processing Date Ticket Number Settlement Amount Settlement Currency File Sequence Number AFP Record Type AFP Validation Code 112 999 DB 6/10/2013 9990629534786 65 USD2 2 CPUATP BV000 112 999 DB 6/10/2013 9992193516401 771.5 USD2 2 CPUATP BV000 112 999 DB 6/10/2013 9992190021990 420.6 USD2 2 CPUATP BV000 112 999 DB 6/10/2013 AFP 6/10/2013 Result Code 9992193694236 854.38 USD2 2 AFP CPUATP AFP BV000 9992193216601 667.6 AFP Result Code Description USD2 112 Validation999 AFP Code DB Description AFP CPUATP Payment BV000 Transaction 2 Payment Type Type Date Transaction receipt successful CP001 Internal error. 6/11/2013 Transaction receipt successful CP020 Order is voided. 6/11/2013 Transaction receipt successful CP009 Transaction rejected - please contact the buyer. 6/11/2013 Transaction receipt successful CP001 Order is voided. 6/11/2013 Transaction receipt successful CP001 Transaction rejected - please contact the buyer. 6/11/2013 19 Previously Pending Includes any transaction from the previous days Pending Report that were successfully processed (typically Refunds). Merchant Code Issuer Code Processing Date Invoice Date 999 112 6/7/2013 6/7/2013 999 112 6/7/2013 6/7/2013 999 112 6/7/2013 Currency 6/7/2013 Of Sale 999 112 6/7/2013 USD2 6/7/2013 USD2 999 112 6/7/2013 AFP Customer ID 7FLQEQLVZFG6 6 UP284QAT96NK 9 JV7UNFAQP9T GZ BQ3QWUEQFH QTY EBZLL94Z7Z89 W USD2 6/7/2013 Invoice Number CINN Ticket Number 9991581 999062986113 306 2 13158 9991581 999219020017 306 1 13158 Total 9991581 999219377155 Signed For Exchange Settlement 306 6 13158 Rate Amt Amt 9991581 999219556955 -65 1 6500 306 1 13158 -169.8 9991581 1 999219049177 16980 -209.9 20990 3 306 1 13158 USD2 -275.9 AFP USD2 -117.9 Fees AFP Transaction ID 49A322980A31480 41 1.37 29T69347BU40879 1A 3.26 39113480NK32499 33 3.98 7UL49089PK94607 3M 5.17 9KH64908PV70814 4J 2.32 20 1 27590 Merchant 1 Total 11790 Net -63.63 -166.54 -205.92 -270.73 -115.58 Date of Issue 6/6/2013 6/6/2013 Settlement 6/6/2013 Currency Signed For Amt 6500 16980 Total Settlement 20990 Amt DBCR Code AFP Settlement Amt AFP Settlement Currency USD2 6/6/2013 USD2 -65 27590 -169.8 CR -65 USD2 CR -169.8 USD2 USD2 6/6/2013 -209.9 11790 CR -209.9 USD2 USD2 -275.9 CR -275.9 USD2 USD2 -117.9 CR -117.9 USD2 Chargebacks Merchant Code Issuer Code 279 112 279 112 279 112 279 112 279 112 279 Fee112 DR/CR 279 112 CR CR PayPal Reference ID Type Processing Date PayPal Reference ID Invoice ID 999292000000 2CZ96697VW8272 00 49E TXN 999236000000 607290442W98901 00 1K TXN Transaction Initiation Transaction 999236000000 7W798148JN8360 Date00 493 Completion TXNDate Jun 11 2013 Jun 11 2013 999237000000 8EY499748G1621 8:46AM 8:46AM TXN 00 71N Jun 10 2013 Jun 999236000000 9C6991068J9277110 2013 11:10AM 11:10AMTXN 00 26 Jun 10 2013 Jun 10 2013 7F0688024G0449 999292000000 8T384919Y203943 11:09AM 11:09AMTXN Chargeback Fee Fee 00 0V 6/10/2013 91T Jun 10 2013 Jun Amount Currency Merchant ID Payer ID File Date 8T384919Y20394 999292000000 8D617876QN249210 2013 9:50AM 9:50AM Account-to-Account Payment AK3VTD8LP9 QQELGPTRBDVW Jun 11 2013 TXN 00 39K 6/10/2013 30V Jun 10 2013 QDY L Jun 10 2013 12:00AM 8.75 USD 11:09AM 11:09AM Chargeback Processing Fee AK3VTD8LP9 Jun 11 2013 Jun 10 2013 Jun 10 2013 QDY 12:00AM 5.76 USD UHCE86T3FB2QJ 1:17PM 1:17PM Chargeback Processing Fee Jun 11 2013 AK3VTD8LP9 Jun 10 2013 Jun 10 2013 QDY 12:00AM 0 6LZQ43ZQN3KBU 1:17PM 1:17PM Chargeback AK3VTD8LP9 NJLNHACM6UQQ Jun 11 2013 QDY U 12:00AM 0 AK3VTD8LP9 Jun 11 2013 QDY 12:00AM 0 AK3VTD8LP9 Jun 11 2013 QDY 12:00AM 0 AK3VTD8LP9 Jun 11 2013 QDY 12:00AM 0 6LZQ43ZQN3KBU Transaction ID 3AW69026209100 6/10/2013 90G 3CK79038879709 6/10/2013 02V 9C6991068J92771 Chargeback 26 Description 6/10/2013 Payment Refund initiated by 268208078W0100 merchant 6/10/2013 94E Payment Refund initiated by 67F20199BE6004 merchant 6/10/2013 809 21 Transaction Event Code T1107 Transaction T1107 Debit or Credit T1201 Gross Transaction Amount Gross Transaction Currency DR T1106 474.8 USD DR T0106 308.8 USD DR 20.3 USD T0106 Custom Field DR 731.8 USD 052W684DSERKG5437EA7A14 T1201 4….. DR 10 USD W68ER3DS9FCF94AF58941D4 8….. DR 10 USD E292338A7964437EA7A1448B5 ….. DR 54 USD FA7B7649FCF94AF58941D483 E….. E292338A7964437EA7A1448B5 ….. A5523DFA3D39467D9F36DFFD 4….. A5523DFA3D39467D9F36DFFD 4….. What’s Next? • • • • • Enhancements to PSS Complete AFP Implementations Enhanced Authorization Weekend AFP Processing Explore new AFP partnerships based on Airline requests
© Copyright 2024 ExpyDoc