Invoices
The available fields in the ‘Invoices' data source and their corresponding descriptions are listed below.
| Field | Description |
|---|---|
| Expected Payment Date | Displays the expected payment date recorded for the invoice. |
| Paid On | Timestamp indicating the date & time when the invoice was paid. |
| Invoice ID | Displays the unique identifier of the invoice. |
| First Invoice | Displays True if the invoice is a first invoice, false, if otherwise. In the case of a non-recurring invoice, it indicates the first invoice raised for the customer. |
| Amount To Collect | Displays the rounded-off invoice amount. |
| Net D | Displays the number of days within which the invoice has to be paid. |
| Next Retry On | Timestamp indicating when will the next attempt to collect payment for the invoice will occur. |
| Dunning Status | Displays the dunning status of the invoice. Possible values are in_progress, exhausted, stopped, success. |
| Currency | The currency code (ISO 4217 format) of the invoice amount. |
| Total Tax Amount | Displays the total tax amount for the invoice. |
| Tax Amount (Transaction Currency) | Displays the total tax amount for the invoice in the transaction currency. |
| Write Off Amount | Displays the amount written off against the invoice. |
| Is Recurring Invoice | Displays ‘Yes' if the invoice is recurring, ‘No', if otherwise. |
| Amount Due | Displays the total amount to be collected. This includes invoice's payments in progress. |
| Amount Adjusted | Displays the total adjustments made against the invoice. |
| Round Off Amount | Indicates the rounded-off amount. |
| Amount Paid | Displays the total payments received for the invoice. |
| Advance Charges | Boolean indicating any advance charge is present in this invoice. |
| Credits Applied | Displays the total credits applied against the invoice. |
| Issued On | Closing date of the invoice. Typically this is the date on which invoice is generated. If you have "wait & notify to send invoices enabled for usage based billing" , then the date displayed here will be different. |
| Due Date | Displays the invoice Due Date. |
| Price Type | The price type of the invoice. Possible values are tax_exclusive, tax_inclusive. |
| Status | Displays the current status of this invoice. Possible values are paid, posted, payment_due, not_paid, voided, pending. |
| Total | Invoiced amount in dollars. |
| Total (Transaction Currency) | Invoiced amount in the transaction currency. |
| Po Number | Displays the Purchase Order Number for this invoice. |
| VAT Number | Displays the Vat Number. |
| Sub Total | Displays the Sub total of the invoice. |
| Voided On | Timestamp indicating the date & time the invoice got voided. |
Was this article helpful?