From f228ac9bf50df653eeb8efffaaa485fb945f50cb Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Mon, 2 Sep 2019 12:24:42 +0200 Subject: [PATCH] =?utf8?q?Rose:=20MetaSetups=20bzgl.=20Flie=C3=9Fkommazahl?= =?utf8?q?en=20erneuert?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/Assembly.pm | 2 +- SL/DB/MetaSetup/AssortmentItem.pm | 2 +- SL/DB/MetaSetup/Business.pm | 2 +- SL/DB/MetaSetup/DeliveryOrderItem.pm | 4 ++-- SL/DB/MetaSetup/InvoiceItem.pm | 8 ++++---- SL/DB/MetaSetup/OrderItem.pm | 8 ++++---- SL/DB/MetaSetup/PaymentTerm.pm | 2 +- SL/DB/MetaSetup/Vendor.pm | 2 +- 8 files changed, 15 insertions(+), 15 deletions(-) diff --git a/SL/DB/MetaSetup/Assembly.pm b/SL/DB/MetaSetup/Assembly.pm index 47eb3cf3d..4e8fe0e5e 100644 --- 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 9f217430b..8bd1611b5 100644 --- 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 64adf69ce..08c2d1055 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', 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 3a6cd9af0..7d24d1ca2 100644 --- 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 2da0d7f18..85b8876be 100644 --- 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 9de8b7e79..16478b149 100644 --- 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 6ba8c00de..876474e84 100644 --- 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 e3a1b93d4..8be59fe1d 100644 --- 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' }, -- 2.20.1