X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDB%2FMetaSetup%2FGLTransaction.pm;h=f5925136219366ada2fcda75a9568739a0e886e6;hb=f24cf1f5ab8428ced545a382d0f0179ae6f40a81;hp=c8019ebcf10a3951bad953283143ab2ce105d4a6;hpb=b8b112a39bd601b0bc717646d78de470631da22a;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/GLTransaction.pm b/SL/DB/MetaSetup/GLTransaction.pm index c8019ebcf..f59251362 100644 --- a/SL/DB/MetaSetup/GLTransaction.pm +++ b/SL/DB/MetaSetup/GLTransaction.pm @@ -4,27 +4,28 @@ package SL::DB::GLTransaction; use strict; -use base qw(SL::DB::Object); +use parent qw(SL::DB::Object); __PACKAGE__->meta->table('gl'); __PACKAGE__->meta->columns( - id => { type => 'integer', not_null => 1, sequence => 'glid' }, - reference => { type => 'text' }, + cb_transaction => { type => 'boolean' }, + deliverydate => { type => 'date' }, + department_id => { type => 'integer' }, description => { type => 'text' }, - transdate => { type => 'date', default => 'now' }, - gldate => { type => 'date', default => 'now' }, employee_id => { type => 'integer' }, - notes => { type => 'text' }, - department_id => { type => 'integer' }, - taxincluded => { type => 'boolean' }, + gldate => { type => 'date', default => 'now' }, + id => { type => 'integer', not_null => 1, sequence => 'glid' }, itime => { type => 'timestamp', default => 'now()' }, mtime => { type => 'timestamp' }, - type => { type => 'text' }, + notes => { type => 'text' }, + ob_transaction => { type => 'boolean' }, + reference => { type => 'text' }, storno => { type => 'boolean', default => 'false' }, storno_id => { type => 'integer' }, - ob_transaction => { type => 'boolean' }, - cb_transaction => { type => 'boolean' }, + taxincluded => { type => 'boolean' }, + transdate => { type => 'date', default => 'now' }, + type => { type => 'text' }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); @@ -37,21 +38,16 @@ __PACKAGE__->meta->foreign_keys( key_columns => { department_id => 'id' }, }, + employee => { + class => 'SL::DB::Employee', + key_columns => { employee_id => 'id' }, + }, + storno_obj => { class => 'SL::DB::GLTransaction', key_columns => { storno_id => 'id' }, }, ); -__PACKAGE__->meta->relationships( - gl => { - class => 'SL::DB::GLTransaction', - column_map => { id => 'storno_id' }, - type => 'one to many', - }, -); - -# __PACKAGE__->meta->initialize; - 1; ;