- id => { type => 'integer', not_null => 1, sequence => 'id' },
- ordnumber => { type => 'text', not_null => 1 },
- transdate => { type => 'date', default => 'now' },
- vendor_id => { type => 'integer' },
- customer_id => { type => 'integer' },
- amount => { type => 'numeric', precision => 5, scale => 15 },
- netamount => { type => 'numeric', precision => 5, scale => 15 },
- reqdate => { type => 'date' },
- taxincluded => { type => 'boolean' },
- shippingpoint => { type => 'text' },
- notes => { type => 'text' },
- employee_id => { type => 'integer' },