PrepaymentAllocations
Used to query prepayment allocations. Prepayments are amounts paid in advance but not yet invoiced, and this view helps manage their application.
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier for the allocation, combining the allocation index and the Xero-generated identifier for the prepayment. This helps track the specific allocation transaction. |
| PrepaymentId | String | The unique identifier for the prepayment transaction. This links the allocation to the specific prepayment made by the customer or supplier. |
| Allocation_AppliedAmount | Decimal | The amount from the prepayment being applied to a specific invoice. This shows how much of the prepayment is being used to settle the invoice balance. |
| Allocation_Date | Date | The date when the allocation was made. This field records when the prepayment was applied to the invoice, helping to track payment history. |
| Allocation_InvoiceId | String | The identifier of the invoice to which the prepayment has been applied. This links the allocation to the specific invoice that is being paid. |
| Allocation_InvoiceNumber | String | The invoice number associated with the allocation. This field provides a reference to the invoice receiving the prepayment. |
| TenantId | String | The unique identifier for the tenant. This ensures the query retrieves data specific to a particular tenant in a multi-tenant environment, maintaining data isolation and access control. |