X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FPurchaseInvoice.pm;h=d2d60043e7e1697a78d0f9889bf3f4d6466f7088;hb=0194799c9cd192f01db7df4cf056e18871c979e0;hp=4b89dca767a9dff7d59c2a0cf42d4738fe6aa56e;hpb=3eb3d1b144adb92e62de08e67dc6ff3d39bf7483;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/PurchaseInvoice.pm b/SL/DB/MetaSetup/PurchaseInvoice.pm index 4b89dca76..d2d60043e 100644 --- a/SL/DB/MetaSetup/PurchaseInvoice.pm +++ b/SL/DB/MetaSetup/PurchaseInvoice.pm @@ -9,10 +9,11 @@ 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' }, + delivery_term_id => { type => 'integer' }, deliverydate => { type => 'date' }, department_id => { type => 'integer' }, direct_debit => { type => 'boolean', default => 'false' }, @@ -27,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' }, @@ -61,6 +62,11 @@ __PACKAGE__->meta->foreign_keys( key_columns => { currency_id => 'id' }, }, + delivery_term => { + class => 'SL::DB::DeliveryTerm', + key_columns => { delivery_term_id => 'id' }, + }, + department => { class => 'SL::DB::Department', key_columns => { department_id => 'id' },