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

> Payment events processed against a customer's account

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

Each row is one payment event we processed against a customer's account. It includes the amount, the payment type, the status, and whether we have settled it with you yet.

## Fields

| Field                    | Type           | Description                                                                 | Notes                |
| ------------------------ | -------------- | --------------------------------------------------------------------------- | -------------------- |
| `public_id`              | string         | Stable public identifier for the payment.                                   |                      |
| `amount`                 | integer        | Payment amount in minor units (fils/cents).                                 | `75000` = SAR 750.00 |
| `settled_amount`         | integer        | Amount settled to the lender, in minor units.                               | `0` until settled    |
| `payment_type`           | string         | Type of payment (e.g. `PAID_TO_LENDER`).                                    |                      |
| `payment_status`         | string         | Processing status (e.g. `SUCCESS`, `PENDING`, `FAILED`).                    |                      |
| `is_settled`             | boolean        | Whether the payment has been settled to the lender.                         |                      |
| `paid_before_submission` | boolean        | Whether the payment was made before the account was submitted to ClearGrid. |                      |
| `paid_date`              | string \| null | When the payment was made (ISO-8601).                                       |                      |
| `failure_reason`         | string \| null | Reason for failure when `payment_status` is `FAILED`.                       | `null` otherwise     |
| `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": "b1f4c2e0-9a73-4d21-8c54-7e2a1d9b0f31",
  "amount": 75000,
  "settled_amount": 75000,
  "payment_type": "PAID_TO_LENDER",
  "payment_status": "SUCCESS",
  "is_settled": true,
  "paid_before_submission": false,
  "paid_date": "2026-05-18T08:12:44.000Z",
  "failure_reason": null,
  "created_at": "2026-05-18T08:12:45.221Z",
  "updated_at": "2026-05-18T08:30:02.108Z"
}
```

## Pagination characteristics

This dataset is **direct** — it is filtered to your tenant by `lender_id` on the collection itself, so each page returns a constant number of rows until the last page. `rows.length < limit` reliably means you have reached the end.

## Use cases

* Daily reconciliation against payments settled to the lender.
* First-payment-after-PTP attribution.
* Failure-rate monitoring by `payment_type` and `failure_reason`.

***

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