> ## Documentation Index
> Fetch the complete documentation index at: https://docs.command.cleargrid.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Borrower Payment Plans

> Installment payment plans agreed with the customer

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

Installment payment plans agreed with the customer. Each row is one plan header; the individual installments are exposed separately in [D09](/api-reference/exports/datasets/d09-borrower-payment-plan-installments).

## Fields

| Field                | Type           | Description                                    | Notes        |
| -------------------- | -------------- | ---------------------------------------------- | ------------ |
| `public_id`          | string         | Stable public identifier for the plan.         |              |
| `total_amount`       | integer        | Total plan amount in minor units (fils/cents). |              |
| `total_installments` | integer        | Number of installments in the plan.            |              |
| `status`             | string         | Plan status.                                   |              |
| `payment_gateway`    | string         | Gateway used to collect the plan.              |              |
| `start_date`         | string \| null | Plan start date (ISO-8601).                    |              |
| `end_date`           | string \| null | Plan end date (ISO-8601).                      |              |
| `is_active`          | boolean        | Whether the plan is currently active.          |              |
| `created_at`         | string         | Row creation timestamp (ISO-8601).             |              |
| `updated_at`         | string         | Last-modified timestamp (ISO-8601).            | Cursor field |

## Sample row

```json theme={null}
{
  "public_id": "a7c3e9d2-1b48-4f60-9a21-5e8c0d3b6f10",
  "total_amount": 360000,
  "total_installments": 3,
  "status": "ACTIVE",
  "payment_gateway": "HYPERPAY",
  "start_date": "2026-04-01T00:00:00.000Z",
  "end_date": "2026-06-30T00:00:00.000Z",
  "is_active": true,
  "created_at": "2026-03-28T10:14:02.881Z",
  "updated_at": "2026-05-12T09:01:55.402Z"
}
```

## 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

* Active vs. completed plan counts.
* Average installments per plan.
* Plan-status transition timing (join to D09 and [D07](/api-reference/exports/datasets/d07-borrower-payments)).

<Note>
  Empty in current tenant rollouts — the endpoint works but returns no rows until plan data is created. The field set above is not yet verified against live data and may be refined.
</Note>

***

<Snippet file="snippets/support-info.mdx" />