Support Services

Dex - Transactions Export Fields

 

Default FieldDescription
Transaction IDA 36-character code that uniquely identifies the transaction.
Received DateThe date when of the transaction received (e.g., March 31, 2018 04:23 PM). If the location has not designated a timezone, Dex defaults to Pacific Standard Time (PST).
Received timeThe time when of the transaction received (e.g., March 31, 2018 04:23 PM). If the location has not designated a timezone, Dex defaults to Pacific Standard Time (PST).
StatusThe status of the transaction. The following values are supported:
In Progress - The transaction was received and is awaiting origination (echecks) or settlement (credit cards). If authorized, this field also displays the Status, Response, Return, and/or Settlement Code that returned with the response.
Completed - The transaction was funded to or from the merchant's bank account.
Failed - The transaction was declined, rejected, voided, or failed verification for reasons detailed in the Status, Response, Return, and/or Settlement Code that returned with the response.
Customer IDThe Company Name or First and Last Name of the customer associated with this transaction. If applicable, this field also includes the merchant-specified Consumer ID.
Bill To First NameThe customer's first name.
Bill To Last NameThe customer's last name.
Company NameThe name of the customer's company.
Wallet IDA merchant-defined description or reference ID related to the transaction.
Order IDIf supplied, the merchant-defined Order Number and Reference ID included with the transaction. These parameters can include anything from invoice IDs, ticket numbers, or P.O. Box numbers.
AmountDisplays the transaction amount, only the number(s) and/or decimal point.
ActionDex supports the following transaction types:
Debit/Sale
Auth
Refund/Credit
Force/External Auth
Verify
Balance Inquiry
NOTE: The Auth action also displays either a D or C to indicate if the transaction was a Debit or Credit.
MethodThe card brand used for this transaction. This parameter displays the logo of the following supported card brands:
American Express
Discover
MasterCard
Visa
Diners
JCB
Last 4The last four digits of the customer's credit card
Authorization InfoDisplays the authorization result. If the transaction was approved, this column displays the Authorization Number and the Approval Code. If the transaction was declined, an "Auth Decline" message displays. If the authorization is still in progress, the column remains blank.
SourceThe terminal hardware, software, or integration method used to connect to Forte.
Location IDThe ID of the merchant location that processed the transaction.
Wallet TypeThe Alternative Method of Payment used. i.e. Apple Pay, Google Pay, Samsung Pay, Pay Pal
Location NameThe name of the merchant location that processed the transaction.

At Merchant Level will be displayed by default:
Bank Account VerificationDisplays the P-codes associated with a Validate Plus transaction. The following options display:
P10 – No Match
P15 – High Risk
P20 – Negative Reports
P21 – No Negative Reports
P23 – Invalid Account/ABA Number
P40 – No Negative Information
P41 – Negative Information
P50 – No Information
P60 - Match
P70 - Validated
P71 – Low Risk Approval
P73 – Medium-Risk Approval
P75 – Conditional Match
P80 – Vendor Busy
P90 – Preauthorization Vendor Unavailable
P91 - Preauthorization Vendor Error
P92 - Preauthorization Server Unavailable
P93 – Error P94 – Invalid Routing Number 
P94 – Invalid Account Number
P95 - Bad Account
Principal (At Merchant Level)The authorized amount of a transaction, which includes taxes (if applicable) but not service fees.
Service Fee (At Merchant Level)The service/convenience fee for the transaction. Service fees are either a percentage of the principal or a set amount.



 

