Expenses
Expenses are used to track expenditures your business incurs.
Columns
Name | Type | ReadOnly | Description |
ExpenseId [KEY] | Integer | True |
A unique identifier for the expense, unique to business id. |
AccountName | String | False |
The name of the related account, if applicable. |
AccountId | Integer | False |
The identifier of the related account, if applicable. |
AccountingSystemId | String | False |
The identifier of the system. |
Amount | Decimal | False |
The amount of the expense. |
BackgroundJobId | Integer | False |
The identifier of the related background job if applicable. |
BankName | String | False |
The name of the bank the expense was imported from, if applicable. |
CategoryId | Integer | False |
The identifier of the related expense category. |
ClientId | Integer | False |
The Id of the related client, if applicable. |
Code | String | False |
Three-letter currency code for expense. |
CompoundedTax | Boolean | False |
Boolean indicated if the tax was a compound tax. |
Date | Date | False |
Date of the expense. (YYYY-MM-DD) |
ExtInvoiceId | Integer | False |
The identifier of the related contractor invoice if applicable. |
ExtSystemId | Integer | False |
The identifier of the related contractor system if applicable. |
HasReceipt | Boolean | False |
Boolean indicating if there is a receipt attached. |
InvoiceId | Integer | False |
Identifier of the related invoice, if applicable. |
IsDuplicate | Boolean | False |
Boolean indicating if this is a duplicated expense. |
MarkupPercent | String | False |
Note of percent to mark the expense up. (String-decimal) |
Notes | String | False |
Notes about the expense. |
ProfileId | Integer | False |
Identifier of related profile, if applicable. |
ProjectId | Integer | False |
Identifier of related project, if applicable. |
StaffId | Integer | False |
Identifier of related staff member, if applicable. |
Status | Integer | False |
Values from expense status table. |
TaxAmount1 | Decimal | False |
The amount of the first tax. |
TaxAmount2 | Decimal | False |
The amount of the second tax. |
TaxName1 | String | False |
Name of first tax. |
TaxName2 | String | False |
Name of second tax. |
TaxPercent1 | Decimal | False |
The percent of the first tax. |
TaxPercent2 | Decimal | False |
The percent of the second tax. |
TransactionId | Integer | False |
Identifier of related transaction, if applicable. |
Updated | Datetime | False |
Time the invoice was last updated. (YYYY-MM-DD HH:MM:SS) |
Vendor | String | False |
Name of vendor. |
VisState | Integer | False |
0 for active, 1 for deleted. |