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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |