/
Marketplace BAMS Settlement File Data Dictionary
Marketplace BAMS Settlement File Data Dictionary
- Cecilia Do
Owned by Cecilia Do
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 – version 46 |
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 | 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 “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 | 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 | Utilizing Loaded Date (settlement date). |
| Card Type | varchar2 | 10 | Association that the transaction is sent to for processing. Ex. Visa, MC, etc. | 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 | Date group of transactions was settled | YYYYMMDD | |
| Authorization Code | varchar2 | 8 | 6 digit code assigned at the time card was authorized | 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 | +/- | ('+) = 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 | 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 | 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. | 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 | +/- | ('+) = 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. | Refer to Appendix 18 | |
| Convenience Fee Amount Sign | varchar2 | 1 | Available for merchants participating in Convenience Fee program | ||
| Convenience Fee Amount | Number | 9 | Available for merchants participating in Convenience Fee program | Available for merchants participating in Convenience Fee program Formatted as 999999.99 | |
| SubMerchant ID | varchar2 | 20 | Available for PSPs only | ||
| Soft Descriptor | varchar2 | 32 | Available for PSPs only | ||
| Bank Reference Number | varchar2 | 20 | *Client specific field not available for use* | ||
| 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 | ||
| Card Presence Indicator | varchar2 | 1 | |||
| Merchant Reference Number | varchar2 | 9 | Discretionary field sent by merchant | Available on all Front Ends 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 | +/- | ('+) = Sale (-) = Refund | Do NOT use for matching. Does not necessarily match uPay postback pmt_amt. |
| 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 Service Develop | varchar2 | 1 | Indicates type of commerce | 1 Electronic Commerce 2 In-Flight Commerce 5 Transponder-Initiated 6 Relationship Participant 7 Deferred Billing Indicator | |
| Visa Purchase Identifier Format | varchar2 | 1 | Specifies the format/type of additional identifying information for purchases, e.g. order or invoice number, free text | Do NOT use for matching. May see partial value for "sys_tracking_id", but unreliable. | |
| Visa Purchase Identifier | varchar2 | 25 | The Purchase Identifier information. | ||
| Visa Chip Condition Code | varchar2 | 1 | Code provides information about magnetic stripe-read transactions of VSDC cards at VSDC ATMs | It does not apply to VSDC transactions where the chip is read | |
| MC Security Protocol | varchar2 | 1 | Indicates the presence and type of security protocol present in the authorization process in support of UCAF | 2 Channel Encrypted 9 No Security Protocol | |
| MC Cardholder Authentication | varchar2 | 1 | Authentication indicates the type of Cardholder authentication used in the authorization process in support of UCAF | 0 UCAF data collection is not supported by the Merchant 1 UCAF data collection is supported by the Merchant, but UCAF data was not populated 2 UCAF data collection is supported by the Merchant, and UCAF data must be present 3 UCAF data collection is supported by the Merchant, and UCAF (MasterCard assigned Static Accountholder Authentication Value) data must be present | |
| 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 | |
| Transaction Country | varchar2 | 3 | Country the card is issued | 2500 characters. | |
| Transaction Charges Sign | varchar2 | 1 | +/- | ('+) = Sale (-) = Refund | |
| Transaction Charges | Number | 21 | *Omnipay only* Interchange charges per transaction | Formatted as 999999999999999999.99 | |
| Capture Method | varchar2 | 3 | |||
| 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 | ||
| User Data | varchar2 | 32 | *Note* use the User Data 2 field instead of User Data | Comprised of the XN02-XN06 PTS records | |
| Transaction Integrity Class | varchar2 | 2 | Associated with MasterCard transactions where the card brand is assigning a rating to the transaction based on the security and integrity of the transaction. | ||
| Assessments Sign | varchar2 | 1 | *Client specific field not available for use* | ||
| Assessments | Number | 17 | Formatted as 999999999999.9999 | *Client specific field not available for use* | |
| Service Charges Sign | varchar2 | 1 | *Client specific field not available for use* | ||
| Service Charges | Number | 17 | Formatted as 999999999999.9999 | *Client specific field not available for use* | |
| Interchange Rate Sign | varchar2 | 1 | *Client specific field not available for use* | ||
| Interchange Rate | Number | 20 | Formatted as 9999999999.999999999 | *Client specific field not available for use* | |
| Per Tran Fee Sign | varchar2 | 1 | *Client specific field not available for use* | ||
| Per Tran Fee | Number | 15 | Formatted as 999999999999.99 | *Client specific field not available for use* | |
| Mobile Indicator | varchar2 | 2 | Indicator that a transaction originated from the Ucomm Gateway | *Client specific field not available for use* | |
| User Data 2 | varchar2 | 145 | Discretionary data sent on transaction by the merchant | Comprised of the XN02-XN06 PTS records | |
| Posting Charge Description 1 | varchar2 | 65 | *Available for Omnipay data only* | ||
| Charge Type 1 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Tran Type 1 | varchar2 | 28 | *Available for Omnipay data only* | ||
| Service ID 1 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Fee Category 1 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Charge Amount 1 Sign | varchar2 | 1 | *Available for Omnipay data only* | ||
| Charge Amount 1 | Number | 20 | Formatted as 99999999999999999.99 | *Available for Omnipay data only* | |
| Posting Charge Description 2 | varchar2 | 65 | *Available for Omnipay data only* | ||
| Charge Type 2 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Tran Type 2 | varchar2 | 28 | *Available for Omnipay data only* | ||
| Service ID 2 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Fee Category 2 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Charge Amount 2 Sign | varchar2 | 1 | *Available for Omnipay data only* | ||
| Charge Amount 2 | Number | 20 | Formatted as 99999999999999999.99 | *Available for Omnipay data only* | |
| Posting Charge Description 3 | varchar2 | 65 | *Available for Omnipay data only* | ||
| Charge Type 3 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Tran Type 3 | varchar2 | 28 | *Available for Omnipay data only* | ||
| Service ID 3 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Fee Category 3 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Charge Amount 3 Sign | varchar2 | 1 | *Available for Omnipay data only* | ||
| Charge Amount 3 | Number | 20 | Formatted as 99999999999999999.99 | *Available for Omnipay data only* | |
| Posting Charge Description 4 | varchar2 | 65 | *Available for Omnipay data only* | ||
| Charge Type 4 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Tran Type 4 | varchar2 | 28 | *Available for Omnipay data only* | ||
| Service ID 4 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Fee Category 4 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Charge Amount 4 Sign | varchar2 | 1 | *Available for Omnipay data only* | ||
| Charge Amount 4 | Number | 20 | Formatted as 99999999999999999.99 | *Available for Omnipay data only* | |
| Posting Charge Description 5 | varchar2 | 65 | *Available for Omnipay data only* | ||
| Charge Type 5 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Tran Type 5 | varchar2 | 28 | *Available for Omnipay data only* | ||
| Service ID 5 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Fee Category 5 | varchar2 | 20 | *Available for Omnipay data only* | ||
| Charge Amount 5 Sign | varchar2 | 1 | *Available for Omnipay data only* | ||
| Charge Amount 5 | Number | 20 | Formatted as 99999999999999999.99 | *Available for Omnipay data only* | |
| Filler | 159 | 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.
| Field Name | Field Type | Field Length | Description | Notes | UCI 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. |
| 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 | 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 | Utilizing Loaded Date (settlement date). |
| Card Type | varchar2 | 10 | Association that the transaction is sent to for processing. Ex. Visa, MC, etc. | 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 | Date group of transactions was settled | YYYYMMDD | |
| Authorization Code | varchar2 | 8 | 6 digit code assigned at the time card was authorized | Authorization/approval code. | |
| Invoice/Trace ID | varchar2 | 20 | Discretionary 12 digit number sent on transaction by merchant | 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 | +/- | ('+) = 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 | 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 | Amount verified as available on a card for a transaction to occur | Formatted as 999999999.99 | As of , Authorization Amount matches Transaction Amount. |
| 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. | 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 | +/- | ('+) = 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 | |
| Convenience Fee Amount Sign | varchar2 | 1 | Available for merchants participating in Convenience Fee program | ||
| Convenience Fee Amount | Number | 9 | Available for merchants participating in Convenience Fee program | Available for merchants participating in Convenience Fee program Formatted as 999999.99 | |
| SubMerchant ID | varchar2 | 20 | Available for PSPs only | ||
| Soft Descriptor | varchar2 | 32 | Available for PSPs only | ||
| Bank Reference Number | varchar2 | 20 | *Client specific field not available for use* | ||
| 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 | ||
| Card Presence Indicator | varchar2 | 1 | |||
| 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) | 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 | +/- | ('+) = Sale (-) = Refund | Do NOT use for matching. Does not necessarily match uPay postback pmt_amt. |
| Total Auth Amount | varchar2 | 15 | Total Amount authorized for a transaction | ||
| 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 | ||
| User Data | varchar2 | 32 | *Note* use the User Data 2 field instead of User Data | Comprised of the XN02-XN06 PTS records | |
| Assessments Sign | varchar2 | 1 | *Client specific field not available for use* | +/- | |
| Assessments | Number | 17 | *Client specific field not available for use* | Formatted as 999999999999.9999 | |
| Service Charges Sign | varchar2 | 1 | *Client specific field not available for use* | +/- | |
| Service Charges | Number | 17 | *Client specific field not available for use* | Formatted as 999999999999.9999 | |
| Interchange Rate Sign | varchar2 | 1 | *Client specific field not available for use* | +/- | |
| Interchange Rate | Number | 20 | *Client specific field not available for use* | Formatted as 9999999999.999999999 | |
| Per Tran Fee Sign | varchar2 | 1 | *Client specific field not available for use* | +/- | |
| Per Tran Fee | Number | 15 | *Client specific field not available for use* | Formatted as 999999999999.99 | |
| Mobile Indicator | varchar2 | 2 | Indicator that a transaction originated from the Ucomm Gateway | *Client specific field not available for use* | |
| User Data 2 | varchar2 | 145 | Discretionary data sent on transaction by the merchant | Comprised of the XN02-XN06 PTS records | |
| Filler | 1092 | 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. |
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 pin 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 | 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 | 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 | Utilizing Loaded Date (settlement date). |
| Card Type | varchar2 | 10 | Association that the transaction is sent to for processing. Ex. Visa, MC, etc. | Refer to Appendix 2 | Corresponds to uPay postback card_type. |
| Network ID | varchar2 | 8 | Debit Network that processed the transaction | Refer to 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. | 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 | Date group of transactions was settled | YYYYMMDD | |
| Authorization Code | varchar2 | 8 | 6 digit code assigned at the time card was authorized | Authorization/approval code. | |
| Invoice/Trace ID | varchar2 | 20 | Discretionary 12 digit number sent on transaction by merchant | 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 | YYYYMMDD | Authorization date. |
| Transaction Amount Sign | varchar2 | 1 | +/- | ('+) = Sale (-) = Refund | Corresponds to uPay postback pmt_amt. |
| Transaction Amount | Number | 15 | Amount of the processed transaction | Formatted as 999999999999.99 | |
| 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 | +/- | ('+) = 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 | 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 | |
| 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 | Formatted as 999999999999.99 | |
| 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 | |
| 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 | The manor in which a transaction was processed (ex. Electronic, Manual, Swiped) | Refer to Appendix 14 | |
| Authorization Amount Sign | varchar2 | 1 | +/- | ('+) = Sale (-) = Refund | As of , Authorization Amount matches Transaction Amount. |
| 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. | 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 | +/- | ('+) = 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. | Refer to 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) | 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 | +/- | ('+) = Sale (-) = Refund | Do NOT use for matching. Does not necessarily match uPay postback pmt_amt. |
| 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 | 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. |
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 | 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. |
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 | 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. |
Appendices
From BAMS documentation.
Appendix 1 - Hierarchy Levels
Code | Description |
|---|---|
120 | Outlet/Member |
100 | Chain/Subgroup |
90 | Corporate/Group |
60 | Agent |
50 | Bank |
40 | Business (Owner) |
20 | Marker Bank |
Appendix 2 - Card Type
North Domestic
Code | Description |
|---|---|
00000 | Not Specified |
00001 | MasterCard |
00002 | Visa |
05601 | STAR Signature Debit |
00003 | Discover |
00004 | Diners (FDMS Funds) |
00005 | Diners Pass through |
00006 | Amex |
00007 | JCB |
00008 | Amex Acquiring |
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 (Not check services) |
00021 | Telecheck (Not check services) |
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 | APM |
00053 | Local Payments |
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 |
Ominpay Specific
Code | Description |
|---|---|
000 | N/A |
001 | EUROPAY |
002 | MASTERCARD |
003 | VISA |
004 | AMEX |
005 | PROPRIETARY |
006 | DINERS CLUB |
007 | JCB |
020 | MDS |
022 | UKDM |
100 | INTRABANK |
102 | AUS DOM. DEBIT |
103 | AUS DOM. CREDIT |
104 | PAGOBANCOMAT |
105 | CHINA UNION PAY |
106 | PRIVATE LABEL |
107 | LOYALTY |
111 | ELV |
112 | PAYPAL |
113 | |
114 | AUSTRIA DD |
115 | SPAIN DD |
116 | NETHERLANDS DD |
117 | UK DD |
118 | FRANCE DD |
119 | ITALY DD |
120 | BELGIUM DD |
121 | RTBT GERMANY |
122 | RTBT NETHERLANDS |
123 | BANKSERV MC |
124 | BANKSERV VISA |
125 | BANKSERV AMEX |
126 | BANKSERV DINERS |
200 | ONUS |
201 | BCMC |
999 | ALL |
Appendix 3 - Currency Code
| CURRENCY_CODE | COUNTRY_NAME | CURRENCY_NAME | CURRENCY_ABV |
|---|---|---|---|
| 000 | UNKNOWN | UNKNOWN | UNK |
| 008 | Albania | Lek | ALL |
| 012 | Algeria | Algerian Dinar | DZD |
| 031 | Azerbaijan | Azerbaijanian Manat | AZN |
| 032 | Argentina | Argentine Peso | ARS |
| 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 | Bhutan Ngultrum | BTN |
| 068 | Bolivia, Plurinational State of | 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 | Cambodian Riel | KHR |
| 124 | Canada | Canadian Dollar | CAD |
| 132 | Cape Verde | 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 |
| 157 | Offshore China | Renminbi | CNH |
| 158 | Taiwan, Province of China | Dollar | TWN |
| 170 | Colombia | Colombian Peso | COP |
| 174 | Comoros | Comoro Franc | KMF |
| 175 | Mayotte | EURO | MYT |
| 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 |
| 239 | South Georgia and the South Sandwich Islands | British Pounds | SGS |
| 242 | Fiji | Fiji Dollar | FJD |
| 248 | Aland Islands | EURO | ALA |
| 262 | Djibouti | Djibouti Franc | DJF |
| 270 | Gambia | Dalasi | GMD |
| 275 | Palestine, State of | Israeli New Sheqal, Jordanian Dinar and U.S. Dollar | PSE |
| 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 |
| 360 | Indonesia | Indonesian Rupiah | IDR |
| 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 | 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 | Macao | Macao Pataca | MOP |
| 454 | Malawi | Kwacha (Malawi) | MWK |
| 458 | Malaysia | Malaysian Ringgit | MYR |
| 462 | Maldives | Maldive Rufiyaa | MVR |
| 470 | Malta | Maltese Lira | MTL |
| 478 | Mauritania | Ouguiya | MUR |
| 480 | Mauritius | Mauritius Rupee | MUR |
| 484 | Mexico | Mexican Peso | MXN |
| 496 | Mongolia | Mongolian Tugrik | MNT |
| 498 | Moldova, Republic of | Moldovan Leu | MDA |
| 504 | Morocco | Moroccan Dirham | MAD |
| 508 | Mozambique | Metical | MZM |
| 512 | Oman | Rial Omani | OMR |
| 516 | Namibia | Namibian Dollar | NAD |
| 524 | Nepal | Nepalese Rupee | NPR |
| 531 | Curacao | Guilder | CUW |
| 532 | The Netherlands Antilles/Curacao/Sint Maarten | Netherlands Antillian Guilder | ANG |
| 533 | Aruba | Aruban Guilder | AWG |
| 534 | Sint Maarten | Guilder | SXM |
| 535 | Bonaire, Sint Eustatius and Saba | US Dollar | BES |
| 548 | Vanuatu | Vatu | VUV |
| 554 | New Zealand | New Zealand Dollar | NZD |
| 558 | Nicaragua | Nicaraguan Cordoba Oro | NIO |
| 566 | Nigeria | Naira | NGN |
| 578 | Norway | Norwegian Kroner | NOK |
| 583 | Micronesia, Federated States of | US Dollar | FSM |
| 586 | Pakistan | Pakistan Rupee | PKR |
| 590 | Panama | Panama Balboa | PAB |
| 591 | Panama | Panama Balboa | PAB |
| 598 | Papua New Guinea | Papua New Guinea Kina | PGK |
| 600 | Paraguay | Paraguayan Guarani | PYG |
| 604 | Peru | Peruvian Nuevo Sol | PEN |
| 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 |
| 652 | Saint Barthelemy | EURO | BLM |
| 654 | Saint Helena, Ascension and Tristan Da Cunha | Saint Helena Pound | SHP |
| 663 | Saint Martin (French Part) | EURO | MAF |
| 678 | Sao Tome and Principe | Sao Tome and Principe Dobra | STD |
| 682 | Saudi Arabia | Saudi Riyal | SAR |
| 688 | Serbia | Serbian dinar | SRB |
| 690 | Seychelles | Seychelles Rupee | SCR |
| 694 | Sierra Leone | Sierra Leone Leone | SLL |
| 702 | Singapore | Singapore Dollar | SGD |
| 703 | Slovakia | Slovak Koruna | SSK |
| 704 | Vietnam | Dong(Vietnam) | VND |
| 705 | Slovenia | Tolar | SIT |
| 706 | Somalia, Federal Republic of | Somali Shilling | SOS |
| 710 | South Africa | Rand | ZAR |
| 716 | Zimbabwe | Zimbabwe Dollar | ZWD |
| 728 | South Sudan | South Sudanese Pound | SSP |
| 740 | Suriname | Surinam Guilder | SRG |
| 748 | Swaziland | 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 | UGX |
| 807 | Macedonia | Denar | MKD |
| 818 | Egypt | Egyptian Pound | EGP |
| 826 | United Kingdom | Pound Sterling | GBP |
| 831 | Guernsey | Pound | GGY |
| 832 | Jersey | Pound | JEY |
| 833 | Isle of Man | Pound | IMN |
| 834 | Tanzania, United Republic of | Tanzanian Shilling | TZS |
| 840 | United States/Bonaire, Sint Eustatius, and Saba/Occupied Palestinian Territory | U.S. Dollar | USD |
| 858 | Uruguay | Uruguayan Peso | UYU |
| 860 | Uzbekistan | Uzbekistan Som | 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 |
| 933 | Belarus | Belarussian Ruble | BYN |
| 934 | Turkmenistan | Turkmenistan New Manat | TMT |
| 936 | Ghana | Ghanaian Cedi | GHS |
| 937 | Venezuela | Venezuelan Bolivar Fuerte | VEF |
| 938 | Sudan | Sudanese Pound | SDG |
| 941 | Serbia | Serbian Dinar | RSD |
| 943 | Mozambique | Mozambique Metical | MZN |
| 944 | Azerbaijan | Azerbaijanian Manat | AZN |
| 946 | Romania | Leu (Romania) | RON |
| 949 | Turkey | Turkish Lira | TRL |
| 950 | Central African Republic/Cameroon | CFA Franc BEAC | XAF |
| 951 | Anguilla | East Caribbean Dollar | XCD |
| 952 | Benin | CFA Franc BCEAO | XOF |
| 953 | French Polynesia | Central French Polynesian Franc | XPF |
| 967 | Zambia | New Zambian Kwacha | ZMW |
| 968 | Suriname | Surinam Dollar | SRD |
| 969 | Madagascar | Malagasy Ariary | MGA |
| 971 | Afghanistan | Afghani | AFA |
| 972 | Tajikistan | Somoni | TJS |
| 973 | Angola | Kwanza | AOK |
| 974 | Belarus | Belarusian Ruble | BYR |
| 975 | Bulgaria | Lev | BGL |
| 976 | Congo, Democratic Republic of the | Congolese Franc | CDF |
| 977 | Bosnia and Herzegovina | 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 |
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 |
|---|---|
| 001 | Entered |
| 002 | MERCHANT DESCRIPTOR MISSING OR INFORMATION INVALID |
| 003 | Error |
| 005 | loaded |
| 006 | Matched |
| 007 | BATCH RECORD MISSING OR INFORMATION INVALID |
| 008 | Released |
| 009 | DETAIL RECORD BYPASSED - BAD MERCHANT OR DESCRIPTOR |
| 01 | MERCHANT RECORD MISSING OR INFORMATION INVALID |
| 010 | Unposted |
| 011 | TRANSACTION CODE INVALID OR NOT ENTITLED FOR CARD PROD |
| 012 | Suppressed |
| 013 | Purged |
| 02 | MERCHANT DESCRIPTOR MISSING OR INFORMATION INVALID |
| 03 | INVALID RECORD IDENTIFICATION |
| 050 | Chargebacked |
| 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) |
| 200 | Card not in BIN tab. |
| 201 | Service not defined |
| 202 | Service not assigned |
| 203 | Inw. fees not found |
| 204 | Out. fees not found |
| 205 | Fees not found |
| 206 | Luhn check failed |
| 207 | Destination missing |
| 208 | Invalid POS code |
| 209 | No service contract |
| 21 | BNB PRIVATE LABEL BAD CREDIT PLAN |
| 210 | Batch not reconciled |
| 211 | Client not Found |
| 212 | No posting inst. |
| 213 | No account record |
| 214 | GL Failed |
| 215 | Wrong Term. Catg. |
| 216 | Wrong CardNo length |
| 217 | Zero Value |
| 218 | Contract Closed |
| 219 | DCC Mismatch |
| 22 | AUTH DECLINED - DELINQUENT ACCT, OVER CRED LIMIT, ETC |
| 220 | No Presentment |
| 221 | Device not found |
| 222 | Invalid DCC Format |
| 223 | No Payment Trans |
| 224 | Invalid trans date |
| 225 | Invalid Contract |
| 227 | Future Tran Date |
| 228 | Large Value |
| 229 | Late Presentment |
| 23 | AUTH DECLINED - LOST OR STOLEN CARD |
| 230 | Auth code required |
| 231 | Invalid Card Status |
| 232 | Invalid Acct Status |
| 233 | Invalid Contr Status |
| 234 | No posting inst. Ph1 |
| 236 | Fee Rule IRD empty |
| 237 | Invalid MCC |
| 238 | Invalid Amex SE No |
| 239 | Invalid Card Prefix |
| 24 | AUTH REFERRAL |
| 240 | Inter not allowed |
| 242 | Invalid Merch Detail |
| 243 | Invalid AddendumData |
| 244 | Missing Service Tel |
| 245 | Reference not found |
| 246 | Invalid CVC2 |
| 247 | Invalid AVS |
| 248 | Invalid RCC |
| 249 | Invalid Cash Tran |
| 25 | FOREIGN DETAIL INVALID - NON-NUMERIC DOLLAR AMOUNT |
| 251 | Inv. Acq Floor Limit |
| 252 | Inv. Mer Floor Limit |
| 253 | Inv. Auth Method |
| 254 | Inv. HC File Size |
| 255 | Inv. Cashback Amt |
| 256 | Inv. Acq Cash FL |
| 257 | Inv. Merch Cash FL |
| 259 | Missing company name |
| 26 | FOREIGN DETAIL INVALID - INCORRECT CURRENCY CODE |
| 260 | Invalid Product ID |
| 264 | Invalid Card Expiry |
| 265 | Invalid Trans Time |
| 266 | Invalid Payment Type |
| 267 | Inval Bank Sort Code |
| 268 | Invalid Acct Number |
| 269 | Inv. Acct Owner Name |
| 27 | DUPE EDIT |
| 270 | Invalid Tran ID |
| 271 | Invalid Card No |
| 272 | Invalid RT Flag |
| 273 | SMS flag not Maestro |
| 276 | Original not found. |
| 28 | INVALID TRANSACTION AMOUNT |
| 280 | No bin override |
| 281 | Invalid CBDIP region |
| 29 | INVALID TRANSACTION AMOUNT |
| 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 |
| 300 | Suspected fraud |
| 301 | Confirmed fraud |
| 302 | No fraud |
| 303 | Fraud bank loss |
| 304 | Fraud merchant loss |
| 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 |
| 400 | Rejected Payment |
| 401 | Cancelled Payment |
| 402 | Payment Trans Back |
| 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 |
| 53 | INVALID TRANSACTION AMOUNT |
| 54 | INVALID TRANSACTION AMOUNT |
| 55 | INVALID TRANSACTION AMOUNT |
| 56 | INVALID TRANSACTION AMOUNT |
| 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) |
| 8O | INVALID TRANSACTION AMOUNT |
| 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) |
| 8Z | INVALID TRANSACTION AMOUNT |
| 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 |
| s | Acq BIN not found |
Appendix 7 - Entry Mode
Code | Description |
|---|---|
00 | Terminal Not Used/Hardcopy |
01 | Manual/Key Entered |
02 | Magnetic Stripe Read – Track 2 Only |
03 | Bar Code Read |
04 | OCR Read |
05 | ICC Read – CVV Data Reliable |
06 | Magnetic Stripe Read – Track 1 Only |
07 | Pan Auto Entry Via Contactless Chip |
08 | Card Present Defective Mag Stripe Cannot Be Read. |
10 | Credential on File |
30 | Unspecified or Unknown |
31 | PIN Entry Capable |
32 | POS Device Not PIN Entry Capable |
38 | PIN Capable PINpad Not Working |
39 | PIN Verified by POS Device |
79 | Key Entered Input |
80 | Magnetic Stripe Unaltered – As Fallback to chip |
81 | Electronic Commerce Transaction |
82 | Mobile Commerce (mCommerce) |
83 | RFID (Radio Frequency Identification Indicator - Chip |
85 | Chip Fallback |
90 | CVV Qualified Mag Stripe Read |
91 | PAN Auto Entry via Contactless Magnetic Stripe |
92 | Batch Authorizations |
93 | Batch Authorization Cash Access |
94 | Biometrics |
95 | ICC Read – CVV Data Unreliable |
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 - Authorization Response Code
Download link here.
Appendix 19 - CVC2/CVV2 Result
Code | Description |
|---|---|
Y | CVC2/CVV2 Present |
Null | CVC2/CVV2 Not Present |
Appendix 20 - Debit Network
Download link here.