- active => { type => 'boolean', default => 'true' },
- customer_id => { type => 'integer' },
- description => { type => 'text' },
- id => { type => 'integer', not_null => 1, sequence => 'id' },
- itime => { type => 'timestamp', default => 'now()' },
- mtime => { type => 'timestamp' },
- project_type_id => { type => 'integer', not_null => 1 },
- projectnumber => { type => 'text' },
- type => { type => 'text' },
- valid => { type => 'boolean', default => 'true' },
+ active => { type => 'boolean', default => 'true' },
+ billable_customer_id => { type => 'integer' },
+ budget_cost => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
+ budget_minutes => { type => 'integer', default => '0', not_null => 1 },
+ customer_id => { type => 'integer' },
+ description => { type => 'text' },
+ end_date => { type => 'date' },
+ id => { type => 'integer', not_null => 1, sequence => 'id' },
+ itime => { type => 'timestamp', default => 'now()' },
+ mtime => { type => 'timestamp' },
+ order_value => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
+ project_status_id => { type => 'integer', not_null => 1 },
+ project_type_id => { type => 'integer', not_null => 1 },
+ projectnumber => { type => 'text' },
+ start_date => { type => 'date' },
+ timeframe => { type => 'boolean', default => 'false', not_null => 1 },
+ valid => { type => 'boolean', default => 'true' },