- id => { type => 'integer', not_null => 1, sequence => 'glid' },
- invnumber => { type => 'text', not_null => 1 },
- transdate => { type => 'date', default => 'now' },
- gldate => { type => 'date', default => 'now' },
- vendor_id => { type => 'integer' },
- taxincluded => { type => 'boolean', default => 'false' },
- amount => { type => 'numeric', precision => 5, scale => 15 },
- netamount => { type => 'numeric', precision => 5, scale => 15 },
- paid => { type => 'numeric', precision => 5, scale => 15 },
+ amount => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
+ cp_id => { type => 'integer' },
+ currency_id => { type => 'integer', not_null => 1 },