Field Name

Description

Transaction Id

The unique identifier ReceivablesPro assigns to each transaction. This field is included in all reports by default.

Transaction Date

The enter date for the transaction.

Status

The transaction status. See Step 7. above for status definitions.

Payment Type

The type of transaction processed. CCD, PPD, TEL or WEB for Echeck (ACH) transactions, and Amex (for American Express), Discover, Master (for MasterCard) and Visa for credit card transactions. See above for detailed definitions of transaction types.

Amount

The transaction amount.

Reason Description

Used for failed transactions, and for Echeck (ACH) transactions that have a status of “Returned,” this field provides a brief description of why the transaction failed. For ACH Returns, see Appendix B: ACH Return Codes for a description of the codes included in the Reason Description field.

Trace Number

For successful transactions, the unique authorization number used to track the transaction with the credit card or ACH processor. For failed credit card transactions, this number is the credit card failure code. (See Appendix G: Credit Card Failure Codes for failure code definitions.)

Estimated Settlement Date

The date the transaction was/is scheduled to settle.

PO Number

The PO Number entered for the transaction.

Invoice Number

The invoice number for the transaction.

Payment Form ID

Used only with payments made via a Web Payment Form. This field indicates the ID of the Web Payment Form on which the payment was submitted.

Schedule Id

Used only with payments attached to a recurring payment schedule (either billing or payment plan). This is the Schedule ID for the schedule.

Customer User Name

The User ID for the customer attached to the transaction.

Masked Account Number

The last 4 digits of the bank account used for the transaction.

Masked CC Number

The last 4 digits of the credit card used for the transaction.

IsDebit

If the value of this field is “False,” then the transaction is a payment you are collecting from a customer. If the value of this field is “True,” the transaction is a refund/credit you are paying to a customer.

Actual Settlement Date

The date the transaction actually settled to your bank account (as opposed to the Estimated Settlement Date which is the date the system calculates the transaction should settle).

Description

The description entered in the Payment description field on the collect new payment screen for a one-time or recurring payment.

User ID First Name

The first name of the ReceivablesPro User on your account who entered the payment. For payments entered via web payment forms this is the User attached to the Web Payment Page.

User ID Last Name

The last name of the ReceivablesPro User on your account who entered the payment. For payments entered via web payment forms this is the User attached to the Web Payment Page.

User ID

The User ID for the ReceivablesPro User on your account who entered the payment. For payments entered via web payment forms this is the User attached to the Web Payment Page.

Return Date

Used Echeck (ACH) transactions that have a status of “Returned,” “Returned NSF,” or “Chargeback,” this field provides the date on which the return was entered and the date on which your account was debited for the returned transaction amount.

Custom Fields

Any custom fields you create for the Payment module will be included in the list of available transaction fields. They will be preceded with an asterisk (*) in the Select Fields box.

For example, if I create a custom field called “Package Ordered,” that field would appear in the box as “*Transaction.Package Ordered.”