Excel Add-In for Xero

Build 25.0.9434

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434