Borrower Payment Plan Installments - Command by ClearGrid AI

Property	Value
Dataset code	`D09`
Section code	`S2` — Payments & Settlements
Endpoint path	`/exports/S2/D09`
Cursor field	`updated_at`
Page size	`1`–`1000` (default `500`)
Availability	Phase 1 — generally available
Pagination	Direct (constant page size)

Individual installments inside a payment plan. Each row is one scheduled installment with its number, amount, due date, and status. The plan header is in D08.

Fields

Field	Type	Description	Notes
`public_id`	string	Stable public identifier for the installment.
`number`	integer	Position of the installment within the plan (1-based).
`amount`	integer	Installment amount in minor units (fils/cents).
`due_date`	string \| null	When the installment is due (ISO-8601).
`status`	string	Installment status.
`created_at`	string	Row creation timestamp (ISO-8601).
`updated_at`	string	Last-modified timestamp (ISO-8601).	Cursor field

Sample row

{
  "public_id": "d4b8f1a6-3c27-4e90-8b15-2a6d9c0e7f43",
  "number": 1,
  "amount": 120000,
  "due_date": "2026-04-30T00:00:00.000Z",
  "status": "PAID",
  "created_at": "2026-03-28T10:14:03.011Z",
  "updated_at": "2026-04-30T12:03:41.225Z"
}

Pagination characteristics

This dataset is direct — filtered to your tenant by lender_id on the collection itself, so each page returns a constant number of rows until the last page.

Use cases

Installment-level due-date schedule.
Installment status changes for collections operations.
Payment-plan progress reporting (join to D08).

Empty in current tenant rollouts. The field set above is not yet verified against live data and may be refined.