Rose: MetaSetups bzgl. Fließkommazahlen erneuert

diff --git a/SL/DB/MetaSetup/Assembly.pm b/SL/DB/MetaSetup/Assembly.pm
index 47eb3cf3dae9af6fe6bb6f301ec1fa04c165c1d2..4e8fe0e5e1a803ea7fbe2fec513dfb39bf4265e8 100644 (file)
--- a/SL/DB/MetaSetup/Assembly.pm
+++ b/SL/DB/MetaSetup/Assembly.pm
@@ -16,7 +16,7 @@ __PACKAGE__->meta->columns(
   mtime       => { type => 'timestamp' },
   parts_id    => { type => 'integer', not_null => 1 },
   position    => { type => 'integer' },
-  qty         => { type => 'float', scale => 4 },
+  qty         => { type => 'float', precision => 4, scale => 4 },
 );
 
 __PACKAGE__->meta->primary_key_columns([ 'assembly_id' ]);

diff --git a/SL/DB/MetaSetup/AssortmentItem.pm b/SL/DB/MetaSetup/AssortmentItem.pm
index 9f217430bff07ea9cb6af70f73453bdb442da3ac..8bd1611b59033f46d8fc1e8d6d6fef157cfdca96 100644 (file)
--- a/SL/DB/MetaSetup/AssortmentItem.pm
+++ b/SL/DB/MetaSetup/AssortmentItem.pm
@@ -15,7 +15,7 @@ __PACKAGE__->meta->columns(
   mtime         => { type => 'timestamp' },
   parts_id      => { type => 'integer', not_null => 1 },
   position      => { type => 'integer', not_null => 1 },
-  qty           => { type => 'float', not_null => 1, scale => 4 },
+  qty           => { type => 'float', not_null => 1, precision => 4, scale => 4 },
   unit          => { type => 'varchar', length => 20, not_null => 1 },
 );
 

