X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FCustomer.pm;h=1537bf6c3088aa9075eb16877d61c1463bf3bb93;hb=4ee26bcc22fa980555706ca24323ee9c552c1303;hp=d65b0b37b76216ba419680956bc041369fdaf0d0;hpb=4ad83535d690476c4d279eb57741612835a3bc60;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm index d65b0b37b..1537bf6c3 100644 --- a/SL/DB/MetaSetup/Customer.pm +++ b/SL/DB/MetaSetup/Customer.pm @@ -20,7 +20,7 @@ __PACKAGE__->meta->columns( city => { type => 'varchar', length => 75 }, contact => { type => 'text' }, country => { type => 'varchar', length => 75 }, - creditlimit => { type => 'numeric', default => '0', precision => 5, scale => 15 }, + creditlimit => { type => 'numeric', default => '0', precision => 15, scale => 5 }, currency_id => { type => 'integer', not_null => 1 }, customernumber => { type => 'text' }, delivery_term_id => { type => 'integer' }, @@ -28,11 +28,12 @@ __PACKAGE__->meta->columns( department_2 => { type => 'varchar', length => 75 }, depositor => { type => 'text' }, direct_debit => { type => 'boolean', default => 'false' }, - discount => { type => 'float', precision => 4 }, + discount => { type => 'float', scale => 4 }, email => { type => 'text' }, fax => { type => 'varchar', length => 30 }, greeting => { type => 'text' }, homepage => { type => 'text' }, + hourly_rate => { type => 'numeric', precision => 2, scale => 8 }, iban => { type => 'varchar', length => 100 }, id => { type => 'integer', not_null => 1, sequence => 'id' }, itime => { type => 'timestamp', default => 'now()' }, @@ -89,11 +90,6 @@ __PACKAGE__->meta->foreign_keys( class => 'SL::DB::PaymentTerm', key_columns => { payment_id => 'id' }, }, - - salesman => { - class => 'SL::DB::Employee', - key_columns => { salesman_id => 'id' }, - }, ); 1;