X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/3eb3d1b144adb92e62de08e67dc6ff3d39bf7483..a3511b2d8974c72e4d26b2d85c5cf1cd711ccb6f:/SL/DB/MetaSetup/PurchaseInvoice.pm 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' },