Alternate Form of Payment (AFP) via UATP Rails

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