Export Field Name

Transaction Details Screen Field Name

Description

Id

Transaction ID

The unique transaction identifier assigned by the system. When viewing transactions in the ReceivablesPro application, payments generated by schedules preface this ID with an “R.” The “R” is not included in the export.

CustomerId

Customer ID

The unique identifier assigned to the customer charged.

You can use the Customer ID as the database “key” when integrating ReceivablesPro data with external systems.

Customer_Contact_FirstName

Name

The First Name for your customer’s Primary Contact.

Customer_Contact_LastName

Name

The Last Name for your customer’s Primary Contact.

Customer_Contact_CompanyName

Company

The Company for the customer.

ProviderAuthCode

Reason Description

The response to a transaction authorization request. If the transaction is authorized this field will be blank or “Approved.” If the transaction fails, this field will provide a brief description of why.

TraceNumber

Authorization Code

The authorization code sent by the processor when a transaction is approved.

EstimatedSettledDate

Estimated Settlement Date

The date the system estimates a transaction will settle.
NOTE: You can ignore the time-stamp in this field, it is not accurate.

IsDebit

N/A

This field = “False” for payments and “True” for credits and refunds. It is used to determine whether the Amount field is a positive or negative number.

Amount

Amount

The absolute value of a transaction amount. This field will always be positive. Refer to the “IsDebit” field to determine whether the actual transaction is for a positive or negative amount.
NOTE: Because the Amount field is always positive, you cannot use a payment history export to sum the total value of exported transactions. To get an accurate sum, you will need to change the Amount field to a negative number for each transaction where the “IsDebit” field = “True.”

Narration

Payment Description

The text you enter in the Payment Description field.

PONO

PO #

The Purchase Order Number entered for the transaction.

InvoiceNo

Invoice #

The Invoice # associated with the transaction. This can be a system invoice number, or an external invoice number you enter when processing the payment.

PaymentDate

Date Entered

The date the transaction was processed. On the manage payments screen, this is the “Date paid” field.
NOTE: You can ignore the time-stamp in this field, it is not accurate.

ReturnCode

Reason Description

For ACH transactions that are returned, the reason code (R code) with a brief description is placed in this field. For example, if an ACH payment is returned for non-sufficient funds, this field would contain “R01 Non-Sufficient Funds.”

ActualSettledDate

Settlement Date

The date the transaction actually settled.
NOTE: You can ignore the time-stamp in this field, it is not accurate.

StatusText

Status

Transaction status.

CCExpiry

Expiration Date

The expiration date for the credit card used to make the payment. (Ignore the time stamp, it is not accurate.)
NOTE: For bank accounts, the system enters the date and time the bank account was entered in this field. Be assured that it is not being used to send credit card expiration notices to your ACH customers.

CCType

Credit Card Type

The type of credit card used to make the payment: Visa, Master (for MasterCard), AMEX (for American Express), or Discover.

TruncatedCreditCardNo

Credit Card Account

The last 4 digits of the credit card used to make the payment.

BankName

Bank Name

The name of the bank for the account used to make the payment.

RoutingNo

Routing Number

The full routing number for the bank account used to make the payment.

TruncatedBankAccountNo

Account Number

The last four digits of the bank account number used to make the payment.

Customer_CustomerAccount

Account #

The internal account number you assigned to the customer as part of the Customer Record.