...

...

Use Cases

The main use case for this settlement file is to reconcile the uPay postback transactions. Other use cases includes department refund notifications.

...

...

Anchor
Appendix1 Appendix1

Appendix 1 - Hierarchy Levels

Anchor
Appendix2 Appendix2

Appendix 2 - Card Type

North Domestic

...

Ominpay Specific

...

...

...

Download link here.

...

Download link here.

...

...

...

...

...

...

...

...

...

...

...

Anchor
Appendix3 Appendix3

Appendix 3 - Currency Code

Anchor
Appendix4 Appendix4

Appendix 4 - Transaction Status

Anchor
Appendix5 Appendix5

Appendix 5 - Reject Indicator (Transaction Detail)

Anchor
Appendix6 Appendix6

Appendix 6 - Reject Code

Anchor
Appendix7 Appendix7

Appendix 7 - Entry Mode

Anchor
Appendix8 Appendix8

Appendix 8 - Terminal Capabilities

Anchor
Appendix9 Appendix9

Appendix 9 - Interchange Plan Code

Download link here.

Anchor
Appendix10 Appendix10

Appendix 10 - Non-Qual Codes

Download link here.

Anchor
Appendix11 Appendix11

Appendix 11 - Partial Authorization Inidicatory

Anchor
Appendix12 Appendix12

Appendix 12 - Transaction Type

Anchor
Appendix13 Appendix13

Appendix 13 - Transaction Mode

Anchor
Appendix14 Appendix14

Appendix 14 - Transaction Source

Anchor
Appendix15 Appendix15

Appendix 15 - Health Care Card

Anchor
Appendix16 Appendix16

Appendix 16 - AFD Completion Code

Anchor
Appendix17 Appendix17

Appendix 17 - AVS Flag

Anchor
Appendix18 Appendix18

Appendix 18 - Authorization Response Code

Download link here.

Anchor
Appendix19 Appendix19

Appendix 19 - CVC2/CVV2 Result

...

Download link here.

Appendix Download

North DFM Appendix

...

...

