InvoicesReport
The Invoice Details Report shows all the information involving your invoices.
Columns
Name | Type | Description |
CreatedDate | Date | The date the invoice was created. |
InvoiceId [KEY] | String | The unique id of the invoice. |
DueOffsetDays | Int | Number of days from creation that the invoice is due. |
Amount | Decimal | The amount of money that is owed or been paid. |
Code | String | The currency that the amount is in. |
PostOfficeNumber | Int | Post office box number for address on invoice. |
TaxAmount | Decimal | Amount of tax. |
TaxCode | String | Three-letter currency code. |
PaidAmount | Decimal | Amount paid. |
PaidCode | String | Three-letter currency code. |
DatePaid | Date | The date the invoice was paid. |
DiscountAmount | Decimal | The amount discount. |
DiscountCode | String | Three-letter currency code. |
InvoiceNumber | String | User-specified and visible invoice id. |
currency_code | String | Three-letter currency code for invoice. |
UserId | String | The unique id of the client. |
FirstName | String | First name of the user. |
LastName | String | The last name of the user. |
String | The email of the user. | |
Organization | String | Name of the organization the user is a part of. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
StartDate | String | The starting date for the expense report query. |
EndDate | String | Will only return invoices that were created before the given date. |