InvoicesJobTask
Return a list of invoices related to Tasks.
Select
The 本製品 will process all filters client side except InvoiceID.
SELECT * FROM InvoicesJobTask WHERE InvoiceID = 'I000123' SELECT * FROM InvoicesJobTask WHERE InvoiceID IN ('I000124', 'I000123')
Columns
Name | Type | Description |
InvoiceID [KEY] | String | The identifier of the invoice |
Name | String | The Name of the task related to the invoice. |
Description | String | The Description of the task related to the invoice. |
Minutes | Int | The Minutes of the task related to the invoice. |
BillableRate | Double | The BillableRate of the task related to the invoice. |
Billable | String | The Billable of the task related to the invoice. |
Amount | Double | The Amount of the task related to the invoice. |
AmountTax | Double | The AmountTax of the task related to the invoice. |
AmountIncludingTax | Double | The AmountIncludingTax of the task related to the invoice. |