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
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. |