Describes an expense
| Column | Type | References | Comments |
|---|---|---|---|
| id |
| Integer |
| Primary key |
| vdb_id |
| Integer | ||
| created |
| Date |
| Date of this expense |
| creator_id |
| Integer | db_person.id |
| Creator ID |
| task_id |
| Integer | db_task.id |
| Task ID |
| name |
| String |
| Short summary |
| is_billable |
| Boolean (t or f) |
| Whether this expense is billable |
| is_costable |
| Boolean (t or f) |
| Whether this expense is costable |
| state |
| Integer |
| 0 - saved but not submitted for approval, 1 - sent for approval, 2 - rejected, 3 - approved, 6 - invoiced |
| approver_id |
| Integer | db_person.id |
| Approved by ID |
| approved_on |
| Date |
| Date of approval |
| approver_comments |
| String |
| Approver comments |
| rejected_by_id |
| Integer | db_person.id |
| Rejected by |
| rejected_on |
| Date |
| Date of rejection |
| rejection_comments |
| String |
| Reason for rejection | |||
| invoiced_on | Date | Invoiced on | |
| invoiced_by_id | Integer | Invoiced by ID | |
| is_temp |
| Boolean (t or f) |
| Whether this expense is 'temporary'. Temporary expenses are not to be considered for any calculations. They are a temporary creation of the system and will be deleted from time to time. |
| amount |
| Float |
| Amount |