Optional FieldDescription
Debit or CreditType of the card used on the transaction - Debit (D) or Credit (C)
Tax AmountDisplays the transaction tax amount, only the number(s) and/or decimal point
Account CodeThe accounting code entered for procurement cards
Account TypeThe account type - Checking or Savings account.
Attempt NumberNumber of attempts to execute the transaction
AVS MethodAddress Verification Services method used
AVS ResultThe result of the Address Verification Service check. The following values are supported: Match Partial Match No Match System Unavailable Invalid Not Supported
Batch Reference CodeThe funding entry’s identification number
Data Label 1Merchant custom-defined fields defined in VT
Data Label 2Merchant custom-defined fields defined in VT
Data Label 3Merchant custom-defined fields defined in VT
Data Label 4Merchant custom-defined fields defined in VT
Bill to CityThe city of the customer's billing address
Bill To eMailThe customer's email address
Bill To Postal CodeThe zip or postal code of the customer's billing address
Bill To StateThe state of the customer's billing address
Bill To Street Line 1The first line of the customer's billing address
Bill To Street Line 2The second line of the customer's billing address
Bill To TelephoneThe customer's phone number
Cardholder NameThe customer's cardholder name
Check NumberThe check number of the check.
Customer FaxThe customer's Fax phone number
CVV MethodCard Verification Value method
CVV ResultThe result of the Card Verification Value check. The following values are supported: Match No Match Error (Unrecognized or Unknown Response) Invalid or Null Not Processed Service Not Supported Issuer Unable to Process No Response
Entered ByThe name or API key of the user that created this transaction.
SEC CodeThe SEC code associated with the transaction. The following values are supported: ARC CCD CIE CTX POP POS PPD RCK TEL WEB For descriptions of these codes, see Using ACH and SEC Return Codes topic on Forte's Developer Documentation site.
Entry DescriptionDetails pertaining to the funding entry that can be overwritten by the merchant after the funds are in the merchant's bank account.
File Reference CodeFile Reference Code
Freight AmountThe amount paid to a carrier company for the transportation of goods from the point of origin to an agreed location.
IP AddressThe IP Address from where the merchant/partner submitted the transaction.
Item DescriptionA brief description of the schedule or service.
Line ItemsDetailed descriptions regarding the customer and the transaction, such as: Customer Name,Customer Id,Bill Number,Unique Bill Id,Payment Amount,Late Fee Fixed
Origination DateThe date on which the funds of the transaction go to the originating depository financial institution.
Preauth CodePreauth Code Received related to the transaction
Preauth DescriptionPreauth Description received related to the transaction
Preauth Negative ReportDescribes why the transaction was declined due to a pre-authorization (Forte Verify) result.
Preauth ResultThe result of the customer pre-authorization
Proc CardProcurement Card
Response CodeThis field displays the response and settlement codes for rejected transactions.
Insufficient Fund - R01 - The balance is not sufficient to cover the value of the transaction.
Account Closed - R02 - A previously open account has been closed.
No Account - R03 - The account is closed or doesn't match the name submitted.
Invalid Account Number - R04 - The account number structure is invalid.
Pre-Note Not Recieved - R05 - Pre-notification was not received.
Returned per ODFI - R06 - ODFI has requested RDFI to return this item.
Authorization Revoked - R07 - Account holder has revoked the company's authorization.
Payment Stopped - R08 - Account holder has stopped payment on this single transaction.
Uncollected Funds - R09 - Balance is sufficient, but can't be released until uncollected items are collected.
No Authorization - R10 - Account holder advises that the transaction is not authorized.
Check Safekeeping Return - R11 - Return of a check safekeeping entry return.
Branch Sold - R12 - The account is at a branch that was sold to another financial institution.
RDFI Not Qualified - R13 - RDFI not qualified to participate.
Deceased - R14 - The account holder is deceased.
Beneficiary Deceased - R15 - The beneficiary entitled to benefits is deceased.
Account Frozen - R16 - Funds are unavailable due to action by RDFI or other legal action.
Non-Transaction Account - R20 - Policies/regulations restrict activity to this account.
Payment Refused - R23 - The account holder refuses the transaction because the amount is inaccurate for another legal reason.
Duplicate Entry - R24 - The transaction appears to be a duplicate item.
Mandatory Error - R26 - The transaction is missing data from a mandatory field.
Invalid TRN - R28 - The Transit Routing Number is invalid.
Corporate Not Authorized - R29 - The corporate receiver has notified RDFI that the Corp entry is not authorized.
ODFI Permits Late Return - R31 - RDFI rejected an entry that the ODFI had accepted (applies to CCD and CTX only)
Invalid Company ID - R50 - The OwnerCompany ID field is not valid.
Invalid Transaction Date - R56 - The date specified is invalid.
Stale Date - R57 - The transaction is too old for processing.
Over Limit - R95 - This transaction is over your authorized limit.
Account On Hold - R96 - The company account is on hold.
RDFI Does Not Participate - R97 - RDFI does not allow this type of transaction.
Invalid Password - R98 - The password supplied was invalid.
Declined Unpaid Item - R99 - This account or ID has been declined due to unpaid items.
Response DescriptionThe transaction response values:
Approved
Declined
Response TypePreauth Result Type, will be displayed with the following results as example (in bold):
A = APPROVED
B = BUSINESS NAME MATCH
D = PREAUTH DECLINE
E = AUTH ERROR
M = FIRST & LAST NAME MATCH
P = PARTIAL MATCH
N = NO MATCH
O = OVERALL MATCH
Routing Transit NumberThe TRN or routing number of the bank. This value is typically the first number listed at the bottom of the check. This field is required.
Settlement DateSettlement date for the customer transaction
Settlement Response CodeSettlement Response Code related to the customer transaction
Settlement Response Code DescriptionSettlement Code Description related to the customer transaction
Ship To AddressShipping Address Line 1
Ship Address 2Shipping Address Line 2
Ship To CityShip To City
Ship To NameShip To Customer Name
Ship To Postal CodeShip To Postal Code
Ship To StateShip To State
Bank Account VerificationDisplays the P-codes associated with a Validate Plus transaction. The following options display:
P10 – No Match
P15 – High Risk
P20 – Negative Reports
P21 – No Negative Reports
P23 – Invalid Account/ABA Number
P40 – No Negative Information
P41 – Negative Information
P50 – No Information
P60 - Match
P70 - Validated
P71 – Low Risk Approval
P73 – Medium-Risk Approval
P75 – Conditional Match
P80 – Vendor Busy
P90 – Preauthorization Vendor Unavailable
P91 - Preauthorization Vendor Error
P92 - Preauthorization Server Unavailable
P93 – Error P94 – Invalid Routing Number
P94 – Invalid Account Number
P95 - Bad Account
Dispute IDThe unique, Vantiv-defined number that identifies the dispute.
Dispute StatusIndicates where the dispute is in the dispute lifecycle. Dispute status values are:
Accepted
Documents Needed
Exception
Expired
Fultilled
Lost
Pending
Recalled
Reviewing
Won
Principal (At Merchant Level)The authorized amount of a transaction, which includes taxes (if applicable) but not service fees.
Service Fee (At Merchant Level)The service/convenience fee for the transaction. Service fees are either a percentage of the principal or a set amount.
PayPal Order IDThe PayPal transaction Order ID number.
PayPal AccountThe Customer PayPal email account .




Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.