diff --git a/SL/DB/MetaSetup/Business.pm b/SL/DB/MetaSetup/Business.pm
index 64adf69ceb7600339e654c2dd6cd52f67e3c34c2..08c2d10559bddf1421b663a856341cf48cc6515a 100644 (file)
--- a/SL/DB/MetaSetup/Business.pm
+++ b/SL/DB/MetaSetup/Business.pm
@@ -11,7 +11,7 @@ __PACKAGE__->meta->table('business');
 __PACKAGE__->meta->columns(
   customernumberinit => { type => 'text' },
   description        => { type => 'text' },
-  discount           => { type => 'float', scale => 4 },
+  discount           => { type => 'float', precision => 4, scale => 4 },
   id                 => { type => 'integer', not_null => 1, sequence => 'id' },
   itime              => { type => 'timestamp', default => 'now()' },
   mtime              => { type => 'timestamp' },

diff --git a/SL/DB/MetaSetup/DeliveryOrderItem.pm b/SL/DB/MetaSetup/DeliveryOrderItem.pm
index 3a6cd9af0481e30dd3977a46433adee0f7d38b79..7d24d1ca28081edd3966ff8700f7cf7b215b6550 100644 (file)
--- a/SL/DB/MetaSetup/DeliveryOrderItem.pm
+++ b/SL/DB/MetaSetup/DeliveryOrderItem.pm
@@ -11,11 +11,11 @@ __PACKAGE__->meta->table('delivery_order_items');
 __PACKAGE__->meta->columns(
   active_discount_source => { type => 'text', default => '', not_null => 1 },
   active_price_source    => { type => 'text', default => '', not_null => 1 },
-  base_qty               => { type => 'float', scale => 4 },
+  base_qty               => { type => 'float', precision => 4, scale => 4 },
   cusordnumber           => { type => 'text' },
   delivery_order_id      => { type => 'integer', not_null => 1 },
   description            => { type => 'text' },
-  discount               => { type => 'float', scale => 4 },
+  discount               => { type => 'float', precision => 4, scale => 4 },
   id                     => { type => 'integer', not_null => 1, sequence => 'delivery_order_items_id' },
   itime                  => { type => 'timestamp', default => 'now()' },
   lastcost               => { type => 'numeric', precision => 15, scale => 5 },

diff --git a/SL/DB/MetaSetup/InvoiceItem.pm b/SL/DB/MetaSetup/InvoiceItem.pm
index 2da0d7f18a8b35b20e74603257d6813c00f97aa9..85b8876be8712bc0488583dea19c2ddce3612bbd 100644 (file)
--- a/SL/DB/MetaSetup/InvoiceItem.pm
+++ b/SL/DB/MetaSetup/InvoiceItem.pm
@@ -11,13 +11,13 @@ __PACKAGE__->meta->table('invoice');
 __PACKAGE__->meta->columns(
   active_discount_source => { type => 'text', default => '', not_null => 1 },
   active_price_source    => { type => 'text', default => '', not_null => 1 },
-  allocated              => { type => 'float', scale => 4 },
+  allocated              => { type => 'float', precision => 4, scale => 4 },
   assemblyitem           => { type => 'boolean', default => 'false' },
-  base_qty               => { type => 'float', scale => 4 },
+  base_qty               => { type => 'float', precision => 4, scale => 4 },
   cusordnumber           => { type => 'text' },
   deliverydate           => { type => 'date' },
   description            => { type => 'text' },
-  discount               => { type => 'float', scale => 4 },
+  discount               => { type => 'float', precision => 4, scale => 4 },
   donumber               => { type => 'text' },
   fxsellprice            => { type => 'numeric', precision => 15, scale => 5 },
   id                     => { type => 'integer', not_null => 1, sequence => 'invoiceid' },
@@ -35,7 +35,7 @@ __PACKAGE__->meta->columns(
   price_factor_id        => { type => 'integer' },
   pricegroup_id          => { type => 'integer' },
   project_id             => { type => 'integer' },
-  qty                    => { type => 'float', scale => 4 },
+  qty                    => { type => 'float', precision => 4, scale => 4 },
   sellprice              => { type => 'numeric', precision => 15, scale => 5 },
   serialnumber           => { type => 'text' },
   subtotal               => { type => 'boolean', default => 'false' },

diff --git a/SL/DB/MetaSetup/OrderItem.pm b/SL/DB/MetaSetup/OrderItem.pm
index 9de8b7e796e5247c979ffb0f2b94a806ecd2393c..16478b1498e780e2bf176d589683bed2c39b777a 100644 (file)
--- a/SL/DB/MetaSetup/OrderItem.pm
+++ b/SL/DB/MetaSetup/OrderItem.pm
@@ -11,10 +11,10 @@ __PACKAGE__->meta->table('orderitems');
 __PACKAGE__->meta->columns(
   active_discount_source => { type => 'text', default => '', not_null => 1 },
   active_price_source    => { type => 'text', default => '', not_null => 1 },
-  base_qty               => { type => 'float', scale => 4 },
+  base_qty               => { type => 'float', precision => 4, scale => 4 },
   cusordnumber           => { type => 'text' },
   description            => { type => 'text' },
-  discount               => { type => 'float', scale => 4 },
+  discount               => { type => 'float', precision => 4, scale => 4 },
   id                     => { type => 'integer', not_null => 1, sequence => 'orderitemsid' },
   itime                  => { type => 'timestamp', default => 'now()' },
   lastcost               => { type => 'numeric', precision => 15, scale => 5 },
@@ -30,11 +30,11 @@ __PACKAGE__->meta->columns(
   price_factor_id        => { type => 'integer' },
   pricegroup_id          => { type => 'integer' },
   project_id             => { type => 'integer' },
-  qty                    => { type => 'float', scale => 4 },
+  qty                    => { type => 'float', precision => 4, scale => 4 },
   reqdate                => { type => 'date' },
   sellprice              => { type => 'numeric', precision => 15, scale => 5 },
   serialnumber           => { type => 'text' },
-  ship                   => { type => 'float', scale => 4 },
+  ship                   => { type => 'float', precision => 4, scale => 4 },
   subtotal               => { type => 'boolean', default => 'false' },
   trans_id               => { type => 'integer' },
   transdate              => { type => 'text' },

diff --git a/SL/DB/MetaSetup/PaymentTerm.pm b/SL/DB/MetaSetup/PaymentTerm.pm
index 6ba8c00de0a86dffab7331882947de28e708e163..876474e846a6e6d0ab2299fbcbe4a4c762c5188c 100644 (file)
--- a/SL/DB/MetaSetup/PaymentTerm.pm
+++ b/SL/DB/MetaSetup/PaymentTerm.pm
@@ -17,7 +17,7 @@ __PACKAGE__->meta->columns(
   itime                    => { type => 'timestamp', default => 'now()' },
   mtime                    => { type => 'timestamp' },
   obsolete                 => { type => 'boolean', default => 'false' },
-  percent_skonto           => { type => 'float', scale => 4 },
+  percent_skonto           => { type => 'float', precision => 4, scale => 4 },
   sortkey                  => { type => 'integer', not_null => 1 },
   terms_netto              => { type => 'integer' },
   terms_skonto             => { type => 'integer' },

diff --git a/SL/DB/MetaSetup/Vendor.pm b/SL/DB/MetaSetup/Vendor.pm
index e3a1b93d41be5ba7ecb74c9dc09df18543d35b96..8be59fe1da1882b3ce915d80a29d65a4b01f1998 100644 (file)
--- a/SL/DB/MetaSetup/Vendor.pm
+++ b/SL/DB/MetaSetup/Vendor.pm
@@ -26,7 +26,7 @@ __PACKAGE__->meta->columns(
   department_2     => { type => 'text' },
   depositor        => { type => 'text' },
   direct_debit     => { type => 'boolean', default => 'false' },
-  discount         => { type => 'float', scale => 4 },
+  discount         => { type => 'float', precision => 4, scale => 4 },
   email            => { type => 'text' },
   fax              => { type => 'text' },
   gln              => { type => 'text' },