X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/422f2f17365ea7879c14b902c5db1e4cd7023e48..bb8edc8e935cc8d4699e071f645d511f6262d03b:/SL/DB/MetaSetup/Default.pm diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index 20610fd3b..bd02674dd 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -16,8 +16,10 @@ __PACKAGE__->meta->columns( allow_sales_invoice_from_sales_order => { type => 'boolean', default => 'true', not_null => 1 }, allow_sales_invoice_from_sales_quotation => { type => 'boolean', default => 'true', not_null => 1 }, ap_changeable => { type => 'integer', default => 2, not_null => 1 }, + ap_chart_id => { type => 'integer' }, ap_show_mark_as_paid => { type => 'boolean', default => 'true' }, ar_changeable => { type => 'integer', default => 2, not_null => 1 }, + ar_chart_id => { type => 'integer' }, ar_paid_accno_id => { type => 'integer' }, ar_show_mark_as_paid => { type => 'boolean', default => 'true' }, articlenumber => { type => 'text' }, @@ -40,7 +42,6 @@ __PACKAGE__->meta->columns( datev_check_on_gl_transaction => { type => 'boolean', default => 'true' }, datev_check_on_purchase_invoice => { type => 'boolean', default => 'true' }, datev_check_on_sales_invoice => { type => 'boolean', default => 'true' }, - delivery_plan_calculate_transferred_do => { type => 'boolean', default => 'false', not_null => 1 }, disabled_price_sources => { type => 'array' }, dunning_ar => { type => 'integer' }, dunning_ar_amount_fee => { type => 'integer' }, @@ -48,6 +49,11 @@ __PACKAGE__->meta->columns( duns => { type => 'text' }, email_journal => { type => 'integer', default => 2 }, expense_accno_id => { type => 'integer' }, + feature_balance => { type => 'boolean', default => 'true', not_null => 1 }, + feature_datev => { type => 'boolean', default => 'true', not_null => 1 }, + feature_erfolgsrechnung => { type => 'boolean', default => 'false', not_null => 1 }, + feature_eurechnung => { type => 'boolean', default => 'true', not_null => 1 }, + feature_ustva => { type => 'boolean', default => 'true', not_null => 1 }, fxgain_accno_id => { type => 'integer' }, fxloss_accno_id => { type => 'integer' }, gl_changeable => { type => 'integer', default => 2, not_null => 1 }, @@ -70,26 +76,28 @@ __PACKAGE__->meta->columns( normalize_part_descriptions => { type => 'boolean', default => 'true' }, normalize_vc_names => { type => 'boolean', default => 'true' }, order_always_project => { type => 'boolean', default => 'false' }, + order_warn_duplicate_parts => { type => 'boolean', default => 'true' }, parts_image_css => { type => 'text', default => 'border:0;float:left;max-width:250px;margin-top:20px:margin-right:10px;margin-left:10px;' }, parts_listing_image => { type => 'boolean', default => 'true' }, parts_show_image => { type => 'boolean', default => 'true' }, payments_changeable => { type => 'integer', default => '0', not_null => 1 }, pdonumber => { type => 'text' }, ponumber => { type => 'text' }, - precision => { type => 'numeric', precision => 15, scale => 5, default => '0.01', not_null => 1 }, + precision => { type => 'numeric', default => '0.01', not_null => 1, precision => 15, scale => 5 }, profit_determination => { type => 'text' }, project_status_id => { type => 'integer' }, project_type_id => { type => 'integer' }, purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' }, purchase_order_show_delete => { type => 'boolean', default => 'true' }, + quick_search_modules => { type => 'array' }, reqdate_interval => { type => 'integer', default => '0' }, require_transaction_description_ps => { type => 'boolean', default => 'false', not_null => 1 }, requirement_spec_section_order_part_id => { type => 'integer' }, revtrans => { type => 'boolean', default => 'false' }, rfqnumber => { type => 'text' }, rmanumber => { type => 'text' }, - rndgain_accno_id => { type => 'integer'}, - rndloss_accno_id => { type => 'integer'}, + rndgain_accno_id => { type => 'integer' }, + rndloss_accno_id => { type => 'integer' }, sales_delivery_order_show_delete => { type => 'boolean', default => 'true' }, sales_order_show_delete => { type => 'boolean', default => 'true' }, sales_purchase_order_ship_missing_column => { type => 'boolean', default => 'false' }, @@ -124,6 +132,16 @@ __PACKAGE__->meta->primary_key_columns([ 'id' ]); __PACKAGE__->meta->allow_inline_column_values(1); __PACKAGE__->meta->foreign_keys( + ap_chart => { + class => 'SL::DB::Chart', + key_columns => { ap_chart_id => 'id' }, + }, + + ar_chart => { + class => 'SL::DB::Chart', + key_columns => { ar_chart_id => 'id' }, + }, + bin => { class => 'SL::DB::Bin', key_columns => { bin_id => 'id' },