InvoicesappliedPrepayments
Shows prepayment amounts applied to a given invoice, helping track remaining balances and total obligations.
Columns
| Name | Type | Description |
| InvoicesInvoiceId [KEY] | Long | Unique identifier of the invoice associated with the applied prepayment, used for tracking and managing invoice data. |
| InvoiceNumber | String | Unique number of the invoice, used to identify the invoice in the applied prepayment context. |
| LineNumber [KEY] | Int | Line number associated with the invoice applied prepayment, used to differentiate between multiple lines on the same invoice. |
| Description | String | Description of the applied prepayment, providing details about the transaction or prepayment. |
| SupplierSite | String | Supplier site associated with the applied prepayment, indicating the physical location of the supplier linked to the prepayment. |
| PurchaseOrder | String | Purchase order associated with the applied prepayment, linking the prepayment to the specific purchase order. |
| Currency | String | Currency used for the applied prepayment, specifying the type of currency in which the prepayment was made. |
| AppliedAmount | Decimal | Amount of the prepayment that has been applied to the invoice, showing how much has been used from the prepayment. |
| IncludedTax | Decimal | Tax amount included in the applied prepayment, specifying the portion of tax associated with the prepayment. |
| IncludedonInvoiceFlag | Bool | Flag indicating whether the prepayment is included in the invoice, providing clarity on its inclusion in the invoice calculation. |
| ApplicationAccountingDate | Date | Accounting date when the prepayment application is recorded, determining when it is reflected in financial records. |
| Finder | String | Search term or identifier used to locate and retrieve specific applied prepayment records. |
| InvoiceId | Long | Unique identifier of the invoice related to the applied prepayment, helping to associate the prepayment with its corresponding invoice. |
| CUReferenceNumber | Int | Reference number mapping the child aggregates with the parent tables, linking data between related entities. |
| EffectiveDate | Date | Date parameter used to fetch resources that are effective as of a specified start date, ensuring accurate retrieval of time-sensitive data. |