Expenses
Employee expense reports and reimbursement records
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| CategoryId | Integer |
Categories.Id | |
| EmployeeId | Integer |
Employees.Id | |
| ProjectId | Integer |
Projects.Id | |
| Status | String |
The allowed values are draft, submitted, approved, rejected, paid. | |
| AccessToken | Integer | ||
| Amount | Decimal | ||
| BudgetId | Integer | ||
| CardPaymentId | Integer | ||
| Category | String | ||
| CompanyId | Integer | ||
| CostCenterIds | String | ||
| CreationType | String | ||
| Currency | String | ||
| Description | String | ||
| DisputeId | Integer | ||
| DocumentId | Integer | ||
| DocumentNumber | Integer | ||
| DocumentType | String | ||
| EffectiveOn | Date | ||
| ExchangeRate | Decimal | ||
| ExpensesCardId | Integer | ||
| ExpensesExpensableId | Integer | ||
| ExternalAuthorizationId | Integer | ||
| Files | String | ||
| LedgerAccountId | Integer | ||
| MerchantName | String | ||
| MerchantTin | String | ||
| PaidAt | Datetime | ||
| Payment | String | ||
| PaymentMethod | String | ||
| Reference | String | ||
| ReimbursableAmount | String | ||
| ReimbursableCurrency | String | ||
| ReviewRequestAt | Datetime | ||
| StatusUpdatedAt | Datetime | ||
| Subcategory | String | ||
| Taxes | String | ||
| UserMerchant | String |