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. |