PaymentsCollectedReport
The Payments Collected Report shows details regarding collected payments made to your business.
Columns
Name | Type | Description |
InvoiceId | String | The unique id of the invoice. |
ClientId | String | The unique id of the client. |
Amount | Decimal | Amount paid on invoice to two decimal places. |
Code | String | Three-letter currency code. |
Client | String | The name of the business client belongs to. |
Description | String | The description of the payment. |
Date | Date | The date of the payment. |
InvoiceNumber | String | A custom id for the invoice. |
Method | String | Method of payment. |
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. |