AssortmentItem um Boolean "charge" erweitert

[mfinanz.git] / SL / DB / MetaSetup / AccTransaction.pm

diff --git a/SL/DB/MetaSetup/AccTransaction.pm b/SL/DB/MetaSetup/AccTransaction.pm
index 7bc07d08e23f597049e8599dbb6e88858f405f92..23a1b17665d011080e98896a360eb80910cce996 100644 (file)
--- a/SL/DB/MetaSetup/AccTransaction.pm
+++ b/SL/DB/MetaSetup/AccTransaction.pm
@@ -4,29 +4,29 @@ package SL::DB::AccTransaction;
 
 use strict;
 
 
 use strict;
 

-use base qw(SL::DB::Object);
+use parent qw(SL::DB::Object);

 
 __PACKAGE__->meta->table('acc_trans');
 
 __PACKAGE__->meta->columns(
   acc_trans_id   => { type => 'bigint', not_null => 1, sequence => 'acc_trans_id_seq' },
 
 __PACKAGE__->meta->table('acc_trans');
 
 __PACKAGE__->meta->columns(
   acc_trans_id   => { type => 'bigint', not_null => 1, sequence => 'acc_trans_id_seq' },

-  trans_id       => { type => 'integer', not_null => 1 },
+  amount         => { type => 'numeric', precision => 15, scale => 5 },
+  cb_transaction => { type => 'boolean', default => 'false', not_null => 1 },

   chart_id       => { type => 'integer', not_null => 1 },
   chart_id       => { type => 'integer', not_null => 1 },

-  amount         => { type => 'numeric', precision => 5, scale => 15 },
-  transdate      => { type => 'date', default => 'now' },
-  gldate         => { type => 'date', default => 'now' },
-  source         => { type => 'text' },
+  chart_link     => { type => 'text', not_null => 1 },

   cleared        => { type => 'boolean', default => 'false', not_null => 1 },
   fx_transaction => { type => 'boolean', default => 'false', not_null => 1 },
   cleared        => { type => 'boolean', default => 'false', not_null => 1 },
   fx_transaction => { type => 'boolean', default => 'false', not_null => 1 },

-  ob_transaction => { type => 'boolean', default => 'false', not_null => 1 },
-  cb_transaction => { type => 'boolean', default => 'false', not_null => 1 },
-  project_id     => { type => 'integer' },
-  memo           => { type => 'text' },
-  taxkey         => { type => 'integer' },
+  gldate         => { type => 'date', default => 'now' },

   itime          => { type => 'timestamp', default => 'now()' },
   itime          => { type => 'timestamp', default => 'now()' },

+  memo           => { type => 'text' },

   mtime          => { type => 'timestamp' },
   mtime          => { type => 'timestamp' },

+  ob_transaction => { type => 'boolean', default => 'false', not_null => 1 },
+  project_id     => { type => 'integer' },
+  source         => { type => 'text' },

   tax_id         => { type => 'integer', not_null => 1 },
   tax_id         => { type => 'integer', not_null => 1 },

-  chart_link     => { type => 'text', not_null => 1 },
+  taxkey         => { type => 'integer' },
+  trans_id       => { type => 'integer', not_null => 1 },
+  transdate      => { type => 'date', default => 'now' },

 );
 
 __PACKAGE__->meta->primary_key_columns([ 'acc_trans_id' ]);
 );
 
 __PACKAGE__->meta->primary_key_columns([ 'acc_trans_id' ]);


@@ -50,7 +50,5 @@ __PACKAGE__->meta->foreign_keys(
   },
 );
 
   },
 );
 

-# __PACKAGE__->meta->initialize;
-

 1;
 ;
 1;
 ;