From a3511b2d8974c72e4d26b2d85c5cf1cd711ccb6f Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 4 Mar 2014 13:13:47 +0100 Subject: [PATCH] MetaSetups mit RDBO >= 0.809 neu bauen MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Siehe 6c22ee7eb1f64431bade6f361259737ed23b7ecc für die Erläuterung. --- SL/DB/MetaSetup/AccTransaction.pm | 2 +- SL/DB/MetaSetup/Assembly.pm | 2 +- SL/DB/MetaSetup/Business.pm | 2 +- SL/DB/MetaSetup/CustomVariable.pm | 2 +- SL/DB/MetaSetup/Customer.pm | 4 ++-- SL/DB/MetaSetup/DeliveryOrderItem.pm | 14 +++++++------- SL/DB/MetaSetup/DeliveryOrderItemsStock.pm | 2 +- SL/DB/MetaSetup/Dunning.pm | 4 ++-- SL/DB/MetaSetup/DunningConfig.pm | 4 ++-- SL/DB/MetaSetup/Exchangerate.pm | 4 ++-- SL/DB/MetaSetup/Inventory.pm | 2 +- SL/DB/MetaSetup/Invoice.pm | 10 +++++----- SL/DB/MetaSetup/InvoiceItem.pm | 22 +++++++++++----------- SL/DB/MetaSetup/MakeModel.pm | 2 +- SL/DB/MetaSetup/Order.pm | 8 ++++---- SL/DB/MetaSetup/OrderItem.pm | 20 ++++++++++---------- SL/DB/MetaSetup/Part.pm | 14 +++++++------- SL/DB/MetaSetup/PaymentTerm.pm | 2 +- SL/DB/MetaSetup/Price.pm | 2 +- SL/DB/MetaSetup/PriceFactor.pm | 2 +- SL/DB/MetaSetup/PurchaseInvoice.pm | 6 +++--- SL/DB/MetaSetup/SepaExportItem.pm | 2 +- SL/DB/MetaSetup/Tax.pm | 2 +- SL/DB/MetaSetup/Unit.pm | 2 +- SL/DB/MetaSetup/Vendor.pm | 4 ++-- 25 files changed, 70 insertions(+), 70 deletions(-) diff --git a/SL/DB/MetaSetup/AccTransaction.pm b/SL/DB/MetaSetup/AccTransaction.pm index ae3f0f65e..a3fedebc0 100644 --- 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 2890e8572..d8de3312a 100644 --- 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 b522f7c87..ff6e3d083 100644 --- 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 81af026fb..82307c0b0 100644 --- 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 0f523a466..a12aa1050 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,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 7735c9ea8..00bce8886 100644 --- 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 4263531f6..4324c9356 100644 --- 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 7de6fc8cf..b38a0b0e9 100644 --- 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 61e2db30f..91a504a23 100644 --- 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 4f83da32a..7b90ab217 100644 --- 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 a71f7601e..28ea1d940 100644 --- 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 1a8d1f00d..f024a75e8 100644 --- 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 d527f76f5..e788b5f6c 100644 --- 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 64f4d2a85..f210e6393 100644 --- 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 3e4a3102f..7f9357313 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 }, @@ -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 66d2ad261..7a30dc8ee 100644 --- 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 b5e25772c..556ff8e30 100644 --- 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 cba2de7d2..7dd067f6b 100644 --- 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 d1c35dc8b..bef079492 100644 --- 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 efdb47fa4..a67b805eb 100644 --- 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 5aa278566..d2d60043e 100644 --- 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 f2b325d85..81d98b321 100644 --- 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 b0dc314b8..dcc0d11e6 100644 --- 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 d8d47afac..d0ef2f7fb 100644 --- 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 0493aa374..067e21ada 100644 --- 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' }, -- 2.20.1