db_expense

Describes an expense

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
createdDate Date of this expense
creator_idIntegerdb_person.idCreator ID
task_idIntegerdb_task.idTask ID
summaryString Short summary
is_billableBoolean (t or f) Whether this expense is billable
is_costableBoolean (t or f) Whether this expense is costable
stateInteger 0 - saved but not submitted for approval, 1 - sent for approval, 2 - rejected, 3 - approved, 6 - invoiced
approver_idIntegerdb_person.idApproved by ID
approved_onDate Date of approval
approval_commentsString Approver comments
rejected_by_idIntegerdb_person.idRejected by
rejected_onDate Date of rejection
rejection_commentsString Reason for rejection
invoiced_onDate Invoiced on
invoiced_by_idInteger Invoiced by ID
is_tempBoolean (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.
amountFloat Amount