- id => { type => 'integer', not_null => 1, sequence => 'id' },
- vc_id => { type => 'integer', not_null => 1 },
- rcv_name => { type => 'text' },
- rcv_contact => { type => 'text' },
- rcv_address => { type => 'text' },
- rcv_countrycode => { type => 'text' },
- rcv_zipcode => { type => 'text' },
- rcv_city => { type => 'text' },
- letternumber => { type => 'text' },
- jobnumber => { type => 'text' },
- text_created_for => { type => 'text' },
- date => { type => 'text' },
- subject => { type => 'text' },
- greeting => { type => 'text' },
- body => { type => 'text' },
- close => { type => 'text' },
- company_name => { type => 'text' },
- employee_id => { type => 'integer' },
- employee_position => { type => 'text' },
- salesman_id => { type => 'integer' },
- salesman_position => { type => 'text' },
- itime => { type => 'timestamp', default => 'now()' },
- mtime => { type => 'timestamp' },
- rcv_country => { type => 'text' },
- page_created_for => { type => 'text' },
- cp_id => { type => 'integer' },
+ body => { type => 'text' },
+ cp_id => { type => 'integer' },
+ customer_id => { type => 'integer' },
+ date => { type => 'date' },
+ employee_id => { type => 'integer' },
+ greeting => { type => 'text' },
+ id => { type => 'integer', not_null => 1, sequence => 'id' },
+ intnotes => { type => 'text' },
+ itime => { type => 'timestamp', default => 'now()' },
+ letternumber => { type => 'text' },
+ mtime => { type => 'timestamp' },
+ reference => { type => 'text' },
+ salesman_id => { type => 'integer' },
+ subject => { type => 'text' },
+ vendor_id => { type => 'integer' },