MetaSetups mit RDBO >= 0.809 neu bauen

Siehe 6c22ee7eb1f64431bade6f361259737ed23b7ecc für die Erläuterung.

diff --git a/SL/DB/MetaSetup/AccTransaction.pm b/SL/DB/MetaSetup/AccTransaction.pm
index ae3f0f65e6c6fe457446a1c73ba7e7c7c99a8676..a3fedebc072cf904443ec802988c5e7bb7413246 100644 (file)
--- a/SL/DB/MetaSetup/AccTransaction.pm
+++ b/SL/DB/MetaSetup/AccTransaction.pm
@@ -10,7 +10,7 @@ __PACKAGE__->meta->table('acc_trans');
 
 __PACKAGE__->meta->columns(
   acc_trans_id   => { type => 'bigint', not_null => 1, sequence => 'acc_trans_id_seq' },
-  amount         => { type => 'numeric', precision => 5, scale => 15 },
+  amount         => { type => 'numeric', precision => 15, scale => 5 },
   cb_transaction => { type => 'boolean', default => 'false', not_null => 1 },
   chart_id       => { type => 'integer', not_null => 1 },
   chart_link     => { type => 'text', not_null => 1 },

diff --git a/SL/DB/MetaSetup/Assembly.pm b/SL/DB/MetaSetup/Assembly.pm
index 2890e8572995eecc9910272cf811f9c8033e222d..d8de3312a67a7090ff37174f0a9235e7c8069011 100644 (file)
--- a/SL/DB/MetaSetup/Assembly.pm
+++ b/SL/DB/MetaSetup/Assembly.pm
@@ -15,7 +15,7 @@ __PACKAGE__->meta->columns(
   itime       => { type => 'timestamp', default => 'now()' },
   mtime       => { type => 'timestamp' },
   parts_id    => { type => 'integer' },
-  qty         => { type => 'float', precision => 4 },
+  qty         => { type => 'float', scale => 4 },
 );
 
 __PACKAGE__->meta->primary_key_columns([ 'assembly_id' ]);

diff --git a/SL/DB/MetaSetup/Business.pm b/SL/DB/MetaSetup/Business.pm
index b522f7c87e233fab336545be713d9edfb5c6eb30..ff6e3d0831a133ce8527ef31f25c242a4f88e22e 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', precision => 4 },
+  discount           => { type => 'float', scale => 4 },
   id                 => { type => 'integer', not_null => 1, sequence => 'id' },
   itime              => { type => 'timestamp', default => 'now()' },
   mtime              => { type => 'timestamp' },

diff --git a/SL/DB/MetaSetup/CustomVariable.pm b/SL/DB/MetaSetup/CustomVariable.pm
index 81af026fba6ef2d3b79b6d67cc1572748f039c77..82307c0b051e0a10cd9a6de5eb40c9cf56d69480 100644 (file)
--- a/SL/DB/MetaSetup/CustomVariable.pm
+++ b/SL/DB/MetaSetup/CustomVariable.pm
@@ -14,7 +14,7 @@ __PACKAGE__->meta->columns(
   id              => { type => 'integer', not_null => 1, sequence => 'custom_variables_id' },
   itime           => { type => 'timestamp', default => 'now()' },
   mtime           => { type => 'timestamp' },
-  number_value    => { type => 'numeric', precision => 5, scale => 25 },
+  number_value    => { type => 'numeric', precision => 25, scale => 5 },
   sub_module      => { type => 'text', default => '', not_null => 1 },
   text_value      => { type => 'text' },
   timestamp_value => { type => 'timestamp' },

diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm
index 0f523a46625c9a0b857a3a5cc3fe6471938dc97b..a12aa1050c564b07ac80cf76348f346d08f24f6c 100644 (file)
--- 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,7 +28,7 @@ __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' },

diff --git a/SL/DB/MetaSetup/DeliveryOrderItem.pm b/SL/DB/MetaSetup/DeliveryOrderItem.pm
index 7735c9ea891ef6f4d23ed0dc11156576b305bd5e..00bce88867214e00235bc4556fb2d517a3a8d2a2 100644 (file)
--- a/SL/DB/MetaSetup/DeliveryOrderItem.pm
+++ b/SL/DB/MetaSetup/DeliveryOrderItem.pm
@@ -9,26 +9,26 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('delivery_order_items');
 
 __PACKAGE__->meta->columns(
-  base_qty           => { type => 'float', precision => 4 },
+  base_qty           => { type => 'float', scale => 4 },
   cusordnumber       => { type => 'text' },
   delivery_order_id  => { type => 'integer', not_null => 1 },
   description        => { type => 'text' },
-  discount           => { type => 'float', precision => 4 },
+  discount           => { type => 'float', scale => 4 },
   id                 => { type => 'integer', not_null => 1, sequence => 'delivery_order_items_id' },
   itime              => { type => 'timestamp', default => 'now()' },
-  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
+  lastcost           => { type => 'numeric', precision => 15, scale => 5 },
   longdescription    => { type => 'text' },
-  marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
+  marge_price_factor => { type => 'numeric', default => 1, precision => 15, scale => 5 },
   mtime              => { type => 'timestamp' },
   ordnumber          => { type => 'text' },
   parts_id           => { type => 'integer', not_null => 1 },
-  price_factor       => { type => 'numeric', default => 1, precision => 5, scale => 15 },
+  price_factor       => { type => 'numeric', default => 1, precision => 15, scale => 5 },
   price_factor_id    => { type => 'integer' },
   pricegroup_id      => { type => 'integer' },
   project_id         => { type => 'integer' },
-  qty                => { type => 'numeric', precision => 5, scale => 25 },
+  qty                => { type => 'numeric', precision => 25, scale => 5 },
   reqdate            => { type => 'date' },
-  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
+  sellprice          => { type => 'numeric', precision => 15, scale => 5 },
   serialnumber       => { type => 'text' },
   transdate          => { type => 'text' },
   unit               => { type => 'varchar', length => 20 },

diff --git a/SL/DB/MetaSetup/DeliveryOrderItemsStock.pm b/SL/DB/MetaSetup/DeliveryOrderItemsStock.pm
index 4263531f6012734e192ed35416f9c01dd0ede217..4324c9356ea0307908713175465def7cf77ea714 100644 (file)
--- a/SL/DB/MetaSetup/DeliveryOrderItemsStock.pm
+++ b/SL/DB/MetaSetup/DeliveryOrderItemsStock.pm
@@ -16,7 +16,7 @@ __PACKAGE__->meta->columns(
   id                     => { type => 'integer', not_null => 1, sequence => 'id' },
   itime                  => { type => 'timestamp', default => 'now()' },
   mtime                  => { type => 'timestamp' },
-  qty                    => { type => 'numeric', not_null => 1, precision => 5, scale => 15 },
+  qty                    => { type => 'numeric', not_null => 1, precision => 15, scale => 5 },
   unit                   => { type => 'varchar', length => 20, not_null => 1 },
   warehouse_id           => { type => 'integer', not_null => 1 },
 );

diff --git a/SL/DB/MetaSetup/Dunning.pm b/SL/DB/MetaSetup/Dunning.pm
index 7de6fc8cf316493d6c704931a9e226cf5e929899..b38a0b0e9c7ce599d67a44ae95d637a65fcd7b25 100644 (file)
--- a/SL/DB/MetaSetup/Dunning.pm
+++ b/SL/DB/MetaSetup/Dunning.pm
@@ -13,10 +13,10 @@ __PACKAGE__->meta->columns(
   dunning_config_id  => { type => 'integer' },
   dunning_id         => { type => 'integer' },
   dunning_level      => { type => 'integer' },
-  fee                => { type => 'numeric', precision => 5, scale => 15 },
+  fee                => { type => 'numeric', precision => 15, scale => 5 },
   fee_interest_ar_id => { type => 'integer' },
   id                 => { type => 'integer', not_null => 1, sequence => 'id' },
-  interest           => { type => 'numeric', precision => 5, scale => 15 },
+  interest           => { type => 'numeric', precision => 15, scale => 5 },
   itime              => { type => 'timestamp', default => 'now()' },
   mtime              => { type => 'timestamp' },
   trans_id           => { type => 'integer' },

diff --git a/SL/DB/MetaSetup/DunningConfig.pm b/SL/DB/MetaSetup/DunningConfig.pm
index 61e2db30f6151481c5de5fc2b97813ae6aa3df8d..91a504a236f88e81a67f75575f26a6faa020cba1 100644 (file)
--- a/SL/DB/MetaSetup/DunningConfig.pm
+++ b/SL/DB/MetaSetup/DunningConfig.pm
@@ -18,9 +18,9 @@ __PACKAGE__->meta->columns(
   email_attachment         => { type => 'boolean' },
   email_body               => { type => 'text' },
   email_subject            => { type => 'text' },
-  fee                      => { type => 'numeric', precision => 5, scale => 15 },
+  fee                      => { type => 'numeric', precision => 15, scale => 5 },
   id                       => { type => 'integer', not_null => 1, sequence => 'id' },
-  interest_rate            => { type => 'numeric', precision => 5, scale => 15 },
+  interest_rate            => { type => 'numeric', precision => 15, scale => 5 },
   payment_terms            => { type => 'integer' },
   template                 => { type => 'text' },
   terms                    => { type => 'integer' },

diff --git a/SL/DB/MetaSetup/Exchangerate.pm b/SL/DB/MetaSetup/Exchangerate.pm
index 4f83da32a3bf2fedb9f61518e57f07e7766e3d6a..7b90ab217bef8a20765ed584eac4fca81145a8f1 100644 (file)
--- a/SL/DB/MetaSetup/Exchangerate.pm
+++ b/SL/DB/MetaSetup/Exchangerate.pm
@@ -9,12 +9,12 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('exchangerate');
 
 __PACKAGE__->meta->columns(
-  buy         => { type => 'numeric', precision => 5, scale => 15 },
+  buy         => { type => 'numeric', precision => 15, scale => 5 },
   currency_id => { type => 'integer', not_null => 1 },
   id          => { type => 'serial', not_null => 1 },
   itime       => { type => 'timestamp', default => 'now()' },
   mtime       => { type => 'timestamp' },
-  sell        => { type => 'numeric', precision => 5, scale => 15 },
+  sell        => { type => 'numeric', precision => 15, scale => 5 },
   transdate   => { type => 'date' },
 );
 

diff --git a/SL/DB/MetaSetup/Inventory.pm b/SL/DB/MetaSetup/Inventory.pm
index a71f7601e75918cd8c5566fb90892f773b02a232..28ea1d940557f974a668512fa4ed7a38826f3e25 100644 (file)
--- a/SL/DB/MetaSetup/Inventory.pm
+++ b/SL/DB/MetaSetup/Inventory.pm
@@ -21,7 +21,7 @@ __PACKAGE__->meta->columns(
   orderitems_id => { type => 'integer' },
   parts_id      => { type => 'integer', not_null => 1 },
   project_id    => { type => 'integer' },
-  qty           => { type => 'numeric', precision => 5, scale => 25 },
+  qty           => { type => 'numeric', precision => 25, scale => 5 },
   shippingdate  => { type => 'date' },
   trans_id      => { type => 'integer', not_null => 1 },
   trans_type_id => { type => 'integer', not_null => 1 },

diff --git a/SL/DB/MetaSetup/Invoice.pm b/SL/DB/MetaSetup/Invoice.pm
index 1a8d1f00d4db9c115809f01933b80c21a5091cff..f024a75e838ed2b2da350281e3e8c2f4bb217f1b 100644 (file)
--- a/SL/DB/MetaSetup/Invoice.pm
+++ b/SL/DB/MetaSetup/Invoice.pm
@@ -9,7 +9,7 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('ar');
 
 __PACKAGE__->meta->columns(
-  amount                    => { type => 'numeric', precision => 5, scale => 15 },
+  amount                    => { type => 'numeric', precision => 15, scale => 5 },
   cp_id                     => { type => 'integer' },
   currency_id               => { type => 'integer', not_null => 1 },
   cusordnumber              => { type => 'text' },
@@ -34,14 +34,14 @@ __PACKAGE__->meta->columns(
   invoice                   => { type => 'boolean', default => 'false' },
   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' },
   orddate                   => { type => 'date' },
   ordnumber                 => { type => 'text' },
-  paid                      => { type => 'numeric', precision => 5, scale => 15 },
+  paid                      => { type => 'numeric', precision => 15, scale => 5 },
   payment_id                => { type => 'integer' },
   quodate                   => { type => 'date' },
   quonumber                 => { type => 'text' },

diff --git a/SL/DB/MetaSetup/InvoiceItem.pm b/SL/DB/MetaSetup/InvoiceItem.pm
index d527f76f53497cbfb9fd14c1ff8d2c719929c204..e788b5f6c0c67bcd38cb6ece927c5d03c85d03d7 100644 (file)
--- a/SL/DB/MetaSetup/InvoiceItem.pm
+++ b/SL/DB/MetaSetup/InvoiceItem.pm
@@ -9,30 +9,30 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('invoice');
 
 __PACKAGE__->meta->columns(
-  allocated          => { type => 'float', precision => 4 },
+  allocated          => { type => 'float', scale => 4 },
   assemblyitem       => { type => 'boolean', default => 'false' },
-  base_qty           => { type => 'float', precision => 4 },
+  base_qty           => { type => 'float', scale => 4 },
   cusordnumber       => { type => 'text' },
   deliverydate       => { type => 'date' },
   description        => { type => 'text' },
-  discount           => { type => 'float', precision => 4 },
-  fxsellprice        => { type => 'numeric', precision => 5, scale => 15 },
+  discount           => { type => 'float', scale => 4 },
+  fxsellprice        => { type => 'numeric', precision => 15, scale => 5 },
   id                 => { type => 'integer', not_null => 1, sequence => 'invoiceid' },
   itime              => { type => 'timestamp', default => 'now()' },
-  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
+  lastcost           => { type => 'numeric', precision => 15, scale => 5 },
   longdescription    => { type => 'text' },
-  marge_percent      => { type => 'numeric', precision => 5, scale => 15 },
-  marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
-  marge_total        => { type => 'numeric', precision => 5, scale => 15 },
+  marge_percent      => { type => 'numeric', precision => 15, scale => 5 },
+  marge_price_factor => { type => 'numeric', default => 1, precision => 15, scale => 5 },
+  marge_total        => { type => 'numeric', precision => 15, scale => 5 },
   mtime              => { type => 'timestamp' },
   ordnumber          => { type => 'text' },
   parts_id           => { type => 'integer' },
-  price_factor       => { type => 'numeric', default => 1, precision => 5, scale => 15 },
+  price_factor       => { type => 'numeric', default => 1, precision => 15, scale => 5 },
   price_factor_id    => { type => 'integer' },
   pricegroup_id      => { type => 'integer' },
   project_id         => { type => 'integer' },
-  qty                => { type => 'float', precision => 4 },
-  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
+  qty                => { type => 'float', scale => 4 },
+  sellprice          => { type => 'numeric', precision => 15, scale => 5 },
   serialnumber       => { type => 'text' },
   subtotal           => { type => 'boolean', default => 'false' },
   trans_id           => { type => 'integer' },

diff --git a/SL/DB/MetaSetup/MakeModel.pm b/SL/DB/MetaSetup/MakeModel.pm
index 64f4d2a8547cfed18596a34bab9c3a64b3a92f4c..f210e639330be89b359ddac1f82e7fc1ab38f177 100644 (file)
--- a/SL/DB/MetaSetup/MakeModel.pm
+++ b/SL/DB/MetaSetup/MakeModel.pm
@@ -11,7 +11,7 @@ __PACKAGE__->meta->table('makemodel');
 __PACKAGE__->meta->columns(
   id         => { type => 'serial', not_null => 1 },
   itime      => { type => 'timestamp', default => 'now()' },
-  lastcost   => { type => 'numeric', precision => 5, scale => 15 },
+  lastcost   => { type => 'numeric', precision => 15, scale => 5 },
   lastupdate => { type => 'date' },
   make       => { type => 'integer' },
   model      => { type => 'text' },

diff --git a/SL/DB/MetaSetup/Order.pm b/SL/DB/MetaSetup/Order.pm
index 3e4a3102fcbde6c9974c4e173af2bafdbed71269..7f935731344d5d8658830a0e4c59d607054e5d34 100644 (file)
--- 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 },
@@ -26,10 +26,10 @@ __PACKAGE__->meta->columns(
   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' },
   ordnumber               => { type => 'text', not_null => 1 },
   payment_id              => { type => 'integer' },

diff --git a/SL/DB/MetaSetup/OrderItem.pm b/SL/DB/MetaSetup/OrderItem.pm
index 66d2ad2613e9eb6a2ee4dfed22e4e5a369dce579..7a30dc8ee40eb0d39d80446f012b466ae24927e6 100644 (file)
--- a/SL/DB/MetaSetup/OrderItem.pm
+++ b/SL/DB/MetaSetup/OrderItem.pm
@@ -9,29 +9,29 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('orderitems');
 
 __PACKAGE__->meta->columns(
-  base_qty           => { type => 'float', precision => 4 },
+  base_qty           => { type => 'float', scale => 4 },
   cusordnumber       => { type => 'text' },
   description        => { type => 'text' },
-  discount           => { type => 'float', precision => 4 },
+  discount           => { type => 'float', scale => 4 },
   id                 => { type => 'integer', not_null => 1, sequence => 'orderitemsid' },
   itime              => { type => 'timestamp', default => 'now()' },
-  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
+  lastcost           => { type => 'numeric', precision => 15, scale => 5 },
   longdescription    => { type => 'text' },
-  marge_percent      => { type => 'numeric', precision => 5, scale => 15 },
-  marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 },
-  marge_total        => { type => 'numeric', precision => 5, scale => 15 },
+  marge_percent      => { type => 'numeric', precision => 15, scale => 5 },
+  marge_price_factor => { type => 'numeric', default => 1, precision => 15, scale => 5 },
+  marge_total        => { type => 'numeric', precision => 15, scale => 5 },
   mtime              => { type => 'timestamp' },
   ordnumber          => { type => 'text' },
   parts_id           => { type => 'integer' },
-  price_factor       => { type => 'numeric', default => 1, precision => 5, scale => 15 },
+  price_factor       => { type => 'numeric', default => 1, precision => 15, scale => 5 },
   price_factor_id    => { type => 'integer' },
   pricegroup_id      => { type => 'integer' },
   project_id         => { type => 'integer' },
-  qty                => { type => 'float', precision => 4 },
+  qty                => { type => 'float', scale => 4 },
   reqdate            => { type => 'date' },
-  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
+  sellprice          => { type => 'numeric', precision => 15, scale => 5 },
   serialnumber       => { type => 'text' },
-  ship               => { type => 'float', precision => 4 },
+  ship               => { type => 'float', scale => 4 },
   subtotal           => { type => 'boolean', default => 'false' },
   trans_id           => { type => 'integer' },
   transdate          => { type => 'text' },

diff --git a/SL/DB/MetaSetup/Part.pm b/SL/DB/MetaSetup/Part.pm
index b5e25772c42648e86932396d7189f1b1b7ca06cb..556ff8e30336198e115e97bcef782fb69e6e1e69 100644 (file)
--- a/SL/DB/MetaSetup/Part.pm
+++ b/SL/DB/MetaSetup/Part.pm
@@ -19,35 +19,35 @@ __PACKAGE__->meta->columns(
   ean                => { type => 'text' },
   expense_accno_id   => { type => 'integer' },
   formel             => { type => 'text' },
-  gv                 => { type => 'numeric', precision => 5, scale => 15 },
+  gv                 => { type => 'numeric', precision => 15, scale => 5 },
   has_sernumber      => { type => 'boolean', default => 'false' },
   id                 => { type => 'integer', not_null => 1, sequence => 'id' },
   image              => { type => 'text' },
   income_accno_id    => { type => 'integer' },
   inventory_accno_id => { type => 'integer' },
   itime              => { type => 'timestamp', default => 'now()' },
-  lastcost           => { type => 'numeric', precision => 5, scale => 15 },
-  listprice          => { type => 'numeric', precision => 5, scale => 15 },
+  lastcost           => { type => 'numeric', precision => 15, scale => 5 },
+  listprice          => { type => 'numeric', precision => 15, scale => 5 },
   makemodel          => { type => 'boolean', default => 'false' },
   microfiche         => { type => 'text' },
   mtime              => { type => 'timestamp' },
   not_discountable   => { type => 'boolean', default => 'false' },
   notes              => { type => 'text' },
   obsolete           => { type => 'boolean', default => 'false' },
-  onhand             => { type => 'numeric', default => '0', precision => 5, scale => 25 },
+  onhand             => { type => 'numeric', default => '0', precision => 25, scale => 5 },
   partnumber         => { type => 'text', not_null => 1 },
   partsgroup_id      => { type => 'integer' },
   payment_id         => { type => 'integer' },
   price_factor_id    => { type => 'integer' },
   priceupdate        => { type => 'date', default => 'now' },
-  rop                => { type => 'float', precision => 4 },
-  sellprice          => { type => 'numeric', precision => 5, scale => 15 },
+  rop                => { type => 'float', scale => 4 },
+  sellprice          => { type => 'numeric', precision => 15, scale => 5 },
   shop               => { type => 'boolean', default => 'false' },
   stockable          => { type => 'boolean', default => 'false' },
   unit               => { type => 'varchar', length => 20, not_null => 1 },
   ve                 => { type => 'integer' },
   warehouse_id       => { type => 'integer' },
-  weight             => { type => 'float', precision => 4 },
+  weight             => { type => 'float', scale => 4 },
 );
 
 __PACKAGE__->meta->primary_key_columns([ 'id' ]);

diff --git a/SL/DB/MetaSetup/PaymentTerm.pm b/SL/DB/MetaSetup/PaymentTerm.pm
index cba2de7d249466241d63a9f19f2b4ce1537184cf..7dd067f6b098cb115484ccbcb3486ddd3b7932f2 100644 (file)
--- a/SL/DB/MetaSetup/PaymentTerm.pm
+++ b/SL/DB/MetaSetup/PaymentTerm.pm
@@ -14,7 +14,7 @@ __PACKAGE__->meta->columns(
   id               => { type => 'integer', not_null => 1, sequence => 'id' },
   itime            => { type => 'timestamp', default => 'now()' },
   mtime            => { type => 'timestamp' },
-  percent_skonto   => { type => 'float', precision => 4 },
+  percent_skonto   => { type => 'float', scale => 4 },
   ranking          => { type => 'integer' },
   sortkey          => { type => 'integer', not_null => 1 },
   terms_netto      => { type => 'integer' },

diff --git a/SL/DB/MetaSetup/Price.pm b/SL/DB/MetaSetup/Price.pm
index d1c35dc8bb1c3021d17874e9ec3c20c254a56711..bef079492a903d66725483813a92f8045bf4f5fc 100644 (file)
--- a/SL/DB/MetaSetup/Price.pm
+++ b/SL/DB/MetaSetup/Price.pm
@@ -11,7 +11,7 @@ __PACKAGE__->meta->table('prices');
 __PACKAGE__->meta->columns(
   id            => { type => 'serial', not_null => 1 },
   parts_id      => { type => 'integer' },
-  price         => { type => 'numeric', precision => 5, scale => 15 },
+  price         => { type => 'numeric', precision => 15, scale => 5 },
   pricegroup_id => { type => 'integer' },
 );
 

diff --git a/SL/DB/MetaSetup/PriceFactor.pm b/SL/DB/MetaSetup/PriceFactor.pm
index efdb47fa4ca18bc0e12573e9f16e29bb87c2217d..a67b805eb1a24416a5f0007f7042005f8e069b48 100644 (file)
--- a/SL/DB/MetaSetup/PriceFactor.pm
+++ b/SL/DB/MetaSetup/PriceFactor.pm
@@ -10,7 +10,7 @@ __PACKAGE__->meta->table('price_factors');
 
 __PACKAGE__->meta->columns(
   description => { type => 'text' },
-  factor      => { type => 'numeric', precision => 5, scale => 15 },
+  factor      => { type => 'numeric', precision => 15, scale => 5 },
   id          => { type => 'integer', not_null => 1, sequence => 'id' },
   sortkey     => { type => 'integer' },
 );

diff --git a/SL/DB/MetaSetup/PurchaseInvoice.pm b/SL/DB/MetaSetup/PurchaseInvoice.pm
index 5aa2785668d2af22838ba1740e9e4e1905170971..d2d60043e7e1697a78d0f9889bf3f4d6466f7088 100644 (file)
--- a/SL/DB/MetaSetup/PurchaseInvoice.pm
+++ b/SL/DB/MetaSetup/PurchaseInvoice.pm
@@ -9,7 +9,7 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('ap');
 
 __PACKAGE__->meta->columns(
-  amount                  => { type => 'numeric', precision => 5, scale => 15 },
+  amount                  => { type => 'numeric', precision => 15, scale => 5 },
   cp_id                   => { type => 'integer' },
   currency_id             => { type => 'integer', not_null => 1 },
   datepaid                => { type => 'date' },
@@ -28,11 +28,11 @@ __PACKAGE__->meta->columns(
   itime                   => { type => 'timestamp', default => 'now()' },
   language_id             => { type => 'integer' },
   mtime                   => { type => 'timestamp' },
-  netamount               => { type => 'numeric', precision => 5, scale => 15 },
+  netamount               => { type => 'numeric', precision => 15, scale => 5 },
   notes                   => { type => 'text' },
   orddate                 => { type => 'date' },
   ordnumber               => { type => 'text' },
-  paid                    => { type => 'numeric', precision => 5, scale => 15 },
+  paid                    => { type => 'numeric', precision => 15, scale => 5 },
   payment_id              => { type => 'integer' },
   quodate                 => { type => 'date' },
   quonumber               => { type => 'text' },

diff --git a/SL/DB/MetaSetup/SepaExportItem.pm b/SL/DB/MetaSetup/SepaExportItem.pm
index f2b325d8509f0cdada765dd268e3e6ebc93bd46e..81d98b321bd81e17c6f835f2e42638aaaa8eed84 100644 (file)
--- a/SL/DB/MetaSetup/SepaExportItem.pm
+++ b/SL/DB/MetaSetup/SepaExportItem.pm
@@ -9,7 +9,7 @@ use base qw(SL::DB::Object);
 __PACKAGE__->meta->table('sepa_export_items');
 
 __PACKAGE__->meta->columns(
-  amount                       => { type => 'numeric', precision => 5, scale => 25 },
+  amount                       => { type => 'numeric', precision => 25, scale => 5 },
   ap_id                        => { type => 'integer' },
   ar_id                        => { type => 'integer' },
   chart_id                     => { type => 'integer', not_null => 1 },

diff --git a/SL/DB/MetaSetup/Tax.pm b/SL/DB/MetaSetup/Tax.pm
index b0dc314b8df717399fdab5713b79c40276ba0d47..dcc0d11e6c29272785caded083551a1a1e71c4e7 100644 (file)
--- a/SL/DB/MetaSetup/Tax.pm
+++ b/SL/DB/MetaSetup/Tax.pm
@@ -14,7 +14,7 @@ __PACKAGE__->meta->columns(
   id               => { type => 'integer', not_null => 1, sequence => 'id' },
   itime            => { type => 'timestamp', default => 'now()' },
   mtime            => { type => 'timestamp' },
-  rate             => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
+  rate             => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },
   taxdescription   => { type => 'text', not_null => 1 },
   taxkey           => { type => 'integer', not_null => 1 },
   taxnumber        => { type => 'text' },

diff --git a/SL/DB/MetaSetup/Unit.pm b/SL/DB/MetaSetup/Unit.pm
index d8d47afac1df863fb84149c9210983b4372b17ef..d0ef2f7fb664415a43fb8073c53ab09eb9c9e669 100644 (file)
--- a/SL/DB/MetaSetup/Unit.pm
+++ b/SL/DB/MetaSetup/Unit.pm
@@ -10,7 +10,7 @@ __PACKAGE__->meta->table('units');
 
 __PACKAGE__->meta->columns(
   base_unit => { type => 'varchar', length => 20 },
-  factor    => { type => 'numeric', precision => 5, scale => 20 },
+  factor    => { type => 'numeric', precision => 20, scale => 5 },
   id        => { type => 'serial', not_null => 1 },
   name      => { type => 'varchar', length => 20, not_null => 1 },
   sortkey   => { type => 'integer', not_null => 1 },

diff --git a/SL/DB/MetaSetup/Vendor.pm b/SL/DB/MetaSetup/Vendor.pm
index 0493aa3744de4a42c8f3662b4b507372f0929bbc..067e21adadbdcc7e82b2c03115a001c1d3841e2b 100644 (file)
--- a/SL/DB/MetaSetup/Vendor.pm
+++ b/SL/DB/MetaSetup/Vendor.pm
@@ -19,14 +19,14 @@ __PACKAGE__->meta->columns(
   city             => { type => 'varchar', length => 75 },
   contact          => { type => 'varchar', length => 75 },
   country          => { type => 'varchar', length => 75 },
-  creditlimit      => { type => 'numeric', precision => 5, scale => 15 },
+  creditlimit      => { type => 'numeric', precision => 15, scale => 5 },
   currency_id      => { type => 'integer', not_null => 1 },
   delivery_term_id => { type => 'integer' },
   department_1     => { type => 'varchar', length => 75 },
   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' },