Field Definitions for the Recurring Invoice Schedule Export File

The recurring invoice 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
Id	The Schedule ID for the invoice schedule.
ScheduleStatusText	The schedule status.
CreatedOn	The date and time the schedule was created—not necessarily the first date it was sent or the date it was activated.
CustomerId	The unique identifier assigned to the customer invoiced by the schedule. The export file does not include customer name or address. User the Customer ID to locate specific customer information in the system. You can also use the Customer ID as the database “key” when integrating ReceivablesPro data with external systems.
InvoiceAmount	The total due for each invoice in the schedule, taking all line items, taxes, and discounts into account. NOTE: Invoice details such as the discount, or details for individual line items, are not included in exports.
InvoiceDueDate	The due date for the last invoice sent by the schedule. NOTE: You can ignore the time-stamp in this field.
InvoiceNo	This is the invoice number for the first invoice generated by the schedule.
StartDate	The date the invoice schedule was programmed to start (The value entered in the Start date field when the schedule was created.)-- NOT necessarily the date the first invoice from the schedule was actually generated. NOTE: You can ignore the time-stamp in this field.
EndDate	The date the invoice schedule is programmed to expire (The value entered in the End date field when the schedule was created.)--NOT necessarily the last date the schedule will generate an invoice. For invoice schedules with no defined end date, this field will be blank. NOTE: You can ignore the time-stamp in this field.
Frequency	The top-level frequency for the schedule (i.e. Daily, Weekly, Specific Day of Month).
FrequencyParam	For 2-level frequencies (Weekly, Bi-Weekly, Specific Day of Month) the day of week or month on which invoices will be generated.
LastSentDate	The day on which the most recent invoice generated by the schedule was sent. If the schedule has yet to generate any invoices, this field will be blank. NOTE: You can ignore the time-stamp in this field.
NextSendDate	The day on which the next invoice generated by the schedule will be sent. If the schedule is a draft or is expired, this field will be blank. NOTE: You can ignore the time-stamp in this field.

Next >