Record Type varchar2 3 Constant “005” The 005 record will provide transaction detail for the pin debit card type.  There will be a 005 record for each of the transactions included in the prior day's funding. Hierarchy ID varchar2 20 Hierarchy Merchant Number in which the file is created.   Hierarchy Level No. varchar2 5 ClientLine Hierarchy Level that the file is being created for. Appendix 1 Location ID varchar2 20 Outlet level MID   Location DBA Name varchar2 80 Doing Business Address Name assigned to the Outlet MID   Store Number varchar2 10 Discretionary number setup on the Merchant Master   External ID varchar2 25 Discretionary Number assigned to Outlet Level MID  Client Correspondence Flag must be set to a Y Funded Date/Load Date varchar2 8 Funded Date is when the settled transaction amount was sent to your bank for payment. Load Date is when the settled transaction are loaded to the database for reporting. YYYYMMDD
This field will represent Funded Date by default, unless you select to receive this record by Load Date, then this field will display that Load Date.
Load Date doe not indicate that the transactions have been funded Card Type varchar2 10 Association that the transaction is sent to for processing. Ex. Visa, MC, etc. Appendix 2 Network ID varchar2 8 Debit Network that processed the transaction Appendix 20 Card Number varchar2 25 Unique number assigned to cardholder Card masking is determined by the Masking Flag attribute in Business Track portal for the user. Terminal ID varchar2 15 Discretionary POS Identification number **Currently Clientline Database only stores 5 digits Batch Number varchar2 20 Number assigned to each group of settled transactions   Batch Date varchar2 8 Date group of transactions was settled YYYYMMDD Authorization Code varchar2 8 6 digit code assigned at the time card was authorized   Invoice/Trace ID varchar2 20 Discretionary 12 digit number sent on transaction by merchant   Reference Number varchar2 30 23 byte Number assigned to each settled transaction prior to sending to the Association aka ARN Transaction ID varchar2 20 Number assigned by the Association Visa Tran ID or MasterCard Banknet Reference Number Transaction Date varchar2 8 Date transactions was processed at POS   Transaction Amount Sign varchar2 1 +/- ('+) = Sale  (-) = Refund Transaction Amount Number 15 Amount of the processed transaction   Processed Currency Code varchar2 3 ISO 4217 3 digit code representing the  Currency the transaction was funded in Appendix 3 Submitted Currency Amount Sign varchar2 1 +/-  ('+) = Sale  (-) = Refund
Only available merchants setup as multi-currency  Submitted Currency Amount Number 15 The transaction amount in the currency the transaction was processed in at the POS Formatted as 999999999999.99
Only available merchants setup as multi-currency  Submitted Currency Code varchar2 3 ISO 4217 3 digit code representing the  Currency the transaction was processed in at the POS Appendix 3 Currency Conversion Rate Number 20 The rate applied to convert a transaction between submitted and processed currency Formatted as 9999999999.999999999 Cash Back Amount Sign varchar2 1 +/-  ('+) = Sale  (-) = Refund Cash Back Amount Number 15 Cash that is given to the customer as part of their total debit transaction amount   Transaction Status varchar2 2 Code indicating  if the transaction was processed (P) or rejected (R) Appendix 4 Reject Indicator varchar2 1 1 digit code indicating if the transaction was rejected (Y) or accepted (N) Appendix 5 Reject Reason varchar2 80 Description why a transaction was rejected Appendix 6 Entry Mode varchar2 2 How the transaction was originally performed (ex. Terminal, POS, Chip) Appendix 7 PC Terminal Capability varchar2 1 Code indicating if the card was Present or Not Present Appendix 8 Pinless Debit varchar2 1 Code indicating if the debit card was processed without a PIN   Plan Code varchar2 4 Interchange Plan Code that the transaction should qualify at Appendix 9 Billback Reason varchar2 10 The code that indicates why a transaction did not clear at the expected rate Appendix 10 Partial Auth Indicator varchar2 1 1 digit code indicating if Partial Authorization is supported Appendix 11 Transaction Type varchar2 6 Code indicating the action taken on the card (ex. Sale, Credit, Void) Appendix 12 Transaction Mode varchar2 6 The manor in which a transaction was processed (ex. Electronic, Manual, Swiped) Appendix 13 Transaction Source varchar2 2 The manor in which a transaction was processed (ex. Electronic, Manual, Swiped) Appendix 13 Authorization Amount Sign varchar2 1 +/-  ('+) = Sale  (-) = Refund Authorization Amount Number 15 Amount  verified as available on a card for a transaction to occur Formatted as 999999999.99 Authorization Date varchar2 8 Date the verification occurred on a card for a transaction YYYYMMDD Transaction Time varchar2 10 The hour, minute and second when the transaction was performed HH:MM:SS
Some FE default this value. You need to check with you account management team if this information is available on your processing platform. Expiration Date varchar2 4 2 digit month & 2 digit year when a card becomes invalid   Authorization SIC Code varchar2 4 Standard Industry Code at the time the card was authorized that corresponds
to the client’s Visa Merchant Category Code   AVS Flag varchar2 1 Code indicating the level of Address Verification  Appendix 17 Response Code varchar2 1 Same as Authorization Response Code   CVC2 Result varchar2 1 Indicator if Card Verification Code is present for Visa transaction Appendix 19 CVV2 Result varchar2 1 Indicator if Card Verification Value is present for MasterCard transaction Appendix 19 Sales Tax Amount Sign varchar2 1 +/-  ('+) = Sale  (-) = Refund Sales Tax Amount Number 15 Sales Tax Amount on a petroleum transaction   Invoice Amount Sign varchar2 1 +/-  ('+) = Sale  (-) = Refund Invoice Amount Number 15 Total Amount of all the Product Code Amounts for a Petroleum transaction Formatted as 999999999999.99 Product Code 1 varchar2 6 NACS Code for the goods purchased
Only applies to Petroleum   Product Gallons 1 Number 11 Gallons of petroleum associated with the transaction Formatted as 999999.9999 Product Amount Sign 1 varchar2 1 +/-  ('+) = Sale  (-) = Refund Product Amount 1 Number 15 Transaction Amount for Petroleum purchase Formatted as 999999999999.99 Product Code 2  varchar2 6 NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum   Product Gallons2 Number 11 Gallons of petroleum associated with the transaction Formatted as 999999.9999 Product Amount Sign 2 varchar2 1 +/-  ('+) = Sale  (-) = Refund Product Amount 2 Number 15 Transaction Amount for Petroleum purchase Formatted as 999999999999.99 Product Code 3 varchar2 6 NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum   Product Gallons 3 Number 11 Gallons of petroleum associated with the transaction Formatted as 999999.9999 Product Amount Sign 3 varchar2 1 +/-  ('+) = Sale  (-) = Refund Product Amount 3 Number 15 Transaction Amount for Petroleum purchase Formatted as 999999999999.99 Product Code 4 varchar2 6 NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum   Product Gallons 4 Number 11 Gallons of petroleum associated with the transaction Formatted as 999999.9999 Product Amount Sign 4 varchar2 1 +/-  ('+) = Sale  (-) = Refund Product Amount 4 Number 15 Transaction Amount for Petroleum purchase Formatted as 999999999999.99 Product Code 5 varchar2 6 NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum   Product Gallons 5 Number 11 Gallons of petroleum associated with the transaction Formatted as 999999.9999 Product Amount Sign 5 varchar2 1 +/-  ('+) = Sale  (-) = Refund Product Amount 5 Number 15 Transaction Amount for Petroleum purchase Formatted as 999999999999.99 Vehicle Number varchar2 17 VIN associated with Fleet Card
Only applies to Petroleum   Odometer varchar2 10 Odometer Number associated with Fleet Card
Only applies to Petroleum   Driver ID varchar2 20 Drivers License Number associated with Fleet Card
Only applies to Petroleum   Special Reference  #1  varchar2 25 Discretionary field sent by merchant PTS XN07-Merchant Order Number - Compass FE only Special Reference  #2 varchar2 25 Discretionary field sent by merchant PTS XN08- Tracking Number - Compass & Omnipay FE only Authorization Response Code varchar2 2 Code that indicates the response on an attempted transaction. (ex. Approval, decline, etc. Appendix 18 Bank Reference Number varchar2 20 *Client specific field not available for use*   Receipt Number varchar2 12     Auth Source varchar2 1 How the transaction was sent  for authorization   CAT Level varchar2 1 Indicator if it is a Card Holder Activated terminal   Cardholder ID Method varchar2 1 Indicates how the Cardholder was identified by the Merchant. This field is only required for VISA transactions   Merchant Reference Number varchar2 9 8 digit Discretionary field sent by merchant Available on all Front Ends
PTS 'D' record (this # is used as part of the 23 digit Reference Number) Total Auth Amount Sign varchar2 1 +/-  ('+) = Sale  (-) = Refund Total Auth Amount varchar2 15 Total Amount authorized for a transaction   Market Specific Indicator varchar2 1 Indicates the industry for which market-specific authorization data was included in the transaction Space No market-specific authorization data supplied
A Valid Auto Rental market-specific authorization data received
B Valid Bill Payment market-specific authorization data received
E Valid Electronic Commerce Transaction Aggregation data received
H Valid Hotel market-specific authorization data received
M Valid Healthcare market-specific authorization data received
N Invalid or not applicable market-specific authorization data received
T Valid Transit market-specific authorization data received Visa Product ID varchar2 2 the Card-Level Results value received in the authorization response For Custom Payment Service original purchase transactions and their reversals. This field is required for interchange qualifications Product Code 6 varchar2 6 NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum   Product Gallons 6 Number 11 Gallons of petroleum associated with the transaction Formatted as 999999.9999 Product Amount Sign 6 varchar2 1 +/-  ('+) = Sale  (-) = Refund Product Amount 6 Number 15 Transaction Amount for Petroleum purchase Formatted as 999999999999.99 Product Code 7 varchar2 6 NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum   Product Gallons 7 Number 11 Gallons of petroleum associated with the transaction Formatted as 999999.9999 Product Amount Sign 7 varchar2 1 +/-  ('+) = Sale  (-) = Refund Product Amount 7 Number 15 Transaction Amount for Petroleum purchase Formatted as 999999999999.99 Product Code 8 varchar2 6 NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum   Product Gallons 8 Number 11 Gallons of petroleum associated with the transaction Formatted as 999999.9999 Product Amount Sign 8 varchar2 1 +/-  ('+) = Sale  (-) = Refund Product Amount 8 Number 15 Transaction Amount for Petroleum purchase Formatted as 999999999999.99 Product Code 9 varchar2 6 NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum   Product Gallons 9 Number 11 Gallons of petroleum associated with the transaction Formatted as 999999.9999 Product Amount Sign 9 varchar2 1 +/-  ('+) = Sale  (-) = Refund Product Amount 9 Number 15 Transaction Amount for Petroleum purchase Formatted as 999999999999.99 Product Code 10 varchar2 6 NACS Code for multiple goods purchased in a single transaction
Only applies to Petroleum   Product Gallons 10 Number 11 Gallons of petroleum associated with the transaction Formatted as 999999.9999 Product Amount Sign 10 varchar2 1 +/-  ('+) = Sale  (-) = Refund Product Amount 10 Number 15 Transaction Amount for Petroleum purchase Formatted as 999999999999.99 Usage Indicator varchar2 1 Indicator to identify if credit transaction is Credit ('C) or Signature Debit (D)   Airline Ticket Number varchar2 20 Airline Industry only   Debit Terminal Date varchar2 8 Date the terminal processed the debit transaction   Debit Terminal Time varchar2 8 Hour, Minute and Second the terminal processed the debit transaction   User Data varchar2 145 Discretionary data sent on transaction by the merchant Comprised of the XN02-XN06 PTS records Mobile Indicator varchar2 2 Indicator that a transaction originated from the Ucomm Gateway *Client specific field not available for use* Filler   1213