db_expense
- Former user (Deleted)
- Rashmi Likhite
- Former user (Deleted)
Owned by Former user (Deleted)
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 |
| summary | 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 |
| approval_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 |