city => { type => 'varchar', length => 75 },
country => { type => 'varchar', length => 75 },
contact => { type => 'varchar', length => 75 },
- phone => { type => 'varchar', length => 30 },
+ phone => { type => 'text' },
fax => { type => 'varchar', length => 30 },
homepage => { type => 'text' },
email => { type => 'text' },
vendornumber => { type => 'text' },
cc => { type => 'text' },
bcc => { type => 'text' },
- gifi_accno => { type => 'text' },
business_id => { type => 'integer' },
taxnumber => { type => 'text' },
discount => { type => 'float', precision => 4 },
bank_code => { type => 'varchar', length => 10 },
bank => { type => 'text' },
language => { type => 'varchar', length => 5 },
- datevexport => { type => 'integer' },
itime => { type => 'timestamp', default => 'now()' },
mtime => { type => 'timestamp' },
obsolete => { type => 'boolean', default => 'false' },
taxzone_id => { type => 'integer', default => '0', not_null => 1 },
greeting => { type => 'text' },
ustid => { type => 'varchar', length => 14 },
- direct_debit => { type => 'boolean', default => 'false' },
iban => { type => 'varchar', length => 100 },
bic => { type => 'varchar', length => 100 },
- curr => { type => 'character', length => 3 },
+ direct_debit => { type => 'boolean', default => 'false' },
+ currency_id => { type => 'integer', not_null => 1 },
],
primary_key_columns => [ 'id' ],
- allow_inline_column_values => 1,
-
foreign_keys => [
business => {
class => 'SL::DB::Business',