X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/c09313030ba77f61771483e69179fd916d9328cd..b8b112a39bd601b0bc717646d78de470631da22a:/SL/DB/MetaSetup/PaymentTerm.pm diff --git a/SL/DB/MetaSetup/PaymentTerm.pm b/SL/DB/MetaSetup/PaymentTerm.pm index 4e18f5df0..3eda536ac 100644 --- a/SL/DB/MetaSetup/PaymentTerm.pm +++ b/SL/DB/MetaSetup/PaymentTerm.pm @@ -6,26 +6,58 @@ use strict; use base qw(SL::DB::Object); -__PACKAGE__->meta->setup( - table => 'payment_terms', - - columns => [ - id => { type => 'integer', not_null => 1, sequence => 'id' }, - description => { type => 'text' }, - description_long => { type => 'text' }, - terms_netto => { type => 'integer' }, - terms_skonto => { type => 'integer' }, - percent_skonto => { type => 'float', precision => 4 }, - itime => { type => 'timestamp', default => 'now()' }, - mtime => { type => 'timestamp' }, - ranking => { type => 'integer' }, - sortkey => { type => 'integer', not_null => 1 }, - ], - - primary_key_columns => [ 'id' ], - - allow_inline_column_values => 1, +__PACKAGE__->meta->table('payment_terms'); + +__PACKAGE__->meta->columns( + id => { type => 'integer', not_null => 1, sequence => 'id' }, + description => { type => 'text' }, + description_long => { type => 'text' }, + terms_netto => { type => 'integer' }, + terms_skonto => { type => 'integer' }, + percent_skonto => { type => 'float', precision => 4 }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + ranking => { type => 'integer' }, + sortkey => { type => 'integer', not_null => 1 }, +); + +__PACKAGE__->meta->primary_key_columns([ 'id' ]); + +__PACKAGE__->meta->allow_inline_column_values(1); + +__PACKAGE__->meta->relationships( + ap => { + class => 'SL::DB::PurchaseInvoice', + column_map => { id => 'payment_id' }, + type => 'one to many', + }, + + ar => { + class => 'SL::DB::Invoice', + column_map => { id => 'payment_id' }, + type => 'one to many', + }, + + customer => { + class => 'SL::DB::Customer', + column_map => { id => 'payment_id' }, + type => 'one to many', + }, + + oe => { + class => 'SL::DB::Order', + column_map => { id => 'payment_id' }, + type => 'one to many', + }, + + parts => { + class => 'SL::DB::Part', + column_map => { id => 'payment_id' }, + type => 'one to many', + }, ); +# __PACKAGE__->meta->initialize; + 1; ;