Field Definitions for the Recurring Payment Schedule Export File

The recurring payment schedule export file is not customizable. All exports contain the same set of fields, with the same field names in the same order. These fields are defined in the table below.

 

Export Field Name

Description

ScheduleId

The unique schedule identifier assigned by the system.

PaymentAmount

The amount the customer is charged for each payment.

NextPaymentDate

The next date on which a payment will be generated by the schedule.

StartDate

The date the schedule is programmed to start.

EndDate

The date the schedule is programmed to expire. If no end date is defined, this field will be blank.

Frequency

The top-level frequency for the schedule (i.e. Daily, Weekly, Specific Day of Month).

FrequencyParameter

For 2-level frequencies (Weekly, Bi-Weekly, Specific Day of Month) the day of week or month on which invoices will be generated.

ScheduleStatusText

The schedule status. (Active, Suspended, or Expired)

CustomerId

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.

CustomerFirstName

The First Name for your customer’s Primary Contact.

CustomerLastName

The Last Name for your customer’s Primary Contact.

CompanyName

The Company for the customer.

AccountNumber

The account number you assigned to the customer (in the Account # field).

Next >