The Payments Collected Report shows details regarding collected payments made to your business.
|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 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.
|StartDate||String||The starting date for the expense report query.|
|EndDate||String||Will only return invoices that were created before the given date.|