X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDB%2FMetaSetup%2FSepaExportItem.pm;h=81d98b321bd81e17c6f835f2e42638aaaa8eed84;hb=013804fdf4b69b04889d8bf8af182eda9e9d95a5;hp=08dd06e18963d74309530d04bbeb950c12d115cf;hpb=3eb3d1b144adb92e62de08e67dc6ff3d39bf7483;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/SepaExportItem.pm b/SL/DB/MetaSetup/SepaExportItem.pm index 08dd06e18..81d98b321 100644 --- a/SL/DB/MetaSetup/SepaExportItem.pm +++ b/SL/DB/MetaSetup/SepaExportItem.pm @@ -9,21 +9,25 @@ use base qw(SL::DB::Object); __PACKAGE__->meta->table('sepa_export_items'); __PACKAGE__->meta->columns( - amount => { type => 'numeric', precision => 5, scale => 25 }, - ap_id => { type => 'integer' }, - ar_id => { type => 'integer' }, - chart_id => { type => 'integer', not_null => 1 }, - end_to_end_id => { type => 'varchar', length => 35 }, - executed => { type => 'boolean', default => 'false' }, - execution_date => { type => 'date' }, - id => { type => 'integer', not_null => 1, sequence => 'id' }, - our_bic => { type => 'varchar', length => 100 }, - our_iban => { type => 'varchar', length => 100 }, - reference => { type => 'varchar', length => 35 }, - requested_execution_date => { type => 'date' }, - sepa_export_id => { type => 'integer', not_null => 1 }, - vc_bic => { type => 'varchar', length => 100 }, - vc_iban => { type => 'varchar', length => 100 }, + amount => { type => 'numeric', precision => 25, scale => 5 }, + ap_id => { type => 'integer' }, + ar_id => { type => 'integer' }, + chart_id => { type => 'integer', not_null => 1 }, + end_to_end_id => { type => 'varchar', length => 35 }, + executed => { type => 'boolean', default => 'false' }, + execution_date => { type => 'date' }, + id => { type => 'integer', not_null => 1, sequence => 'id' }, + our_bic => { type => 'varchar', length => 100 }, + our_depositor => { type => 'text' }, + our_iban => { type => 'varchar', length => 100 }, + reference => { type => 'varchar', length => 35 }, + requested_execution_date => { type => 'date' }, + sepa_export_id => { type => 'integer', not_null => 1 }, + vc_bic => { type => 'varchar', length => 100 }, + vc_depositor => { type => 'text' }, + vc_iban => { type => 'varchar', length => 100 }, + vc_mandate_date_of_signature => { type => 'date' }, + vc_mandator_id => { type => 'text' }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]);