X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FSepaExportItem.pm;h=cd2152bedba059930dd1b9431db93782ca92c98a;hb=87e65e6c1cc64bfb2d73b6914ed2ef136861dd42;hp=b9899c2e5079fb082fe5c48bef54202748784879;hpb=4fd22b569d4436293e0a9d364d7356b5bfc503e5;p=kivitendo-erp.git

diff --git a/SL/DB/MetaSetup/SepaExportItem.pm b/SL/DB/MetaSetup/SepaExportItem.pm
index b9899c2e5..cd2152bed 100644
--- a/SL/DB/MetaSetup/SepaExportItem.pm
+++ b/SL/DB/MetaSetup/SepaExportItem.pm
@@ -12,7 +12,7 @@ __PACKAGE__->meta->setup(
   columns => [
     id                       => { type => 'integer', not_null => 1, sequence => 'id' },
     sepa_export_id           => { type => 'integer', not_null => 1 },
-    ap_id                    => { type => 'integer', not_null => 1 },
+    ap_id                    => { type => 'integer' },
     chart_id                 => { type => 'integer', not_null => 1 },
     amount                   => { type => 'numeric', precision => 5, scale => 25 },
     reference                => { type => 'varchar', length => 35 },
@@ -21,9 +21,10 @@ __PACKAGE__->meta->setup(
     execution_date           => { type => 'date' },
     our_iban                 => { type => 'varchar', length => 100 },
     our_bic                  => { type => 'varchar', length => 100 },
-    vendor_iban              => { type => 'varchar', length => 100 },
-    vendor_bic               => { type => 'varchar', length => 100 },
+    vc_iban                  => { type => 'varchar', length => 100 },
+    vc_bic                   => { type => 'varchar', length => 100 },
     end_to_end_id            => { type => 'varchar', length => 35 },
+    ar_id                    => { type => 'integer' },
   ],
 
   primary_key_columns => [ 'id' ],
@@ -34,6 +35,11 @@ __PACKAGE__->meta->setup(
       key_columns => { ap_id => 'id' },
     },
 
+    ar => {
+      class       => 'SL::DB::Invoice',
+      key_columns => { ar_id => 'id' },
+    },
+
     chart => {
       class       => 'SL::DB::Chart',
       key_columns => { chart_id => 'id' },