X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/4ddcd46105d2a7afc41220ba51a703f9e2aef034..a89af9c2a38f19bc2834a2e09a286ff36c9ef3d7:/SL/DB/MetaSetup/Default.pm diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index 49628afe6..496336480 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -16,12 +16,15 @@ __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' }, assemblynumber => { type => 'text' }, + assortmentnumber => { type => 'text' }, balance_startdate_method => { type => 'text' }, bin_id => { type => 'integer' }, bin_id_ignore_onhand => { type => 'integer' }, @@ -40,7 +43,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 +50,18 @@ __PACKAGE__->meta->columns( duns => { type => 'text' }, email_journal => { type => 'integer', default => 2 }, expense_accno_id => { type => 'integer' }, + fa_bufa_nr => { type => 'text' }, + fa_dauerfrist => { type => 'text' }, + fa_steuerberater_city => { type => 'text' }, + fa_steuerberater_name => { type => 'text' }, + fa_steuerberater_street => { type => 'text' }, + fa_steuerberater_tel => { type => 'text' }, + fa_voranmeld => { type => 'text' }, + 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,28 +84,34 @@ __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', 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' }, 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' }, sdonumber => { type => 'text' }, sepa_creditor_id => { type => 'text' }, + sepa_reference_add_vc_vc_id => { type => 'boolean', default => 'false' }, servicenumber => { type => 'text' }, show_bestbefore => { type => 'boolean', default => 'false' }, show_longdescription_select_item => { type => 'boolean', default => 'false' }, @@ -105,6 +125,7 @@ __PACKAGE__->meta->columns( transfer_default_ignore_onhand => { type => 'boolean', default => 'false' }, transfer_default_services => { type => 'boolean', default => 'true' }, transfer_default_use_master_default_bin => { type => 'boolean', default => 'false' }, + transfer_default_warehouse_for_assembly => { type => 'boolean', default => 'false' }, transport_cost_reminder_article_number_id => { type => 'integer' }, vendornumber => { type => 'text' }, version => { type => 'varchar', length => 8 }, @@ -121,6 +142,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' },