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 and 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 and 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 and time the invoice got voided.

Was this article helpful?