Home

Open payment plan portfolios

The open payment plan portfolios return file

Column NameExample/ Accepted Value
integration_link_idA1234567_987654321
invoice_numberIN12345
invoice_created_on2019-07-15 05:21:30.926
invoice_paid_amount2750
amount_due440
statusRecurringPayment,
AdHocPayment,
Charge,
Offer Payment
portfolio_statusOpen-Arrears,
Open-Current,
Open-Advanced
created_on2023-07-28 17:37:23.144
payment_frequencyFortnightly,
Monthly,
Weekly
recurring_amount50
start_date2023-09-06T20:43:31.772+10
forecast_end_date2023-10-10T20:43:31.772+10
next_due2023-09-11T20:43:31.772+10
paid_count5
scheduled_count2
declined_count3
paid_value2310
avg_scheduled_performance0.86
last_paid_date2022-05-07
last_declined_date2023-02-04
payments_remaining50
arrears_statusCurrent Arrears
arrears_amount49
due_count_mtd
paid_count_mtd200
Blank
due_value_mtd22.28
paid_value_mtd22.00
Blank
avg_scheduled_performance_mtd0.99
arrears_amount_mtd2.48