...
| Column | Type | References | Comments |
|---|---|---|---|
| id | IntegerInteger | Primary Primary key | |
| vdb_id | IntegerInteger | ||
| created | DateDate | Date Date of this expense | |
| creator_id | IntegerInteger | db_person.id | Creator Creator ID |
| task_id | IntegerInteger | db_task.id | Task Task ID |
| summary | StringString | Short Short summary | |
| is_billable | Boolean Boolean (t or f) | Whether Whether this expense is billable | |
| is_costable | Boolean Boolean (t or f) | Whether Whether this expense is costable | |
| state | IntegerInteger | 0 0 - saved but not submitted for approval, 1 - sent for approval, 2 - rejected, 3 - approved, 6 - invoiced | |
| approver_id | IntegerInteger | db_person.id | Approved Approved by ID |
| approved_on | DateDate | Date Date of approval | |
| approval_comments | StringString | Approver Approver comments | |
| rejected_by_id | IntegerInteger | db_person.id | Rejected Rejected by |
| rejected_on | DateDate | Date Date of rejection | |
| rejection_comments | StringString | Reason Reason for rejection | |
| invoiced_on | Date | Invoiced on | |
| invoiced_by_id | Integer | Invoiced by ID | |
| is_temp | Boolean Boolean (t or f) | Whether 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 | FloatFloat | AmountAmount |