Introduction
TouchNet Marketplace does not offer a method of extracting transaction information to perform reconciliation/processing. As an alternative solution, OIT has worked with Bank of America Merchant Services (BAMS), our credit card processor, to utilize their Data File Manager (DFM).
With DFM, we have configured transaction settlement files to be transmitted at the Merchant ID (MID) level.
We are offering this to interested departments. Contact the Student Financials IT team for details on how to get started.
Change Log
| Date | By | Description / Comments | |
|---|---|---|---|
| 1 | Cecilia Do | BAMS modified DFM templates. Update document to reflect changes. | |
| 2 | Cecilia Do | Initial creation of document |
Use Cases
The main use case for this settlement file is to reconcile the uPay postback transactions. Other use cases includes department refund notifications.
Reconciliation with TouchNet Marketplace uPay Postback
TouchNet Marketplace is our hosted-vendor solution that allows online shopping. Credit card payments are collected in Marketplace, and TouchNet in turn transmits the credit card data to Bank of America for processing.
After further analysis of the file, it appears that the fields offered in the BAMS settlement file and the uPay postback fields may not match up well for cross-referencing.
| Field | Marketplace uPay Postback | BAMS Settlement File | Marketplace uPay Reports | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TouchNet Marketplace uPay External Transaction ID | EXT_TRANS_ID |  | Marketplace Reports » uPay Sites » <uPay> » Revenue - External Trans ID | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| TouchNet Payment Gateway Reference Number | tpg_trans_id |
Appears to be a sequential number, most likely based on authorization submit date. Additional cases to consider:
| uPay Sites » <uPay> » Payment Search » Payment Details - TPG Reference Number Marketplace Reports » uPay Sites » <uPay> » Revenue - TPG Reference Number PMSB Values for 10/16/2015 settlement:
PMSB Values for 10/18/2015 settlement:
PMSB Values for 10/19/2015 settlement:
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| TouchNet Marketplace uPay Site ID | UPAY_SITE_ID | | Payment Search/uPay Revenue under specific uPay site | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| TouchNet Marketplace Tracking ID / Order ID | sys_tracking_id | | uPay Sites » <uPay> » Payment Search - System Tracking ID Marketplace Reports » uPay Sites » <uPay> » Revenue - System Tracking ID | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transaction Amount | pmt_amt | Transaction Amount | uPay Sites » <uPay> » Payment Search - Processed Amount Marketplace Reports » uPay Sites » <uPay> » Revenue - Payment Amount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Card Type | card_type | Card Type | uPay Sites » <uPay> » Payment Search - Payment Method Name Marketplace Reports » uPay Sites » <uPay> » Revenue - Payment Method | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Card Holder Name | name_on_acct | | uPay Sites » <uPay> » Payment Search - Customer Name Marketplace Reports » uPay Sites » <uPay> » Revenue - Name | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Masked Card Number | | Card Number | | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Expiration Date | | | | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Authorization Status | pmt_status | Transaction Status | uPay Sites » <uPay> » Payment Search » Payment Details - Status | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Authorization Number | | Authorization Code | | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Authorization Date | pmt_date | Authorization Date | uPay Sites » <uPay> » Payment Search - Order Date Marketplace Reports » uPay Sites » <uPay> » Revenue - Fulfillment Date |
Business Terminology
| Terminology | Description |
|---|---|
| BAMS | Bank of America Merchant Services. |
| DFM | Data File Manager. BAMS module. |
| Merchant ID (MID) | The bank ID number for a merchant, which encompasses Visa, MasterCard, AmEx, Discover, and Discover affiliates. Semi-sensitive. Defined at the highest school/division level for our UCI campus. |
| Masked Credit Card Number | In the settlement file, this includes the first 6 digits and last 4 digits. Per PCI and the BAMS representative, this is not sensitive information and can be freely distributed. |
Authorization Date | Date transaction was submitted to the bank for authorization (e.g. checking funds on card, decreasing available funds). Actual funds have not been deducted from card. |
| Settlement Cutoff | TouchNet Marketplace settlement cutoff is 12AM midnight. |
| Settlement Date | Our settlement cutoff is 12AM midnight, so technically, the settlement date is the day after the authorization. For example, if a transaction is authorized on October 1, then it was settled on October 2. |
| Business Day | Given our credit card settlement cutoff of 12AM midnight, our business day is 12AM midnight through 11:59PM of the same day. |
| Batch Date | Settlement date. |
Transmission Schedule
The file will be transmitted daily at 2PM, regardless of activity. If there is no actual activity, the file will contain the header/trailer records without any transaction detail records.
Today's file will contain the transactions from 2 days ago.
For example, suppose today is October 1. We processed transactions for today's business day: October 1, 12AM through 11:59PM. The transaction batch is closed and submitted for settlement on October 2, 12AM. The file transmission is for the prior day's settlement, which means that the October 1 transactions will be in the October 3 file.
Settlement File Data Dictionary
Settlement File Data Terminology
| Terminology | Description |
|---|---|
| Location / Location ID | Merchant ID (MID). |
Loaded Date | Settlement date. |
| Report | File configured through Bank of America Merchant Services - Data File Manager. Contains transaction settlement details for each business day for each Merchant ID (MID). |
| Record | A single line in the report. Each report is composed of various record types. Report will always contain a File Header and Trailer pair:
Report will always contain one Location Header and Trailer pair:
Depending on the settlement activity, the file will potentially include the following transaction detail records:
Records are a fixed length of 2500 characters. The record is left justified and padded with spaces until it reaches 2500 characters. |
| Field | A single column within the report. Fields are fixed length and left justified. |
Layout
The first five columns are from the BAMS documentation, and the right-most column contains our own additional comments on the field.
Color Legend for the UCI Comments column:
| Important. | |
| May find useful. | |
| Warning. Incorrect/unreliable fields. |
001 File Header
Indicates the start of the file. There is only one 001 record per file.
| Field Name | Field Type | Field Length | Description | Notes | UCI Comments |
|---|---|---|---|---|---|
| Record Type | varchar2 | 3 | Constant value "001" | Record 001 indicates the beginning of the file and is mandatory. | Use to determine how to parse the record. |
| Hierarchy ID | varchar2 | 20 | Hierarchy Merchant Number in which the file is created | Merchant ID number for the school/division. | |
| Hierarchy Level No. | varchar2 | 5 | ClientLine Hierarchy Level that the file is being created for. | Refer to Appendix 1 | |
| Date | varchar2 | 8 | YYYYMMDD | Displays prior day's date. | |
| Merchant Name | varchar2 | 65 | Merchant Name for the Hierarchy ID the file is being generated for | ||
| Filler | varchar2 | 2399 | Spaces | Files will be 1000 character or 2500 fixed length records depending on how many fields are selected. File is padded on the right with spaces. | 2500 characters. |
002 Location Header
Indicates the start of an individual location/MID.
Since there is only one MID configured for each report, there will only be one Location Header/Location Trailer pair per file.
| Field Name | Field Type | Field Length | Description | Notes | UCI Comments |
|---|---|---|---|---|---|
| Record Type | varchar2 | 3 | Constant value "002" | Record 002 indicates the beginning of a record set for each location included in the file. | Use to determine how to parse the record. |
| 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 | Refer to Appendix 1 | |
| Location ID | varchar2 | 20 | Outlet level MID | Merchant ID number for the school/division. | |
| Store Number | varchar2 | 10 | Discretionary number setup on the Merchant Master | ||
| Sic Code | varchar2 | 4 | Merchant Category Code as setup on the Merchant Master | ||
| External ID | varchar2 | 25 | Discretionary Number assigned to Outlet Level MID | ||
| Buypass ID | varchar2 | 20 | Buypass Front End assigned number | ||
| Funded Date/Loaded Date | varchar2 | 8 | YYYYMMDD 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. | This field will represent Funded Date by default, unless you select to receive Transaction Detail records by Load Date. | Utilizing Loaded Date (settlement date). |
| Location DBA Name | varchar2 | 80 | Doing Business Address Name assigned to the Outlet MID | "UCI MARKETPLACE <highest school/division KFS org code>" Displayed on customer credit card statement. | |
| Location Address | varchar2 | 50 | Address assigned to the Outlet MID on the Merchant Master | ||
| Location City | varchar2 | 40 | City assigned to the Outlet MID on the Merchant Master | ||
| Location State/Province | varchar2 | 3 | State or Province assigned to the Outlet MID on the Merchant Master | ||
| Location Zip/Postal Code | varchar2 | 10 | Zip code assigned to the Outlet MID on the Merchant Master | ||
| Location Phone Number | varchar2 | 20 | Phone number assigned to the Outlet MID on the Merchant Master | ||
| Location Contact Name | varchar2 | 45 | DBA Contact Name assigned to the Outlet MID on the Merchant Master | ||
| Filler | 2137 | Spaces | Files will be 1000 character or 2500 fixed length records depending on how many fields are selected. File is padded on the right with spaces. | 2500 characters. |
003 Credit Detail (Funded Card Types)
Funded Card Types include:
- Visa
- MasterCard
The report is pulled by Load Date, so there will be a 003 record for each transaction submitted for settlement on the prior day's date.
If there are no funded card type transactions, then report will not contain 003 records.
| Field Name | Field Type | Field Length | Description | Notes | UCI Comments | ||||
|---|---|---|---|---|---|---|---|---|---|
| Record Type | varchar2 | 3 | Constant value “003” | The 003 record will provide transaction detail for First Data funded card types. There will be a 003 record for each of the transactions included in the prior day's funding. | Use to determine how to parse the record. | ||||
| 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. | Refer to Appendix 1 | |||||
| Location ID | varchar2 | 20 | Outlet level MID | Merchant ID number for the school/division. | |||||
| Location DBA Name | varchar2 | 80 | Doing Business Address Name assigned to the Outlet MID | "UCI MARKETPLACE <highest school/division KFS org code>" Displayed on customer credit card statement. | |||||
| 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 | YYYYMMDD 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. | 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. | Utilizing Loaded Date (settlement date). | ||||
| Card Type | varchar2 | 10 |
| Refer to Appendix 2 | Corresponds to uPay postback card_type. | ||||
| 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. | Displays first 6, last 4 digits of credit card number. | ||||
| 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 | Bank of America's ID number for the submitted transaction batch. Should be the same for all transactions in the same report. | |||||
| Batch Date | varchar2 | 8 | YYYYMMDD Date group of transactions was settled | ||||||
| Authorization Code | varchar2 | 8 |
| Authorization/approval code. | |||||
| Invoice/Trace ID | varchar2 | 20 | Discretionary 12 digit number sent on transaction by merchant | PTS 'S' record | Does not map to TouchNet. | ||||
| Reference Number | varchar2 | 30 | 23 byte Number assigned to each settled transaction prior to sending to the Association | aka ARN | Does not map to TouchNet. | ||||
| Transaction ID | varchar2 | 20 | Number assigned by the Association | Visa Tran ID or MasterCard Banknet Reference Number | Does not map to TouchNet. | ||||
| Transaction Date | varchar2 | 8 | Date transactions was processed at POS | ||||||
| Transaction Amount Sign | varchar2 | 1 | +/- | (+) = Sale (-) = Refund | Corresponds to uPay postback pmt_amt. | ||||
| 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 | Refer to Appendix 3 | |||||
| Submitted Currency Amount Sign | varchar2 | 1 | +/- | 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 | Refer to Appendix 3 | |||||
| Currency Conversion Rate | number | 20 | The rate applied to convert a transaction between submitted and processed currency Formatted as 9999999999.999999999 | ||||||
| Transaction Status | varchar2 | 2 | Code indicating if the transaction was processed (P) or rejected (R) | Refer to Appendix 4 | May want to verify that transaction went through. | ||||
| Reject Indicator | varchar2 | 1 | 1 digit code indicating if the transaction was rejected (Y) or accepted (N) | Refer to Appendix 5 | May want to verify that transaction went through. | ||||
| Reject Reason | varchar2 | 80 | Description why a transaction was rejected | Refer to Appendix 6 | |||||
| Entry Mode | varchar2 | 2 | How the transaction was originally performed (ex. Terminal, POS, Chip) | Refer to Appendix 7 | |||||
| PC Terminal Capability | varchar2 | 1 | Code indicating if the card was Present or Not Present | Refer to 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 | Refer to Appendix 9 | |||||
| Billback Reason | varchar2 | 10 | The code that indicates why a transaction did not clear at the expected rate | Refer to Appendix 10 | |||||
| Reclass Code | varchar2 | 4 | Final plan code that the transaction qualified at | Refer to Appendix 9 | |||||
| Partial Auth Indicator | varchar2 | 1 | 1 digit code indicating if Partial Authorization is supported | Refer to Appendix 11 | |||||
| Transaction Type | varchar2 | 6 | Code indicating the action taken on the card (ex. Sale, Credit, Void) | Refer to Appendix 12 | |||||
| Transaction Mode | varchar2 | 6 | The manor in which a transaction was processed (ex. Electronic, Manual, Swiped) | Refer to Appendix 13 | |||||
| Transaction Source | varchar2 | 2 | How the transaction was sent to us for processing | Refer to Appendix 14 | |||||
| Health Care Card | varchar2 | 2 | Indicator identifying if the card is or isn't a Health Care Card | Refer to Appendix 15 | |||||
| AFD Completion Code | varchar2 | 2 | Automated Fuel Dispenser code. Will only apply to Petroleum clients | Refer to Appendix 16 | |||||
| Authorization Amount Sign | varchar2 | 1 | +/- | (+) = Sale (-) = Refund | As of , Authorization Amount matches Transaction Amount. | ||||
| Authorization Amount | number | 15 | Formatted as 999999999.99 Amount verified as available on a card for a transaction to occur | ||||||
| Authorization Date | varchar2 | 8 | YYYYMMDD Date the verification occurred on a card for a transaction | ||||||
| Transaction Time | varchar2 | 10 | HH:MM:SS The hour, minute and second when the transaction was performed | Some FE default this value. You need to check with you account management team if this information is available on your processing platform. | Does not correspond to actual transaction time; set to 00:00:00. | ||||
| Expiration Date | varchar2 | 4 | 2 digit month & 2 digit year when a card becomes invalid | Does not correspond to actual expiration date of the card. | |||||
| 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 | Refer to 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 | Refer to Appendix 19 | |||||
| CVV2 Result | varchar2 | 1 | Indicator if Card Verification Value is present for MasterCard transaction | Refer to Appendix 19 | |||||
| Sales Tax Amount Sign | varchar2 | 1 | +/- | ||||||
| Sales Tax Amount | number | 15 | Sales Tax Amount on a petroleum transaction | ||||||
| Invoice Amount Sign | varchar2 | 1 | +/- | ||||||
| Invoice Amount | number | 15 | Formatted as 999999999999.99 Total Amount of all the Product Code Amounts for a Petroleum transaction | ||||||
| Product Code 1 | varchar2 | 6 | Only pertains to Fuel transactions | ||||||
| Product Gallons 1 | number | 11 | Formatted as 999999.9999 | Only pertains to Fuel transactions | |||||
| Product Amount Sign 1 | varchar2 | 1 | +/- | Only pertains to Fuel transactions | |||||
| Product Amount 1 | number | 15 | Formatted as 999999999999.99 | Only pertains to Fuel transactions | |||||
| Product Code 2 | varchar2 | 6 | Only pertains to Fuel transactions | ||||||
| Product Gallons2 | number | 11 | Formatted as 999999.9999 | Only pertains to Fuel transactions | |||||
| Product Amount Sign 2 | varchar2 | 1 | +/- | Only pertains to Fuel transactions | |||||
| Product Amount 2 | number | 15 | Formatted as 999999999999.99 | Only pertains to Fuel transactions | |||||
| Product Code 3 | varchar2 | 6 | Only pertains to Fuel transactions | ||||||
| Product Gallons 3 | number | 11 | Formatted as 999999.9999 | Only pertains to Fuel transactions | |||||
| Product Amount Sign 3 | varchar2 | 1 | +/- | Only pertains to Fuel transactions | |||||
| Product Amount 3 | number | 15 | Formatted as 999999999999.99 | Only pertains to Fuel transactions | |||||
| Product Code 4 | varchar2 | 6 | Only pertains to Fuel transactions | ||||||
| Product Gallons 4 | number | 11 | Formatted as 999999.9999 | Only pertains to Fuel transactions | |||||
| Product Amount Sign 4 | varchar2 | 1 | +/- | Only pertains to Fuel transactions | |||||
| Product Amount 4 | number | 15 | Formatted as 999999999999.99 | Only pertains to Fuel transactions | |||||
| Product Code 5 | varchar2 | 6 | Only pertains to Fuel transactions | ||||||
| Product Gallons 5 | number | 11 | Formatted as 999999.9999 | Only pertains to Fuel transactions | |||||
| Product Amount Sign 5 | varchar2 | 1 | +/- | Only pertains to Fuel transactions | |||||
| Product Amount 5 | number | 15 | Formatted as 999999999999.99 | Only pertains to Fuel transactions | |||||
| Vehicle Number | varchar2 | 17 | Only pertains to Fuel transactions | ||||||
| Odometer | varchar2 | 10 | Only pertains to Fuel transactions | ||||||
| Driver ID | varchar2 | 20 | Only pertains to Fuel transactions | ||||||
| Special Reference #1 | varchar2 | 25 | Discretionary field sent by merchant | Merchant Order Number - Only available for merchants processing with Compass | |||||
| Special Reference #2 | varchar2 | 25 | Discretionary field sent by merchant | Tracking Number - Only available for merchants processing with Compass | |||||
| Authorization Response Code | varchar2 | 2 | Code that indicates the response on an attempted transaction. (ex. Approval, decline, etc.) | Refer to Appendix 18 | |||||
| Convenience Fee Amount Sign | varchar2 | 1 | Available for merchants participating in Convenience Fee program | ||||||
| Convenience Fee Amount | number | 9 | Formatted as 999999.99 | Available for merchants participating in Convenience Fee program | |||||
| SubMerchant ID | varchar2 | 20 | Available for PSPs on Compass FE | ||||||
| Soft Descriptor | varchar2 | 32 | Available for PSPs on Compass FE | ||||||
| Bank Reference Number | varchar2 | 20 | Not available for all clients. Project would be required. | ||||||
| Auth Source | varchar2 | 1 | |||||||
| CAT Level | varchar2 | 1 | |||||||
| Cardholder ID Method | varchar2 | 1 | |||||||
| Card Presence Indicator | varchar2 | 1 | |||||||
| Merchant Reference Number | varchar2 | 9 | Pulled from PTS D Record | Appears to be sequential ID number that starts at 1. May loosely tie to uPay postback tpg_trans_id, but reliability questionable. | |||||
| Total Auth Amount Sign | varchar2 | 1 | Do NOT use for matching. Does not necessarily match uPay postback pmt_amt. | ||||||
| Total Auth Amount | varchar2 | 15 | |||||||
| Market Specific Indicator | varchar2 | 1 | |||||||
| Visa Service Develop | varchar2 | 1 | |||||||
| Visa Purchase Indentifier Format | varchar2 | 1 | Do NOT use for matching. May see partial value for "sys_tracking_id", but unreliable. | ||||||
| Visa Purchase Indentifier | varchar2 | 25 | |||||||
| Visa Chip Condition Code | varchar2 | 1 | |||||||
| MC Security Protocol | varchar2 | 1 | |||||||
| MC Cardholder Authentication | varchar2 | 1 | |||||||
| Visa Product ID | varchar2 | 2 | |||||||
| Filler | 497 | Spaces | Files will be 1000 character or 2500 fixed length records depending on how many fields are selected. File is padded on the right with spaces. | 2500 characters. |
004 Credit Detail (Non-Funded Card Types)
Non-Funded Card Types include:
- AmEx
- Discover
- Discover affiliates
- JCB
- Diners
- China UnionPay
The report is pulled by Load Date, so there will be a 004 record for each transaction submitted for settlement on the prior day's date.
If there are no non-funded card type transactions, then report will not contain 004 records.
Format is exactly the same as the 003 record, minus the fields starting at Market Specific Indicator through Visa Product ID (marked in yellow).
| Field Name | Field Type | Field Length | Description | Notes | Comments |
|---|---|---|---|---|---|
| Record Type | varchar2 | 3 | Constant “004” | The 004 record will provide transaction detail for card types that are processed through First Data but not funded by First Data. There will be a 004 record for each of the transactions included in the prior day's funding. | Use to determine how to parse the record. |
See 003 record... | |||||
| Filler | 530 | Spaces | |||
005 Debit Detail
File should not contain debit transactions, as debit card transactions will be treated like a normal credit card and should show up as 003 and 004 records. However, 005 is included for completeness.
| Field Name | Field Type | Field Length | Description | Notes | Comments |
|---|---|---|---|---|---|
| Record Type | varchar2 | 3 | Constant “005” | The 005 record will provide transaction detail for the debit card type. There will be a 005 record for each of the transactions included in the prior day's funding. | Use to determine how to parse the record. |
| 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. | Refer to Appendix 1 | |
| Location ID | varchar2 | 20 | Merchant ID number for the school/division. | ||
| Location DBA Name | varchar2 | 80 | "UCI MARKETPLACE <highest school/division KFS org code>" Displayed on customer credit card statement. | ||
| Store Number | varchar2 | 10 | |||
| External ID | varchar2 | 25 | |||
| Funded Date/Load Date | varchar2 | 8 | 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. | Utilizing Loaded Date (settlement date). |
| Card Type | varchar2 | 10 | Refer to Appendix 2 | Corresponds to uPay postback card_type. | |
| Network ID | varchar2 | 8 | Refer to Appendix 20 | ||
| Card Number | varchar2 | 25 | Card masking is determined by the Masking Flag attribute in Business Track portal for the user. | Displays first 6, last 4 digits of credit card number. | |
| Terminal ID | varchar2 | 15 | **Currently Clientline Database only stores 5 digits | ||
| Batch Number | varchar2 | 20 | Bank of America's ID number for the submitted transaction batch. Should be the same for all transactions in the same report. | ||
| Batch Date | varchar2 | 8 | YYYYMMDD | ||
| Authorization Code | varchar2 | 8 | Authorization/approval code. | ||
| Invoice/Trace ID | varchar2 | 20 | Does not map to TouchNet. | ||
| Reference Number | varchar2 | 30 | Does not map to TouchNet. | ||
| Transaction ID | varchar2 | 20 | Does not map to TouchNet. | ||
| Transaction Date | varchar2 | 8 | YYYYMMDD | Authorization date. | |
| Transaction Amount Sign | varchar2 | 1 | Corresponds to uPay postback pmt_amt. | ||
| Transaction Amount | number | 15 | Formatted as 999999999999.99 | ||
| Processed Currency Code | varchar2 | 3 | Refer to Appendix 3 | ||
| Submitted Currency Amount Sign | varchar2 | 1 | Only available merchants setup as multi-currency | ||
| Submitted Currency Amount | number | 15 | Formatted as 999999999999.99 | Only available merchants setup as multi-currency | |
| Submitted Currency Code | varchar2 | 3 | Refer to Appendix 3 | ||
| Currency Conversion Rate | number | 20 | Formatted as 9999999999.999999999 | ||
| Cash Back Amount Sign | varchar2 | 1 | |||
| Cash Back Amount | number | 15 | Formatted as 999999999999.99 | ||
| Transaction Status | varchar2 | 2 | Refer to Appendix 4 | May want to verify that transaction went through. | |
| Reject Indicator | varchar2 | 1 | Refer to Appendix 5 | May want to verify that transaction went through. | |
| Reject Reason | varchar2 | 80 | Refer to Appendix 6 | ||
| Entry Mode | varchar2 | 2 | Refer to Appendix 7 | ||
| PC Terminal Capability | varchar2 | 1 | Refer to Appendix 8 | ||
| Pinless Debit | varchar2 | 1 | |||
| Plan Code | varchar2 | 4 | Refer to Appendix 9 | ||
| Billback Reason | varchar2 | 10 | Refer to Appendix 10 | ||
| Partial Auth Indicator | varchar2 | 1 | Refer to Appendix 11 | ||
| Transaction Type | varchar2 | 6 | Refer to Appendix 12 | ||
| Transaction Mode | varchar2 | 6 | Refer to Appendix 13 | ||
| Transaction Source | varchar2 | 2 | Refer to Appendix 14 | ||
| Authorization Amount Sign | varchar2 | 1 | As of , Authorization Amount matches Transaction Amount. | ||
| Authorization Amount | number | 15 | Formatted as 999999999999.99 | ||
| Authorization Date | varchar2 | 8 | YYYYMMDD | ||
| Transaction Time | varchar2 | 10 | 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. | Does not correspond to actual transaction time; set to 00:00:00. |
| Expiration Date | varchar2 | 4 | Does not correspond to actual expiration date of the card. | ||
| Authorization SIC Code | varchar2 | 4 | |||
| AVS Flag | varchar2 | 1 | Refer to Appendix 17 | ||
| Response Code | varchar2 | 1 | N/A - see Authorization Response Code at end of record | ||
| CVC2 Result | varchar2 | 1 | Refer to Appendix 19 | ||
| CVV2 Result | varchar2 | 1 | Refer to Appendix 19 | ||
| Sales Tax Amount Sign | varchar2 | 1 | |||
| Sales Tax Amount | number | 15 | |||
| Invoice Amount Sign | varchar2 | 1 | |||
| Invoice Amount | number | 15 | Formatted as 999999999999.99 | ||
| Product Code 1 | varchar2 | 6 | Only pertains to Fuel transactions | ||
| Product Gallons 1 | number | 11 | Formatted as 999999.9999 | Only pertains to Fuel transactions | |
| Product Amount Sign 1 | varchar2 | 1 | Only pertains to Fuel transactions | ||
| Product Amount 1 | number | 15 | Formatted as 999999999999.99 | Only pertains to Fuel transactions | |
| Product Code 2 | varchar2 | 6 | Only pertains to Fuel transactions | ||
| Product Gallons2 | number | 11 | Formatted as 999999.9999 | Only pertains to Fuel transactions | |
| Product Amount Sign 2 | varchar2 | 1 | Only pertains to Fuel transactions | ||
| Product Amount 2 | number | 15 | Formatted as 999999999999.99 | Only pertains to Fuel transactions | |
| Product Code 3 | varchar2 | 6 | Only pertains to Fuel transactions | ||
| Product Gallons 3 | number | 11 | Formatted as 999999.9999 | Only pertains to Fuel transactions | |
| Product Amount Sign 3 | varchar2 | 1 | Only pertains to Fuel transactions | ||
| Product Amount 3 | number | 15 | Formatted as 999999999999.99 | Only pertains to Fuel transactions | |
| Product Code 4 | varchar2 | 6 | Only pertains to Fuel transactions | ||
| Product Gallons 4 | number | 11 | Formatted as 999999.9999 | Only pertains to Fuel transactions | |
| Product Amount Sign 4 | varchar2 | 1 | Only pertains to Fuel transactions | ||
| Product Amount 4 | number | 15 | Formatted as 999999999999.99 | Only pertains to Fuel transactions | |
| Product Code 5 | varchar2 | 6 | Only pertains to Fuel transactions | ||
| Product Gallons 5 | number | 11 | Formatted as 999999.9999 | Only pertains to Fuel transactions | |
| Product Amount Sign 5 | varchar2 | 1 | Only pertains to Fuel transactions | ||
| Product Amount 5 | number | 15 | Formatted as 999999999999.99 | Only pertains to Fuel transactions | |
| Vehicle Number | varchar2 | 17 | Only pertains to Fuel transactions | ||
| Odometer | varchar2 | 10 | Only pertains to Fuel transactions | ||
| Driver ID | varchar2 | 20 | Only pertains to Fuel transactions | ||
| Special Reference #1 | varchar2 | 25 | Merchant Order Number - Only available for merchants processing with Compass | ||
| Special Reference #2 | varchar2 | 25 | Tracking Number - Only available for merchants processing with Compass | ||
| Authorization Response Code | varchar2 | 2 | Refer to Appendix 18 | ||
| Bank Reference Number | varchar2 | 20 | Not available for all clients. Project would be required. | ||
| Receipt Number | varchar2 | 12 | |||
| Auth Source | varchar2 | 1 | |||
| CAT Level | varchar2 | 1 | |||
| Cardholder ID Method | varchar2 | 1 | |||
| Merchant Reference Number | varchar2 | 9 | Pulled from the PTS D Record | Appears to be sequential ID number that starts at 1. May loosely tie to uPay postback tpg_trans_id, but reliability questionable. | |
| Total Auth Amount Sign | varchar2 | 1 | Do NOT use for matching. Does not necessarily match uPay postback pmt_amt. | ||
| Total Auth Amount | varchar2 | 15 | |||
| Market Specific Indicator | varchar2 | 1 | |||
| Visa Product ID | varchar2 | 2 | |||
| Filler | 562 | Spaces | |||
014 Location Trailer
Indicates the end of the location. This record gives the count and total sum for each record type under the location. Can be used for validation.
| Field Name | Field Type | Field Length | Description | Notes | Comments |
|---|---|---|---|---|---|
| Record Type | varchar2 | 3 | Constant “014” | Record 014 indicates the end of a record set for each location included in the file | Use to determine how to parse the record. |
| Hierarchy ID | varchar2 | 20 | |||
| Hierarchy Level No. | varchar2 | 5 | Refer to Appendix 1 | ||
| Location ID | varchar2 | 20 | |||
| Location DBA Name | varchar2 | 80 |
| ||
| Store Number | varchar2 | 10 | |||
| External ID | varchar2 | 25 | |||
| Funded Date/Load Date | varchar2 | 8 | YYYYMMDD | This field will represent Funded Date by default, unless you select to receive Transaction Detail records by Load Date, then this field will display that Load Date. | |
| 002 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 003 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 003 Records -Amount Sign | varchar2 | 1 | |||
| 003 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 004 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 004 Records -Amount Sign | varchar2 | 1 | |||
| 004 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 005 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 005 Records -Amount Sign | varchar2 | 1 | |||
| 005 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 006 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 006 Records -Amount Sign | varchar2 | 1 | |||
| 006 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 007 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 007 Records -Amount Sign | varchar2 | 1 | |||
| 007 Records -Amount | number | 19 | Formatted as 99999999999999.9999 | ||
| 008 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 008 Records -Amount Sign | varchar2 | 1 | |||
| 008 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 009 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 009 Records -Amount Sign | varchar2 | 1 | |||
| 009 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 010 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 010 Records -Amount Sign | varchar2 | 1 | |||
| 010 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 021 Records - Count | number | 12 | Formatted as 999999999999 | ||
| 021 Records -Amount Sign | varchar2 | 1 | |||
| 021 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 029 Records - Count | number | 12 | Formatted as 999999999999 | ||
| 029 Records -Amount Sign | varchar2 | 1 | |||
| 029 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 030 Records - Count | number | 12 | Formatted as 999999999999 | ||
| 030 Records -Amount Sign | varchar2 | 1 | |||
| 030 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 031 Records - Count | number | 12 | Formatted as 999999999999 | ||
| 031 Records -Amount Sign | varchar2 | 1 | |||
| 031 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 011 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 011 Records -Amount Sign | varchar2 | 1 | |||
| 011 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 012 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 012 Records -Amount Sign | varchar2 | 1 | |||
| 012 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 013 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 013 Records -Amount Sign | varchar2 | 1 | |||
| 013 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 022 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 022 Records -Amount Sign | varchar2 | 1 | |||
| 022 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 024 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 024 Records -Amount Sign | varchar2 | 1 | |||
| 032 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 032 Records -Amount Sign | varchar2 | 1 | |||
| 032 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 033 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 033 Records -Amount Sign | varchar2 | 1 | |||
| 033 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 034 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 034 Records -Amount Sign | varchar2 | 1 | |||
| 034 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 024 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 014 Records -Count | number | 12 | Formatted as 999999999999 | ||
| Filler | 1665 |
999 File Trailer
Indicates the end of the file. This record gives the count and total sum for each record type in the file. Can be used for validation.
Because each file will contain only one location, the 999 summary should match the 014 summary.
| Field Name | Field Type | Field Length | Description | Notes | Comments |
|---|---|---|---|---|---|
| Record Type | varchar2 | 3 | Constant “999” | Record 999 indicates the end of the file and is mandatory, however the user can choose which fields to be included in the record. | Use to determine how to parse the record. |
| Hierarchy ID | varchar2 | 20 | |||
| Hierarchy Level No. | varchar2 | 5 | Refer to Appendix 1 | ||
| Date | varchar2 | 8 | YYYYMMDD | This field will display the prior day's date. | |
| 001 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 002 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 003 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 003 Records -Amount Sign | varchar2 | 1 | |||
| 003 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 004 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 004 Records -Amount Sign | varchar2 | 1 | |||
| 004 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 005 Records -Count | number | 12 | Formatted as 999999999999 | ||
| 005 Records -Amount Sign | varchar2 | 1 | |||
| 005 Records -Amount | number | 19 | Formatted as 9999999999999999.99 | ||
| 014 Records - Count | number | 12 | Formatted as 999999999999 | ||
| 999 Records - Count | number | 12 | Formatted as 999999999999 | ||
| Filler | 2320 |
Appendices
From BAMS documentation.
Appendix 1 - Hierarchy Levels
Code | Description |
|---|---|
120 | Outlet |
100 | Chain |
90 | Corporate |
60 | Agent |
50 | Bank |
40 | Business (Owner) |
20 | Marker Bank |
Appendix 2 - Card Type
Code | Description |
|---|---|
00000 | Not Specified |
00001 | MasterCard |
00002 | Visa |
00003 | Discover |
00004 | Diners (FDMS Funds) |
00005 | Diners Pass through |
00006 | Amex |
00007 | JCB |
00008 | Amex OptBlue |
00009 | Private Label |
00010 | Voyager |
00011 | Encore |
00012 | NYCE (Debit) |
00013 | Most |
00014 | Private Label |
00015 | SES |
00016 | Cashstation (Debit) |
00017 | Pulse (Debit) |
00018 | ATM (Debit) |
00019 | JBS |
00020 | Telecheck |
00021 | Telecheck |
00022 | ETC (Debit) |
00023 | Explore (Debit) |
00024 | Interlink (Debit) |
00025 | Switch (Debit) |
00026 | Purchasing Card |
00027 | EBT – Electronic Benefits Transfer |
00028 | Gateway Debit Card |
00029 | Stored Value |
00030 | Stored Value |
00031 | Private Label |
00033 | Check Warranty |
00034 | Check Non-Warranty |
00035 | WEX – Wright Express |
00036 | Petroleum – Fleet Core |
00037 | Petroleum – Fleet One |
00038 | Petroleum |
00039 | Petroleum |
00040 | Petroleum |
00048 | Loyalty |
00049 | Bill Me Later |
00050 | Revolution Money |
00075 | Maestro |
00076 | Maestro Chip |
00077 | Solo |
00078 | Solo Chip |
00079 | Visa Consumer |
00080 | Visa Electronic Signature |
00081 | Visa Debit |
00082 | Visa Purchasing Card |
00083 | Visa Debit Chip |
00084 | Visa Chip |
00085 | MasterCard Consumer |
00086 | MasterCard Chip |
00087 | MasterCard Purchasing Card |
00088 | MasterCard Debit |
00092 | MasterCard Debit Chip |
00093 | Telecredit |
Appendix 3 - Currency Code
| Currency Code | Country Name | Currency Name | Abbreviation |
|---|---|---|---|
| 008 | Albania | Lek | ALL |
| 012 | Algeria | Algerian Dinar | DZD |
| 031 | Azerbaijan | Azerbaijanian Manat | AZN |
| 032 | Argentina | Argentine Peso | ARA |
| 036 | Australia | Australian Dollar | AUD |
| 044 | Bahamas | Bahamian Dollar | BSD |
| 048 | Bahrain | Bahraini Dinar | BHD |
| 050 | Bangladesh | Taka | BDT |
| 051 | Armenia | Armenian Dram | AMD |
| 052 | Barbados | Barbados Dollar | BBD |
| 060 | Bermuda | Bermudian Dollar | BMD |
| 064 | Bhutan | Ngultrum | BTN |
| 068 | Bolivia | Boliviano | BOB |
| 072 | Botswana | Pula | BWP |
| 084 | Belize | Belize Dollar | BZD |
| 090 | Solomon Islands | Solomon Islands Dollar | SBD |
| 096 | Brunei Darussalam | Brunei Dollar | BND |
| 104 | Myanmar | Kyat | MMK |
| 108 | Burundi | Burundi Franc | BIF |
| 116 | Cambodia | Riel | KHR |
| 124 | Canada | Canadian Dollar | CAD |
| 132 | Cape Verde Island | Cape Verde Escudo | CVE |
| 136 | Cayman Islands | Cayman Islands Dollar | KYD |
| 144 | Sri Lanka | Sri Lanka Rupee | LKR |
| 152 | Chile | Chilean Peso | CLP |
| 156 | China, People's Republic of | Yuan Renminbi | CNY |
| 170 | Colombia | Colombian Peso | COP |
| 174 | Comoros | Comoro Franc | KMF |
| 188 | Costa Rica | Costa Rican Colon | CRC |
| 191 | Croatia, Republic of | Croatian Kuna | HRK |
| 192 | Cuba* | Cuban Peso | CUP |
| 196 | Cyprus | Cyprus Pound | CYP |
| 203 | Czech Republic | Czech Koruna | CSK |
| 208 | Denmark | Danish Krone | DKK |
| 214 | Dominican Republic | Dominican Peso | DOP |
| 218 | Ecuador | Sucre | ECS |
| 222 | El Salvador | El Salvador Colon | SVC |
| 230 | Ethiopia | Ethiopian Birr | ETB |
| 232 | Eritrea* | Eritrean Nafka | ERN |
| 233 | Estonia | Kroon | EEK |
| 238 | Falkland Islands (Malvinas) | Falkland Islands Pound | FKP |
| 242 | Fiji | Fiji Dollar | FJD |
| 262 | Djibouti | Djibouti Franc | DJF |
| 270 | Gambia | Dalasi | GMD |
| 288 | Ghana | Cedi | GHC |
| 292 | Gibraltar | Gibraltar Pound | GIP |
| 320 | Guatemala | Quetzal | GTQ |
| 324 | Guinea | Guinea Franc | GNF |
| 328 | Guyana | Guyana Dollar | GYD |
| 332 | Haiti | Gourde | HTG |
| 340 | Honduras | Lempira | HNL |
| 344 | Hong Kong | Hong Kong Dollar | HKD |
| 348 | Hungary | Forint | HUF |
| 352 | Iceland | Icelandic Krona | ISK |
| 356 | India/Bhutan | Indian Rupee | INR |
| 858 | Uruguay | Peso Uruguayo | UYU |
| 360 | Indonesia/East Timor | Rupiah | IDR |
| 936 | Ghana | Cedi | GHS |
| 364 | Iran, Islamic Republic of | Iranian Rial | IRR |
| 365 | Iran Airlines | Iranian Airline Rate | |
| 368 | Iraq | Iraqi Dinar | IQD |
| 376 | Israel | Shekel | ILS |
| 388 | Jamaica | Jamaican Dollar | JMD |
| 392 | Japan | Yen | JPY |
| 398 | Kazakhstan | Tenge | KZT |
| 400 | Jordan | Jordanian Dinar | JOD |
| 404 | Kenya | Kenyan Shilling | KES |
| 408 | North Korean | North Korean Won | KPW |
| 410 | Korea, Republic of | Won | KRW |
| 414 | Kuwait | Kuwaiti Dinar | KWD |
| 417 | Kyrgyzstan | Som | KGS |
| 418 | Lao | Kip | LAK |
| 422 | Lebanon | Lebanese Pound | LBP |
| 426 | Lesotho | Loti | LSL |
| 428 | Latvia | Latvian Lats | LVL |
| 430 | Liberia | Liberian Dollar | LRD |
| 434 | Libyan Arab Jamahiriya | Libyan Dinar | LYD |
| 440 | Lithuania | Lithuanian Litas | LTL |
| 446 | Macau | Pataca | MOP |
| 454 | Malawi | Kwacha | MWK |
| 458 | Malaysia | Malaysian Ringgit | MYR |
| 462 | Maldives | Rufiyaa | MVR |
| 470 | Malta | Maltese Lira | MTL |
| 478 | Mauritania | Ouguiya | MUR |
| 480 | Mauritius | Mauritius Rupee | MUR |
| 484 | Mexico | Mexican Peso | MXP |
| 496 | Mongolia | Tugrik | MNT |
| 498 | Moldova, Republic of | Moldovan Leu | MDL |
| 504 | Morocco | Moroccan Dirham | MAD |
| 508 | Mozambique | Metical | MZM |
| 512 | Oman | Rial Omani | OMR |
| 516 | Namibia | Namibia Dollar | NAD |
| 524 | Nepal | Nepalese Rupee | NPR |
| 532 | Netherlands Antilles | Netherlands Antillian Guilder | NLG |
| 533 | Aruba | Aruban Guilder | AWG |
| 548 | Vanuatu | Vatu | VUV |
| 554 | New Zealand | New Zealand Dollar | NZD |
| 558 | Nicaragua | Cordoba Oro | NIC |
| 566 | Nigeria | Naira | NGN |
| 578 | Norway | Norwegian Kroner | NOK |
| 586 | Pakistan | Pakistan Rupee | PKR |
| 590 | Panama | Balboa | PAB |
| 598 | Papua New Guinea | Kina | PGK |
| 600 | Paraguay | Guarani | PYG |
| 604 | Peru | Nuevo Sol | PEI |
| 608 | Philippines | Philippine Peso | PHP |
| 624 | Guinea-Bissau | Guinea-Bissau Peso | GWP |
| 626 | East Timor | Timor Escudo | TPE |
| 634 | Qatar | Qatari Rial | QAR |
| 643 | Russian Federation | Russian Ruble | RUR |
| 646 | Rwanda | Rwanda Franc | RWF |
| 654 | Saint Helena | Saint Helena Pound | SHP |
| 678 | Sao Tome and Principe | Dobra | STD |
| 682 | Saudi Arabia | Saudi Riyal | SAR |
| 690 | Seychelles | Seychelles Rupee | SCR |
| 694 | Sierra Leone | Leone | SLL |
| 702 | Singapore | Singapore Dollar | SGD |
| 703 | Slovakia | Slovak Koruna | SSK |
| 704 | Vietnam | Dong | VND |
| 705 | Slovenia | Tolar | SIT |
| 706 | Somalia | Somali Shilling | SOS |
| 710 | South Africa | Rand | ZAR |
| 716 | Zimbabwe | Zimbabwe Dollar | ZWD |
| 736 | Sudan | Sudanese Pound | SDF |
| 740 | Suriname | Surinam Guilder | SRG |
| 748 | Swaziland | Lilangeni | SZL |
| 752 | Sweden | Swedish Krona | SEK |
| 756 | Switzerland | Swiss Franc | CHF |
| 760 | Syrian Arab Republic | Syrian Pound | SYP |
| 764 | Thailand | Baht | THB |
| 776 | Tonga | Pa'anga | TOP |
| 780 | Trinidad and Tobago | Trinidad and Tobago Dollar | TTD |
| 784 | United Arab Emirates | U.A.E. Dirham | AED |
| 788 | Tunisia | Tunisian Dinar | TND |
| 792 | Turkey | Pseudo-Turkish Lira | TRY |
| 795 | Turkmenistan | Manat | TMM |
| 800 | Uganda | Uganda Shilling | UGS |
| 807 | Macedonia | Denar | MKD |
| 818 | Egypt | Egyptian Pound | EGP |
| 826 | United Kingdom | Pound Sterling | GBP |
| 834 | Tanzania, United Republic of | Tanzanian Shilling | TZS |
| 840 | United States | U.S. Dollar | USD |
| 860 | Uzbekistan | Uzbekistan Sum | UZS |
| 862 | Venezuela | Bolivar | VEB |
| 882 | Samoa | Tala | WST |
| 886 | Yemen | Yemeni Rial | YER |
| 891 | Serbia and Montenegro | Serbian Dinar | CSD |
| 894 | Zambia | Kwacha | ZMK |
| 901 | Taiwan (Province of China) | New Taiwan Dollar | TWD |
| 946 | Romania | Leu | ROL |
| 949 | Turkey | Turkish Lira | TRL |
| 950 | Central African Republic | CFA Franc BEAC | XAF |
| 951 | Anguilla | East Caribbean Dollar | XCD |
| 952 | Benin | CFA Franc BCEAO | XOF |
| 953 | French Polynesia | CFP Franc | XPF |
| 969 | Madagascar | Ariary | MGA |
| 971 | Afghanistan | Afghani | AFA |
| 972 | Tajikistan | Somoni | TJS |
| 973 | Angola | Kwanza | AOK |
| 974 | Belarus | Belarussian Ruble | BYR |
| 975 | Bulgaria | Lev | BGL |
| 976 | Republic of the Congo | Franc Congolais | CDF |
| 977 | Bosnia and Herzegovina | Bosnian Convertible Mark | BAM |
| 978 | European Union | Euro | EUR |
| 980 | Ukraine | Ukrainian Hryvnia | UAH |
| 981 | Georgia | Georgian Lari | GEL |
| 982 | Angola | Kwansa Reajustado | AOA |
| 983 | Ecuador | Unidad de Valor Constante | ECV |
| 984 | Bolivia | Mvdol | BOB |
| 985 | Poland | Polish New Zloty | PLZ |
| 986 | Brazil Brazil | Real | BRC |
| 937 | Venezuela | Bolivar Fuerte | VEF |
| 941 | Serbia | Serbian Dinar | RSD |
| 943 | Mozambique | Metical | MZN |
| 944 | Azerbaijan | Azerbaijanian Manat | AZN |
| 968 | Suriname | Surinam Dollar | SRD |
Appendix 4 - Transaction Status
Code | Description |
|---|---|
A | Processed |
R | Reject |
Appendix 5 - Reject Indicator (Transaction Detail)
Code | Description |
|---|---|
Y | Transaction is rejected |
N | Transaction is accepted |
Appendix 6 - Reject Code
| Reject Code | Description |
|---|---|
| 01 | MERCHANT RECORD MISSING OR INFORMATION INVALID |
| 02 | MERCHANT DESCRIPTOR MISSING OR INFORMATION INVALID |
| 03 | INVALID RECORD IDENTIFICATION |
| 07 | BATCH RECORD MISSING OR INFORMATION INVALID |
| 09 | DETAIL RECORD BYPASSED - BAD MERCHANT OR DESCRIPTOR |
| 0A | NF ON BANK AGENT (CHAIN AGENT # NOT ON AGENT BANK FILE) |
| 0B | BAD/MISSING MERC (MERC NOT ON MASTER/BAD MERCHANT STATUS) |
| 0C | REJECT EDS MERCH (PLMU EDSM IND=N (NOT XREF), & ON XREF) |
| 0E | OTHER MERCHANT TO FUND IS NOT FOUND OR BAD STATUS |
| 0F | BAD/MISSING DESC (INV VALUES NOT A-Z, 0-9, SPACE OR '*') |
| 0K | PTS DEP/NO BATCH (PLMU/SEC CODE ISSUE & MISSING BATCH REF) |
| 0L | REJECT EDS BATCH (BATCH SEC CODE AND (BATCH TERMINAL NO)) |
| 0U | REJECT MERCHANT (120 TABLE/CLEARING BANK IND ISSUE) |
| 0V | NOT CLIENT CERT (SEC CODE NOT LISTED AS CRT ON PLMU) |
| 10 | CARDHOLDER ACCOUNT NUMBER INVALID |
| 11 | TRANSACTION CODE INVALID OR NOT ENTITLED FOR CARD PROD |
| 12 | TRANSACTION AMOUNT INVALID |
| 13 | TRANSACTION DATE INVALID |
| 14 | AUTH DATE INVALID |
| 15 | CARD EXPIRATION DATE INVALID |
| 16 | REFERENCE NUMBER INVALID |
| 17 | RECORD OUT OF SEQUENCE |
| 18 | DUPLICATE DETAIL RECORD |
| 19 | ADDITIONAL AMEX RECORD NOT AVAILABLE OR INCORRECT |
| 1A | ISSUE # NOT VALID (ISSUE-NO(2:1) = '0' OR HIGH VALUES) |
| 1B | INV ISS#-NOT SCS (SW/SO CARD &XLD1-ISSUE-NO BYTE2 NOT NUM) |
| 1C | INV CRDHLDR ERR (BAD CARDHOLDER ACCOUNT NUMBER(NOT NUMERIC)) |
| 1K | INV TRANS CODE (TRANS. CODE IS INVALID (NOT 5-9)) |
| 1L | SLS TRN(CA MRCH) (CASH ADVANCE MERCHANT & TRAN CODE = 5) |
| 1M | C/A TRN(SL MRCH) (SALE MERCHANT AND TRAN CODE = 7) |
| 1N | SALE/CASH TXN INVALID FOR (OC) MRCH |
| 1P | MERSUM/CASH ADV (SALE MERCHANT AND TRAN CODE = 7) |
| 1Q | MERSUM/SALE TYPE (CASH ADVANCE MERCHANT & TRAN CODE = 5) |
| 1R | TRNCDE NOT 5,6,7 (TRAN CODE NOT 5, 6, 7 |
| 1T | VISA MCC NE 6010 (VI TRAN/SALE MER & TRAN CODE AND = 7) |
| 1V | CR FOR MCC 6010 |
| 1W | SVCTP/PLANCD ERR (BAD PROD & PLAN COMBO FOR TYPE OF MERCH) |
| 1Y | SVC LVL INVALID (ENT SERV LVL NOT('F'/'B'/'K'/'P'/'M') |
| 1Z | NO ENTITLE FOUND (ENTITLEMENT NOT FOUND FOR PRODUCT) |
| 21 | BNB PRIVATE LABEL BAD CREDIT PLAN |
| 22 | AUTH DECLINED - DELINQUENT ACCT, OVER CRED LIMIT, ETC |
| 23 | AUTH DECLINED - LOST OR STOLEN CARD |
| 24 | AUTH REFERRAL |
| 25 | FOREIGN DETAIL INVALID - NON-NUMERIC DOLLAR AMOUNT |
| 26 | FOREIGN DETAIL INVALID - INCORRECT CURRENCY CODE |
| 27 | DUPE EDIT |
| 2B | INV FGN AMT EXTN (FOREIGN AMT NOT NUMERIC OR ZERO) |
| 2C | FGN AMT NOT NUM (F-REC AND FOREIGN AMT NOT NUMERIC) |
| 2F | INV DT ON TRTIME (DDD NOT 1-366, TIME NOT 00-99) |
| 2H | INV TM ON TRTIME (XLD1 HHMMSS (HR, MIN, SEC) NOT VALID) |
| 2I | MC DESCNTRY IRA (MASTERCARD AND DEST COUNTRY IS IRAN) |
| 2J | INV FGN CURR CDE (F-REC CURR CODE NOT FOUND ON FOR CURR TBL) |
| 2L | INV XLD1TERMOCAP (XLD1-TERM-OCAP NOT 0 - 4 OR SPACE) |
| 2P | INV XLD1TERMTYPE (XLD1-TERM-TYPE NOT 0 - 9 OR SPACE) |
| 30 | TOTAL SALES AMOUNT OUT OF BALANCE OR NOT NUMERIC |
| 31 | TOTAL CREDIT AMOUNT OUT OF BALANCE OR NOT NUMERIC |
| 32 | TOTAL CASH ADVANCE AMOUNT OUT OF BALANCE OR NOT NUMERIC |
| 33 | TOTAL SALES AUTH AMOUNT OUT OF BALANCE OR NOT NUMERIC |
| 34 | TOTAL CASH ADVANCE AUTH AMOUNT OUT OF BALANCE OR NOT NUMERIC |
| 35 | INV ACQ/PROC ID |
| 36 | INV PROCESS CODE |
| 37 | INV CASHOVER AMT |
| 3A | CHIP TRANSACTION AMOUNT INVALID OR ZERO |
| 3B | CHIP TRANSACTION TYPE NOT NUMERIC |
| 3C | CHIP TERMINAL TRANSACTION DATE NOT VALID |
| 3D | CHIP CURRENCY CODE IS NOT VALID ISO COUNTRY CODE |
| 3E | CHIP COUNTRY CODE IS NOT VALID ISO COUNTRY CODE |
| 3F | CHIP TRANSACTION CRYPTOGRAM BYTES ARE NOT 0-9 OR A-F |
| 3G | CHIP INTERCHANGE PROFILE BYTES ARE NOT 0-9 OR A-F |
| 3H | CHIP APPLICATION TRANS. COUNTER BYTES ARE NOT 0-9 OR A-F |
| 3I | CHIP UNPREDICTABLE NUMBER BYTES ARE NOT 0-9 OR A-F |
| 3J | CHIP TERMINAL VERIFICATION RESULTS BYTES ARE NOT 0-9 OR A-F |
| 3K | CHIP ISSUER APPLICATION DATA BYTES ARE NOT 0-9 OR A-F |
| 3L | CHIP USAGE CONTROL BYTES ARE NOT 0-9 OR A-F |
| 3M | CHIP CRYPTOGRAM INFORMATION DATA BYTES ARE NOT 0-9 OR A-F |
| 3N | CHIP CVM RESULTS BYTES ARE NOT 0-9 OR A-F |
| 3P | CHIP AID OR DF NAME BYTES ARE NOT 0-9 OR A-F |
| 3Q | CHIP APPLICATION VERSION BYTES ARE NOT 0-9 OR A-F |
| 3R | CHIP TRANSACTION STATUS BYTES ARE NOT 0-9 OR A-F |
| 3S | CHIP TERMINAL TYPE BYTES ARE NOT 0-9 OR A-F |
| 3T | CHIP TERMINAL CAPABILITY BYTES ARE NOT 0-9 OR A-F |
| 40 | TOTAL # SALES AUTH REQUEST OUT OF BALANCE OR NOT NUMERIC |
| 41 | INVALID OR MISSING PRODUCT CODE ON FLEET OR PURCHASE CARD |
| 42 | INVALID OR MISSING QUANTITY/SALE AMT ON FLEET OR PURCH. CARD |
| 43 | INVALID OR MISSING TAX AMOUNT ON FLEET OR PURCHASE CARD |
| 44 | FLEET OR PURCHASE CARD ITEM OUT-OF-BALANCE |
| 45 | DETL. TRANS. OUT-OF-BALANCE WITH FLEET OR PURCH CARD ITEMS |
| 46 | TOTAL # P/L AUTH REQUEST OUT OF BALANCE OR NOT NUMERIC |
| 47 | TOTAL # ADDRESS VERIF REQUEST OUT OF BALANCE OR NOT NUMERIC |
| 48 | DETAIL WAS RE-AUTH |
| 49 | DETAIL HELD FOR DELAY RETRY |
| 4A | MCC>0/B077 (MCC IS NOT RECOGNIZED |
| 50 | DETAIL HELD FOR OPTIONAL REFERRAL |
| 52 | INVALID SIGNATURE - DETAIL ACCEPTED |
| 5H | -MC MCC NE 6010 (MC TRAN /SALE MER & TRAN CODE AND=7) |
| 61 | WARNING - MISSING AIRLINE ITINERARY INFORMATION |
| 62 | INVALID SIGNATURE - DETAIL REJECTED |
| 6A | -KUTAC015 RC=(??) (CURRENCY CONVERSION PROBLEM |
| 6B | MSD CONTACTLESS TXN |
| 6C | CONTACTLESS SOLO/VISA SIG. |
| 6D | CONTACTLESS WITH ADDENDA |
| 6E | INV. TXN TYPE CONTACTLESS |
| 6F | CONTACTLESS CUR <>826 |
| 6G | CONTACTLESS AMT > MAX |
| 6H | CONTACTLESS NOT ALLOWED |
| 70 | AIRLINE ITINERARY:INVALID PASSENGER NAME INFORMATION |
| 71 | AIRLINE ITINERARY:INVALID DEPARTURE DATE |
| 72 | AIRLINE ITINERARY:INVALID CITY OF ORIGIN |
| 73 | AIRLINE ITINERARY:INVALID '1ST LEG' DATA |
| 74 | AIRLINE ITINERARY:INVALID '2ND,3RD OR 4TH LEG' DATA |
| 75 | AIRLINE ITINERARY:INVALID TICKET NUMBER |
| 76 | AIRLINE ITINERARY:INVALID STOP-OVER CODE |
| 77 | Airline itinerary: invalid |
| 7A | ORDER DATE > TRAN DATE |
| 7B | ORDER DATE NOT SPACES OR ZEROES |
| 7C | ORDER DATE INVALID |
| 7D | ORDER REF# INVALID (ORDER REF # <= SPACES) |
| 7E | SUMMARY CODE INVALID (NOT 'SUMM' OR 'LID') |
| 7F | MERCH VAT# <= SPACES OR FAILED MOD97 CHECK |
| 7H | DISCOUNT AMT NOT SPACES AND NOT NUMERIC |
| 7I | FREIGHT TAX AMT NOT = CALCULATED TAX AMT (+-.01) |
| 7J | VAT AMT NOT NUMERIC AND NOT SPACES |
| 7K | VAT AMT NUMERIC AND < .01 WITH VAT IND = 0 |
| 7L | ITEM DESC. INVALID (NOT SPACES) |
| 7M | ITEM CODE INVALID (NOT SUMM = '0000', LID = VALID LIST) |
| 7N | ITEM UNIT OF MEASURE INVALID (SUMM = SPACES, LID<> SPACES) |
| 7O | ITEM CODE INVALID |
| 7P | ITEM DISCOUNT ID INVALID (NOT = SPACES,N,Y) |
| 7R | ITEM DISCOUNT AMT INVALID |
| 7S | ITEM QUANTITY INVALID |
| 7T | ITEM UNIT AMOUNT INVALID |
| 7U | ITEM LINE TOTAL INVALID |
| 7V | VAT AMT FAIL CALC |
| 7W | TRAN AMT. NOT = PURCHASE PIECES TOTALED + TOL |
| 7X | SEQUENCE ON EACH ITEM NOT = OR NOT SEQUENTIAL |
| 80 | ADDRESS VERIFICATION REQUEST |
| 81 | ADDRESS VERIFICATION ERROR |
| 82 | CONDITIONAL DEPOSIT REJECTED AS A RESULT OF ADDRESS VERIF |
| 83 | ADDRESS VERIF REQUESTED; MISSING INPUT ADDRESS VERIF RECORD |
| 87 | DUPLICATED NON BANK-CARD TRANSACTION FOR MEMO-POST MERCHANT |
| 8A | FRAUD FOUND (TRAN CODE IS 6 & CARD # ON FRAUD LIST) |
| 8B | CSHBK AMT NOTNUM (XD01 CASH BACK AMT NOT NUMERIC) |
| 8C | SWITCHAMT NOTNUM (SWITCH CARD AND SALE AMT NOT NUMERIC) |
| 8D | CRDAMT NOT NUM/0 (TRAN AMT NOT NUMERIC, OR ZERO, OR NEG AMT) |
| 8H | EX IND=D/TRNCD=6 (MM-EXCLUSION-IND = D & TRAN CODE = 6) |
| 8I | EI=Y/FDL=$1/TC=6 (CREDIT EXCLUSION ISSUE) |
| 8J | TC=5,7/AMT>49999 (TRAN CODE = 5 OR 7 AND AMOUNT > 49999.99) |
| 8K | TC=6/AMT>19999 (TRAN CODE = 6 AND AMOUNT > 19999.99) |
| 8L | AMT > AMT LIMIT (AMOUNT > ALLOWABLE LIMIT |
| 8M | CRD AMT>49999.99 (AMOUNT > +49999.99) |
| 8Q | SALE DTE NOT NUM (TRANSACTION DATE NOT NUMERIC) |
| 8R | INV CARD SALE DT (INVALID TRANSACTION DATE) |
| 8S | INV 04 SALE DATE (TRAN DATE OVER 210 DAYS OLD) |
| 8T | INV 05 SALE DATE (BAD RETURN CODE FROM DATE UTIL MODULE) |
| 8V | INV 04 TRAN DATE (SWITCH AND INVALID TRAN DATE) |
| 8W | INV EXPIRE DATE (EXP DATE HAS INV.MONTH/YEAR NOT 00-99) |
| 8X | EXP/SALE DTE ERR (SALE DATE > EXPIRE DATE) |
| 8Y | EXP/CURR DTE ERR (CURRENT DATE > EXPIRE DATE) |
| 90 | INVALID CARD ACCOUNT NUMBER - SM10 TRANSACTIONS ONLY |
| 98 | SUBMISSION ACCEPTED |
| 99 | SUBMISSION REJECTED |
| 9A | BAD QUAL RC=(??) (TRANSACTION COULD NOT QUALIFY) |
| 9B | BAD QUAL 1ST DG= (1ST DIG OF 23 DIG REF NO = NOT NUMERIC) |
| 9C | BAD QUAL 2ND DG= (2ND DIG OF 23 DIG REF NO = NOT NUMERIC) |
| 9D | BAD PRD/PLN COMBO (INVALID PRODUCT AND PLAN CODE COMBO) |
| 9E | QUAL PLANCDE INV (QUALIFIER PLAN CODE <= 000) |
| 9F | QUAL RTN STAT=E7 (QUALIFIER RETURN CODE E7 (BAD U.S. AMT)) |
| 9H | REF# NOT NUMERIC (DETAIL REFERENCE NO NOT NUMERIC) |
| 9I | REF# EQUAL ZEROS (DETAIL REFERENC NO IS ZERO) |
| 9J | BAD BASE34 CALL (PROBLEM CONVERTING 23 DIG REF TO BASE 34) |
| 9K | INVALID GENREF # (INVALID CHECK DIGIT ON 23 DIGIT REF NO) |
| 9L | TRANSACTION NOT ACCEPTABLE ON MAESTRO INTL TXN |
| 9N | CHIP TRAN DATE NOT EQUAL TO SALES TRAN DATE |
Appendix 7 - Entry Mode
Code | Description |
|---|---|
00 | Terminal not used/hardcopy |
01 | Manual/Key entered |
02 | Magnetic stripe read – track 2 |
03 | Bar Code Read |
04 | OCR Read |
05 | ICC Read – CVV Data Reliable |
06 | Magnetic stripe read – track 1 |
07 | Pan Auto Entry via contactless chip |
30 | Unspecified or unknown |
32 | POS Device not pin entry capable |
38 | PIN capability/pinpad not working |
39 | PIN Verified by POS Device |
80 | Magnetic Stripe unaltered – as fallback to chip |
81 | Electronic Commerce Transaction |
90 | CVV Qualified mag stripe read |
92 | Batch Authorizations |
93 | Batch Authorization Cash Access |
95 | ICC Read – CVV Data Unreliable |
91 | Pan auto-entry via contactless magnetic stripe |
Appendix 8 - Terminal Capabilities
Code | Description |
|---|---|
P | Present |
Null | Not Present |
Appendix 9 - Interchange Plan Code
Download link here.
Appendix 10 - Non-Qual Codes
Download link here.
Appendix 11 - Partial Authorization Inidicatory
Code | Description |
|---|---|
0/Null | Partial Authorization not Supported |
1 | Partial Authorization Supported |
Appendix 12 - Transaction Type
Code | Description |
|---|---|
5 | Sale |
6 | Credit |
7 | Cash Advance |
8 | Conditional Deposit Sale |
9 | Conditional Deposit Cash Advance |
A | Sale Auth Request |
B | Cash Advance Auth Request |
C | American Express Auth Request |
D | Carte Blanche Auth Request |
E | Diners Club Auth Request |
F | JBS Auth Request |
G | Private Label Auth Request |
H | Account Verify Request |
X | Regular Void |
Y | Void Undelivered |
Z | Void Reversal |
Appendix 13 - Transaction Mode
Code | Description |
|---|---|
E | Electronic |
M | Manual |
S | Swiped |
Appendix 14 - Transaction Source
Code | Description |
|---|---|
BT | Batch Settlement |
HC | Host Capture |
Appendix 15 - Health Care Card
Code | Description |
|---|---|
Y | Health Care Card |
Null | Not a Health Care Card |
Appendix 16 - AFD Completion Code
Code | Description |
|---|---|
Y | Completion Advice Received within 60 mins. |
N | No Completion Advice Received |
U | Untimely Completion Advice |
Null | Not applicable or not provided |
Appendix 17 - AVS Flag
Code | Description |
|---|---|
0 | Data Was not Supplied in Auth Request |
1 | Data Was Supplied but not checked by Issuer |
2 | Data Matched |
4 | Data Did Not Match |
A | Address Matches, Postal Code Does not Match |
B | Intl Address Matches, Postal Code Does not Match |
C | Intl Address and Postal Code Do not Match |
D | Intl Address and Postal Code Match |
E | Error Response for Merchant Category Code |
F | Address and Postal Code Match |
G | Address Not Verified, International |
I | Intl Address Not Verified |
M | Intl Address and Postal Code Match |
N | Address and Postal Code Do Not Match |
P | Intl Postal Code Matches, Address Does Not Match |
R | Issuer System Unavailable or Timeout, Retry |
S | Service Not Supported by Issuer |
T | 9 Digit Postal Code Matches, Address Does Not Match |
U | Address Information Unavailable, Domestic |
W | 9 Digit Postal Code Matches, Address Does Not Match |
X | Address and 9 Digit Postal Code Match |
Y | Address and 5 Digit Postal Code Match |
Z | 5 Digit Postal Code Matches, Address Does Not Match |
Appendix 18 - Transaction Response Code
| AUTH_RESP_CODE | DESCRIPTION | CATEGORY |
| 00 | Approval | CREDIT |
| 01 | Approval with id | CREDIT |
| 02 | Decline | CREDIT |
| 03 | Pickup Card | CREDIT |
| 04 | Referral | CREDIT |
| 05 | Does not resp | CREDIT |
| 06 | Call auth center | CREDIT |
| 07 | Declined | CREDIT |
| 08 | Do not honor | CREDIT |
| 09 | Error | CREDIT |
| 10 | Invalid acct | CREDIT |
| 11 | Invalid amt | CREDIT |
| 12 | Invalid prefix | CREDIT |
| 13 | Invalid pos | CREDIT |
| 14 | Invalid exp date | CREDIT |
| 15 | Invalid trans | CREDIT |
| 16 | Standin approval | CREDIT |
| 17 | Invalid state | CREDIT |
| 18 | Invalid message format | CREDIT |
| 19 | Invalid transaction | CREDIT |
| 20 | System error | CREDIT |
| 21 | Center closed | CREDIT |
| 22 | Dup transaction | CREDIT |
| 23 | Reversal not accepted | CREDIT |
| 24 | Reversal accepted | CREDIT |
| 25 | System busy | CREDIT |
| 26 | Referral | CREDIT |
| 27 | Referral center closed | CREDIT |
| 28 | Reversal | CREDIT |
| 29 | Sale auth edc | CREDIT |
| 30 | Request cancelled | CREDIT |
| 31 | Reversal not accepted | CREDIT |
| 32 | Reversal complete | CREDIT |
| 33 | Reversal rejected | CREDIT |
| 34 | Reversal acc cond | CREDIT |
| 35 | Service unavailable | CREDIT |
| 36 | Tech difficulties | CREDIT |
| 37 | Exceeded pin | CREDIT |
| 38 | nvalid cashback | CREDIT |
| 39 | Referral - issurer spec condition | CREDIT |
| 40 | Timeout | CREDIT |
| 41 | Error | CREDIT |
| 42 | Pick up card, special condition | CREDIT |
| 43 | Vip approval | CREDIT |
| 44 | Invalid transaction | CREDIT |
| 45 | Invalid amount | CREDIT |
| 46 | Invalid card number(non-existent) | CREDIT |
| 47 | No such issuer | CREDIT |
| 48 | Re-enter transaction | CREDIT |
| 49 | No action taken(cant backout prior) | CREDIT |
| 50 | Unable to locate record/account num | CREDIT |
| 51 | File temporarily unavailable | CREDIT |
| 52 | Pickup card(lost card) | CREDIT |
| 53 | Pickup card(stolen card) | CREDIT |
| 54 | Insufficient funds | CREDIT |
| 55 | No checking account | CREDIT |
| 56 | No savings account | CREDIT |
| 57 | Expired card | CREDIT |
| 58 | Incorrect pin | CREDIT |
| 59 | Trans not permitted to cardholder | CREDIT |
| 60 | Trans not permitted to terminal | CREDIT |
| 61 | Exceeds withdrawal amount limit | CREDIT |
| 62 | Restricted card | CREDIT |
| 63 | Activity count limit exceeded | CREDIT |
| 64 | Allowable number pin tries exceeded | CREDIT |
| 65 | Unable to locate previous message | CREDIT |
| 66 | Prev/orig repeat/rvrsl inconsistent | CREDIT |
| 67 | Invalid date | CREDIT |
| 68 | Cryptographic error in pin of cvv | CREDIT |
| 69 | Incorrect cvv | CREDIT |
| 70 | Unable to verify pin | CREDIT |
| 71 | No reason decline req acct verify | CREDIT |
| 72 | Issuer or switch inoperative | CREDIT |
| 73 | Cannot find institution or network | CREDIT |
| 74 | Violation of law | CREDIT |
| 75 | System malfunction | CREDIT |
| 76 | Forward to issuer | CREDIT |
| 77 | See exhibit for error listing | CREDIT |
| 78 | Void of captured item | CREDIT |
| 79 | Display of batch summary inquiry | CREDIT |
| 80 | Batch detail review | CREDIT |
| 81 | Batch control transaction | CREDIT |
| 82 | Invalid, tgn/cic not validated | CREDIT |
| 83 | Credit transaction | CREDIT |
| 84 | Capture of post authorization | CREDIT |
| 85 | Call telecheck | CREDIT |
| 86 | Invalid, host not available | CREDIT |
| 87 | Verification transaction | CREDIT |
| 88 | Test ok | CREDIT |
| 89 | Duplicate transaction | CREDIT |
| 90 | Transaction accepted | CREDIT |
| 91 | Transaction not accepted | CREDIT |
| 92 | Invalid account | CREDIT |
| 93 | Invalid pos indicator | CREDIT |
| 94 | Standin approval | CREDIT |
| 95 | Invalid state | CREDIT |
| 96 | Invalid message format | CREDIT |
| 97 | Reversal accepted | CREDIT |
| 98 | System busy | CREDIT |
| 99 | Unkown response | CREDIT |
| 00 | Approval | DEBIT |
| 01 | Approval with id | DEBIT |
| 02 | Decline | DEBIT |
| 03 | Pickup Card | DEBIT |
| 04 | Referral | DEBIT |
| 05 | Accepted | DEBIT |
| 06 | Not accepted | DEBIT |
| 10 | Invalid acct | DEBIT |
| 11 | Invalid amt | DEBIT |
| 12 | Invalid prefix | DEBIT |
| 13 | Invalid pos | DEBIT |
| 14 | Invalid exp date | DEBIT |
| 15 | Invalid trans | DEBIT |
| 16 | Standin approval | DEBIT |
| 17 | Invalid state | DEBIT |
| 18 | Invalid message format | DEBIT |
| 20 | System error | DEBIT |
| 21 | Center closed | DEBIT |
| 22 | Dup transaction | DEBIT |
| 24 | Reversal accepted | DEBIT |
| 25 | System busy | DEBIT |
| 30 | Request cancelled | DEBIT |
| 31 | Reversal not accepted | DEBIT |
| 32 | Reversal complete | DEBIT |
| 33 | Reversal rejected | DEBIT |
| 34 | Reversal acc cond | DEBIT |
| 35 | Reversal sys88 gen | DEBIT |
| 36 | Invalid pin | DEBIT |
| 37 | Exceeded pin | DEBIT |
| 38 | nvalid cashback | DEBIT |
| 40 | Timeout | DEBIT |
Appendix 19 - CVC2/CVV2 Result
Code | Description |
|---|---|
Y | CVC2/CVV2 Present |
Null | CVC2/CVV2 Not Present |
Appendix 20 - Debit Network
Download link here.
Appendix Download
| Outlet level MID | |
| Doing Business Address Name assigned to the Outlet MID | |
| Discretionary number setup on the Merchant Master | |
| Discretionary Number assigned to Outlet Level MID | Client Correspondence Flag must be set to a Y |
| 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* |