X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/e0e3eee4eb59b7d6fbe17fe9ad12167b6b8a388b..e170abc7bd6b1087bd2a942a5bd60c20471e1943:/SL/DB/MetaSetup/Order.pm diff --git a/SL/DB/MetaSetup/Order.pm b/SL/DB/MetaSetup/Order.pm index 3e4a3102f..92bb92ffd 100644 --- a/SL/DB/MetaSetup/Order.pm +++ b/SL/DB/MetaSetup/Order.pm @@ -9,7 +9,7 @@ use base qw(SL::DB::Object); __PACKAGE__->meta->table('oe'); __PACKAGE__->meta->columns( - amount => { type => 'numeric', precision => 5, scale => 15 }, + amount => { type => 'numeric', precision => 15, scale => 5 }, closed => { type => 'boolean', default => 'false' }, cp_id => { type => 'integer' }, currency_id => { type => 'integer', not_null => 1 }, @@ -21,16 +21,18 @@ __PACKAGE__->meta->columns( delivery_vendor_id => { type => 'integer' }, department_id => { type => 'integer' }, employee_id => { type => 'integer' }, + expected_billing_date => { type => 'date' }, globalproject_id => { type => 'integer' }, id => { type => 'integer', not_null => 1, sequence => 'id' }, intnotes => { type => 'text' }, itime => { type => 'timestamp', default => 'now()' }, language_id => { type => 'integer' }, - marge_percent => { type => 'numeric', precision => 5, scale => 15 }, - marge_total => { type => 'numeric', precision => 5, scale => 15 }, + marge_percent => { type => 'numeric', precision => 15, scale => 5 }, + marge_total => { type => 'numeric', precision => 15, scale => 5 }, mtime => { type => 'timestamp' }, - netamount => { type => 'numeric', precision => 5, scale => 15 }, + netamount => { type => 'numeric', precision => 15, scale => 5 }, notes => { type => 'text' }, + order_probability => { type => 'integer', default => '0', not_null => 1 }, ordnumber => { type => 'text', not_null => 1 }, payment_id => { type => 'integer' }, proforma => { type => 'boolean', default => 'false' },