Card Transaction File
This is an extension fileThis file is an extension of the master Posted Transaction File and is meant to provide additional data points for card transactions. A single event will appear in both files and share the same
TransactionId
.
Card Transaction File Definition
The Card Transaction File is created by Helix on a daily basis. It has the following properties:
- Fixed-length
- ANSI encoded
- Line endings are Windows-style CarriageReturn + LineFeed (
\r\n
, or0x0D0A
) - File will be available in the relative directory of
/PostedTransaction
- File name follows a specific, case-sensitive pattern of:
yyyyMMddhhmm_DEBITCARDTRANSACTION.TXT
Format Disclaimer
Helix reserves the right to append new field(s) to the end of any Header or Content line without notice. This is to allow new data points to be added as needed in a timely fashion.Implementation Note
Your code should be written such that unexpected characters after the "last" field but prior to the end of each line should be ignored. That is, if the file is documented as being 872 bytes per line, receiving a file with 984 bytes per line should not disrupt your processing. This applies to both Header and Content lines.File Name Disclaimer
The date in file name should be used as a guideline for human eyes only. Any date-related programmatic dependencies should rely on theFileCreatedDate
orFileEffectiveDate
contained within the header line of each file, as these will be precise to the second and will be in the appropriate timezone.
Header Row
Property | Data Type (Length) | Alignment | Start Position | Description |
---|---|---|---|---|
Record Type | string (1) | Left | 1 | The flag for the header row. Will always be |
File Name | string (50) | Left | 2 | The name of this request file excluding path. |
Record Count | integer (10) | Right | 5 | The number of records represented within the file. This field is zero-padded on the left side. |
File Created Date | datetime (34) | Left | 62 | The date the file was created. Follows same format as API. |
File Effective Date | datetime (34) | Left | 96 | The date to which the data in the file pertains. Follows same format as API. |
Content Row
Property | Data Type (Length) | Alignment | Start Position | Description |
---|---|---|---|---|
Transaction ID | long integer (19) | Right | 1 | The Helix-assigned unique ID for the transaction. This field is zero-padded on the left side. |
Master ID | long integer (19) | Right | 20 | The unique identifier for a group of related transactions. This field is zero-padded on the left side. |
Card ID | integer (10) | Right | 39 | The unique identifier for the card that the transaction occurred against. This field is zero-padded on the left side. |
PAN Last Four | string (4) | Left | 49 | The rightmost four digits of the 16-digit card number. |
Cardholder First Name | string (64) | Left | 53 | The first name of the card holder. |
Cardholder Middle Name | string (64) | Left | 117 | The middle name of the card holder. |
Cardholder Last Name | string (128) | Left | 181 | The last name of the card holder. |
Card Acceptor Location | string (25) | Left | 309 | The location of the merchant where the transaction originated. |
Card Acceptor City | string (13) | Left | 334 | The city of the merchant where the transaction originated. |
Card Acceptor State | string (2) | Left | 347 | The two character state code of the merchant where the transaction originated. |
Card Acceptor Zip | string (9) | Left | 349 | The nine digit postal code of the merchant where the transaction originated. |
Retrieval Reference Number | string (12) | Left | 358 | The Retrieval Reference Number (Field #37 from the ISO-8583 specification) as defined by the network provider. Useful when interfacing with the network provider's support tools or staff. |
System Trace Audit Number | string (6) | Left | 370 | The System Trace Audit Number (Field #11 from the ISO-8583 specification) as defined by the network provider. Useful when interfacing with the network provider's support tools or staff. |
Merchant ID | string (15) | Left | 376 | The Merchant Identifier (Field #42 from the ISO-8583 specification) as defined by the network provider. Useful to help identify a specific merchant uniquely. |
Subtype Code | string (6) | Left | 391 | The Merchant Category Code of the merchant where the transaction originated. Categorizes merchants with similar lines of business together. |
Merchant Group Code | string (6) | Left | 397 | The Merchant Group Code of the merchant where the transaction originated. This is a higher-level grouping construct for various Merchant Category Codes that all belong to the same "group" of businesses. Merchant Group Codes |
Terminal ID | string (15) | Left | 403 | The identifier of the terminal at the merchant where the transaction originated. |
Cashback Amount | int (10) | Right | 418 | The amount of cash given to the user as part of the transaction. This field is zero-padded on the left side and two decimals will be assumed, e.g., |
Surcharge Amount | int (10) | Right | 428 | The amount of the surcharge applied as part of the transaction. This field is zero-padded on the left side and two decimals will be assumed, e.g., |
Unverified Deposit Amount | int (10) | Right | 438 | The amount of the check deposit for this transaction. This field is zero-padded on the left side and two decimals will be assumed, e.g., |
Cash Deposit Amount | int (10) | Right | 448 | The amount of cash deposited for this transaction. This field is zero-padded on the left side and two decimals will be assumed, e.g., |
ATM Network Indicator | string (3) | Left | 458 | The network from which the transaction was acquired. See ATM Network Indicators for more information. |
Network Provider Type ID | int (1) | Left | 461 | The id of card's network provider.
|
Transaction Fee Amount | integer (10) | Right | 462 | The Total Transaction Fee Amount (Field #28 from the ISO-8583 specification). Contains the surcharge amount. |
Settlement Fee Amount | integer (10) | Right | 472 | The Settlement Fee Amount (Field #29 from the ISO-8583 specification). Contains the surcharge amount in the issuer's currency. |
Additional Fees CCA | integer (10) | Right | 482 | |
Additional Fees ICA | integer (10) | Right | 492 | |
Message Type Indicator | string (4) | Left | 502 | The four-digit message type identifier from the original request message. |
Output Message Type Indicator | string (4) | Left | 506 | The four-digit message type identifier from the response message. |
Output Response Code | string (2) | Left | 510 | The two-digit status code from the response message sent by Helix. |
Acquirer Institution Country Code | string (3) | Left | 512 | 3 digit numeric code for the country where the acquiring institution is located. |
Authorization Identification Response | string (12) | Left | 515 | The authorization code for the transaction (Field #38 from the ISO-8583 specification). |
Response Code | string (2) | Left | 527 | The code that defines the disposition of a message when present in a response, advice, or reversal.
|
PIN Validation Code | string (1) | Left | 529 | Indicates whether the entered PIN was Valid (1). |
Additional Amounts Purchase | integer (10) | Right | 530 | The amount of the partial pay. This field is zero-padded on the left side, and two decimals will be assumed. e.g.: |
Additional Amounts Gratuity | integer (10) | Right | 540 | The amount of gratuity provided when the transaction occurred. This field is zero-padded on the left side, and two decimals will be assumed. e.g.: |
Advice Originator Code | string (1) | Left | 550 | (Field #60.2 - Advice Reason Codes, Position 1, from the ISO-8583 specification) |
Advice Reason Code | string (1) | Left | 551 | The identifying reason for an advice and/or reversal. |
Privately Definted Data Issuer Network ID Code | string (3) | Left | 552 | 3 digit alpha code identifying the issuer network (This is separate from the acquirer network code) |
Privately Defined Data Additional Transaction Element Fallback Indicator | string (1) | Left | 555 | The fallback indicator (Field #63.4, Position 5 from the ISO-8583 specification). Indicates whether the transaction was processed as magnetic stripe even though the card and terminal are EMV capable. |
Privately Defined Data Processing Flag Special Transaction Indicator | string (1) | Left | 556 | The special transaction indicator (Field #63.7, Position 1 from the ISO-8583 specification).
|
Privately Defined Data Processing Flag ISA Indicator | string (1) | Left | 557 | Visa International Service Assessment (ISA) Indicator (Field #63.7, Position 2 from the ISO-8583 specification), used to indicate whether a transaction is single or multi-currency.
|
Privately Defined Data Processing Flag Partial Auth Indicator | string (1) | Left | 558 | Transaction eligibility for Partial Authorization Indicator (Field #63.7, Position 3 from the ISO-8583 specification).
|
Privately Defined Data Risk Data Score Source | string (1) | Left | 559 | (Field #63.8, Position 1 from the ISO-8583 specification)
|
Privately Defined Data Risk Data Score Value | string (4) | Left | 560 | Numeric score generated by Falcon ranging from |
Privately Defined Data Risk Data Response Code | string (1) | Left | 564 | Response code generated by Falcon Expert (Field #63.8, Position 6 from the ISO-8583 specification)
|
Privately Defined Data Risk Data Falcon Reason 1 | string (2) | Left | 565 | Falcon Reason 1 (Field #63.8, Positions 7-8 from the ISO-8583 specification)
|
Privately Defined Data Risk Data Falcon Reason 2 | string (2) | Left | 567 | Falcon Reason 2 (Field #63.8, Positions 9-10 from the ISO-8583 specification). See example values in |
Privately Defined Data Risk Data Falcon Reason 3 | string (2) | Left | 569 | Falcon Reason 3 (Field #63.8, Positions 11-12 from the ISO-8583 specification). See example values in |
Privately Defined Data Risk Data Visa Risk Score | string (2) | Left | 571 | A value that indicates the degree of risk associated with the transaction. Higher values indicate higher authorization risk. Valid values: 01-99, blank if card is in fraud monitoring or data is not present. (Field #63.8, Positions 13-14 from the ISO-8583 specification). |
Privately Defined Data Risk Data Visa Risk Reason | string (2) | Left | 573 | A code that represents the logic behind the |
Privately Defined Data Risk Data Visa Risk Condition Code 1 | string (2) | Left | 575 | Contains a value relative to a high-risk Compromised Account Management System (CAMS) event. (Field #63.8, Positions 17-18 from the ISO-8583 specification). |
Privately Defined Data Risk Data Visa Risk Condition Code 2 | string (2) | Left | 577 | Contains the Compromised Event Reference (CER) ID assigned to a significant CAMS event. (Field #63.8, Positions 19-20 from the ISO-8583 specification). |
Privately Defined Data Risk Data Visa Risk Condition Code 3 | string (2) | Left | 579 | Reserved for future release |
Privately Defined Data Risk Data VAA Condition Code 1 Rank | string (2) | Left | 581 | Grouping value assigned to VAA Risk Condition Code 1. (Field #63.8, Position 23 from the ISO-8583 specification).
|
Privately Defined Data Risk Data RTD Result Code | string (1) | Left | 583 | The Real Time Decisioning result code. (Field #63.8, Position 24 from the ISO-8583 specification)
|
Privately Defined Data Risk Data Travel Status Indicator | string (1) | Left | 584 | Describes the cardholder's travel status. (Field #63.8, Position 34 from the ISO-8583 specification)
|
Text Info | string (255) | Left | 585 | Contents will vary based on ISO message type. |
Track 2 Data Service Code | string (3) | Left | 840 | The Service Code encoded on Track 2 of the magnetic stripe |
Card Acceptor Terminal Identification | string (8) | Left | 843 | The identification code of the device at the merchant that accepted the card information (Field #41 from the ISO-8583 specification). |
CVV2 Presence Indicator | string (1) | Left | 851 | CVV2 Presence Indicator (Field #123, Usage 3, Position 3 from the ISO-8583 specification).
|
CVV2 Result | string (1) | Left | 852 | CVV2 Result (Field#123, Usage 3, Position 9 from the ISO-8583 specification).
|
Token | string (19) | Left | 853 | Payment Account Reference Number (PAR) with a maximum length of 29. This field only applies if |
Token Assurance Level | string (2) | Left | 872 | Cardholder Verification Method. This field only applies if
|
Digital Wallet Token Requestor Type ID | integer (10) | Right | 874 | Digital Commerce Indicator. This field only applies if
|
Token Expiration Date | string (4) | Left | 884 | The year and month the token expires (YYMM). This field only applies if |
Payment Account Reference Number | string (29) | Left | 888 | The Payment Account Reference Number |
Merchant Category Code | string (4) | Left | 917 | The exact Merchant Category Codes value received from the network provider. |
Card Acceptor Region Code | string (2) | Left | 921 | The region code of the card acceptor (Field #43, Positions 37-38 from the ISO-8583 specification). |
Card Acceptor Country Code | string (2) | Left | 923 | The country code of the card acceptor (Field #43, Positions 39-40 from the ISO-8583 specification). |
National Point Of Service Condition Terminal Unattended | string (1) | Left | 925 | Terminal Unattended (Field #58, Position 1 from the ISO-8583 specification).
|
National Point Of Service Condition Terminal Operator | string (1) | Left | 926 | Terminal Operator (Field #58, Position 2 from the ISO-8583 specification).
|
National Point Of Service Condition Terminal Premises | string (1) | Left | 927 | Terminal Premise (Field #58, Position 3 from the ISO-8583 specification).
|
National Point Of Service Condition Card Presentation | string (1) | Left | 928 | Presentation Type (Field #58, Position 4 from the ISO-8583 specification).
|
National Point Of Service Condition Card Presence | string (1) | Left | 929 | Card Presence (Field #58, Position 5 from the ISO-8583 specification).
|
National Point Of Service Condition Card Retention | string (1) | Left | 930 | Card Retention (Field #58, Position 6 from the ISO-8583 specification).
|
National Point Of Service Condition Card Transaction | string (1) | Left | 931 | Card Transaction (Field #58, Position 7 from the ISO-8583 specification).
|
National Point Of Service Condition Security Condition | string (1) | Left | 932 | Security Condition (Field #58, Position 8 from the ISO-8583 specification).
|
National Point Of Service Condition Terminal Type | string (2) | Left | 933 | Terminal Type (Field #58, Positions 9-10 from the ISO-8583 specification).
|
National Point Of Service Condition Terminal Entry Capability | string (1) | Left | 935 | Terminal Entry Capability Mode (Field #58, Position 11 from the ISO-8583 specification).
|
Point Of Service PAN Entry Mode | string (2) | Left | 936 | The Point of Service PAN Entry Mode (Field #22, Positions 1-2 from the ISO-8583 specification). Useful when determining how the PAN was entered.
|
Point Of Service PIN Entry Mode | string (1) | Left | 938 | The Point of Service PIN Entry Mode (Field #22, Position 3 from the ISO-8583 specification). Useful when determining how the PIN was entered.
|
Privately Defined Data Transaction Level Credential On File Indicator | string (1) | Left | 939 | Credential On File Indicator (Field #63.8, Position 2 from the ISO-8583 specification). Indicates whether a Credential on File is present.
|
Privately Defined Data Transaction Level Cryptocurrency Purchase Indicator | string (1) | Left | 940 | Cryptocurrency Purchase Indicator (Field #63.8, Position 5 from the ISO-8583 specification). Identifies Visa transactions used to purchase cryptocurrency.
|
AVS Result | string (1) | Left | 941 | Address Verification Service Result
|
Card Control Tag | string (50) | Left | 942 | Tag of the card control that was evaluated against this authorization. Via IsoMessage.CardControlId. |
Card Control Rule Tag | string (50) | Left | 992 | Tag of the rule that matched this authorization. Via IsoMessage.CardControlRuleId. |
Card Control Rule Source | string (8) | Left | 1042 | Source of the card control rule that matched this authorization. Possible values:
|
Card Control Result | integer (1) | Left | 1050 | Result of executing the matched card control rule. Possible values: |
In Auth Helix Result | integer (2) | Right | 1051 | Helix result from In Auth processing. Possible values: |
In Auth Program Result | integer (2) | Right | 1053 | Program result from In Auth processing. Possible values: |
In Auth Program Response Duration in MS | integer (10) | Right | 1055 | Program response duration in milliseconds for In Auth. |
Tap To Phone Indicator | string (4) | Right | 1065 | Tap to Phone Indicator result. Possible values: |
Privately Defined Data Risk Data Mastercard Fraud Score | string (3) | Left | 1079 | Available if client participates in a Mastercard or non-Visa Network Fraud Scoring service. Valid value: 000-999, XXX, or ZZZ
|
Privately Defined Data Risk Data Mastercard Risk Condition 1 | string (2) | Left | 1082 | Available if client participates in Mastercard Fraud Scoring service. Values: |
Privately Defined Data Risk Data Mastercard Risk Condition 2 | string (2) | Left | 1084 | Available if client participates in Mastercard Fraud Scoring service. Values: |
Privately Defined Data Risk Data Mastercard Fraud Score Reason | string (2) | Left | 1086 | Available if client participates in Mastercard Fraud Scoring service. Values: |
Context ID | string (36) | Right | 1088 | Guid Correlation Identifier for card message (aka |
Take me to the Example Card Transaction File
Updated 8 days ago