Describes an expense
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| created | Date | Date of this expense | |
| client_id | Integer | db_user.id | Client ID for this expense |
| creator_id | Integer | db_user.id | Creator ID |
| summary | String | Short summary | |
| is_billable | Boolean (t or f) | Whether this expense is billable | |
| state | Integer | 0 - saved but not submitted for approval, 1 - sent for approval, 2 - rejected, 3 - approved | |
| company_id | Integer | db_company.id | |
| approver_id | Integer | db_user.id | Approved by ID |
| approved_on | Date | Date of approval | |
| approval_comments | String | Approver comments | |
| rejected_by_id | Integer | db_user.id | Rejected by |
| rejected_on | Date | Date of rejection | |
| rejection_comments | String | Reason for rejection | |
| is_temp | Boolean (t or f) | Whether this expense is 'temporary' | |
| amount | Float | Amount |