X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FDefault.pm;h=fe3e5f7b5266a0c9bca7a3ed408d76ad01a6eddb;hb=f769991a4bd3d207cece79bb2cb3fc96cec4602d;hp=e588b3aeb8a32906ba18f1dafedaaf59ad0db9ef;hpb=6e083cb8df993623e4810599ba9d50b035ccb250;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index e588b3aeb..fe3e5f7b5 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -10,7 +10,11 @@ __PACKAGE__->meta->table('defaults'); __PACKAGE__->meta->columns( accounting_method => { type => 'text' }, - address => { type => 'text' }, + address_city => { type => 'text' }, + address_country => { type => 'text' }, + address_street1 => { type => 'text' }, + address_street2 => { type => 'text' }, + address_zipcode => { type => 'text' }, allow_new_purchase_delivery_order => { type => 'boolean', default => 'true', not_null => 1 }, allow_new_purchase_invoice => { type => 'boolean', default => 'true', not_null => 1 }, allow_sales_invoice_from_sales_order => { type => 'boolean', default => 'true', not_null => 1 }, @@ -30,12 +34,16 @@ __PACKAGE__->meta->columns( bin_id => { type => 'integer' }, bin_id_ignore_onhand => { type => 'integer' }, businessnumber => { type => 'text' }, + carry_over_account_chart_id => { type => 'integer' }, closedto => { type => 'date' }, cnnumber => { type => 'text' }, co_ustid => { type => 'text' }, coa => { type => 'text' }, company => { type => 'text' }, + contact_departments_use_textfield => { type => 'boolean' }, + contact_titles_use_textfield => { type => 'boolean' }, create_part_if_not_found => { type => 'boolean', default => 'false' }, + create_zugferd_invoices => { type => 'integer' }, currency_id => { type => 'integer', not_null => 1 }, customer_hourly_rate => { type => 'numeric', precision => 8, scale => 2 }, customer_projects_only_in_sales => { type => 'boolean', default => 'false', not_null => 1 }, @@ -100,6 +108,7 @@ __PACKAGE__->meta->columns( itime => { type => 'timestamp', default => 'now()' }, language_id => { type => 'integer' }, letternumber => { type => 'integer' }, + loss_carried_forward_chart_id => { type => 'integer' }, max_future_booking_interval => { type => 'integer', default => 360 }, mtime => { type => 'timestamp' }, normalize_part_descriptions => { type => 'boolean', default => 'true' }, @@ -114,6 +123,7 @@ __PACKAGE__->meta->columns( pdonumber => { type => 'text' }, ponumber => { type => 'text' }, precision => { type => 'numeric', default => '0.01', not_null => 1, precision => 15, scale => 5 }, + profit_carried_forward_chart_id => { type => 'integer' }, profit_determination => { type => 'text' }, project_status_id => { type => 'integer' }, project_type_id => { type => 'integer' }, @@ -159,6 +169,7 @@ __PACKAGE__->meta->columns( 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' }, + vc_greetings_use_textfield => { type => 'boolean' }, vendornumber => { type => 'text' }, version => { type => 'varchar', length => 8 }, vertreter => { type => 'boolean', default => 'false' }, @@ -195,11 +206,26 @@ __PACKAGE__->meta->foreign_keys( key_columns => { bin_id_ignore_onhand => 'id' }, }, + carry_over_account_chart => { + class => 'SL::DB::Chart', + key_columns => { carry_over_account_chart_id => 'id' }, + }, + currency => { class => 'SL::DB::Currency', key_columns => { currency_id => 'id' }, }, + loss_carried_forward_chart => { + class => 'SL::DB::Chart', + key_columns => { loss_carried_forward_chart_id => 'id' }, + }, + + profit_carried_forward_chart => { + class => 'SL::DB::Chart', + key_columns => { profit_carried_forward_chart_id => 'id' }, + }, + project_status => { class => 'SL::DB::ProjectStatus', key_columns => { project_status_id => 'id' },