ExpensesReport
The Expenses Report shows all the information involving your Expenses.
Columns
| Name | Type | Description |
| ExpenseId [KEY] | String | Unique id for the expense. |
| GroupId | String | Unique id for the group. |
| Amount | Decimal | The amount of money that is owed or been paid. |
| Code | String | The currency that the amount is in. |
| VendorId | String | The unique id for the vendor. |
| Vendor | String | The name of the vendor. |
| Notes | String | Custom notes about the expense. |
| ClientId | String | Unique id for the client. |
| AuthorId | String | Id for the author. |
| CreatedDate | Date | The date the expense took place. |
| TaxName1 | String | The name of the first tax. |
| TaxPercent1 | Decimal | The percentage you are being taxed on. |
| TaxAmount1 | Decimal | The amount of the first tax. |
| TaxCode1 | String | The currency of the first tax. |
| TaxName2 | String | The name of the second tax. |
| TaxPercent2 | Decimal | The percentage you are being taxed on. |
| TaxAmount2 | Decimal | The amount of the second tax. |
| TaxCode2 | String | The currency of the second tax. |
| CategoryId | String | The identifier of the category. |
| CompanyName | String | Name of the company that the expenses are charged too. |
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. |