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. |
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). |