X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FDefault.pm;h=f762f34709ecb5e039e78255c59b0f3da9031071;hb=e09f2da35e02b34569254b5d1550aa5dd287761f;hp=accab2995a10acea07f630159c9ddaf5033a6ff6;hpb=317450cb2e2514d838616562fc478dad2009d103;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index accab2995..f762f3470 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -4,7 +4,7 @@ package SL::DB::Default; use strict; -use base qw(SL::DB::Object); +use parent qw(SL::DB::Object); __PACKAGE__->meta->table('defaults'); @@ -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,13 +42,12 @@ __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 }, - delivery_plan_show_value_of_goods => { type => 'boolean', default => 'false', not_null => 1 }, disabled_price_sources => { type => 'array' }, dunning_ar => { type => 'integer' }, dunning_ar_amount_fee => { type => 'integer' }, dunning_ar_amount_interest => { type => 'integer' }, duns => { type => 'text' }, + email_journal => { type => 'integer', default => 2 }, expense_accno_id => { type => 'integer' }, fxgain_accno_id => { type => 'integer' }, fxloss_accno_id => { type => 'integer' }, @@ -61,19 +62,26 @@ __PACKAGE__->meta->columns( ir_show_mark_as_paid => { type => 'boolean', default => 'true' }, is_changeable => { type => 'integer', default => 2, not_null => 1 }, is_show_mark_as_paid => { type => 'boolean', default => 'true' }, + is_transfer_out => { type => 'boolean', default => 'false', not_null => 1 }, itime => { type => 'timestamp', default => 'now()' }, language_id => { type => 'integer' }, + letternumber => { type => 'integer' }, max_future_booking_interval => { type => 'integer', default => 360 }, mtime => { type => 'timestamp' }, 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', 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' }, reqdate_interval => { type => 'integer', default => '0' }, @@ -82,6 +90,8 @@ __PACKAGE__->meta->columns( revtrans => { type => 'boolean', default => 'false' }, rfqnumber => { type => 'text' }, rmanumber => { type => 'text' }, + 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' }, @@ -89,6 +99,7 @@ __PACKAGE__->meta->columns( sepa_creditor_id => { type => 'text' }, servicenumber => { type => 'text' }, show_bestbefore => { type => 'boolean', default => 'false' }, + show_longdescription_select_item => { type => 'boolean', default => 'false' }, show_weight => { type => 'boolean', default => 'false', not_null => 1 }, signature => { type => 'text' }, sonumber => { type => 'text' }, @@ -115,6 +126,15 @@ __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' }, @@ -130,6 +150,16 @@ __PACKAGE__->meta->foreign_keys( key_columns => { currency_id => 'id' }, }, + project_status => { + class => 'SL::DB::ProjectStatus', + key_columns => { project_status_id => 'id' }, + }, + + project_type => { + class => 'SL::DB::ProjectType', + key_columns => { project_type_id => 'id' }, + }, + requirement_spec_section_order_part => { class => 'SL::DB::Part', key_columns => { requirement_spec_section_order_part_id => 'id' },