Korrekturen in den Kostenstellen

Folgende Tabellen müssen geändert werden, denn es zu Korrekturen im Namen kommen soll.

# Update
update "public"."account_analytic_account" set "name"='Werbekosten Allgemein' where "id"='574';
update "public"."account_analytic_plan" set "name"='411000 Werbekosten Allgemein' where "id"='575';
update "public"."account_analytic_plan_instance" set "name"='411000 Werbekosten Allgemein' where "id"='576';
update "public"."account_analytic_plan_line" set "name"='411000 Werbekosten Allgemein' where "id"='36';


# Löschen
delete from "public"."account_analytic_plan_instance" where "id"='613';
delete from "public"."account_analytic_plan" where "id"='612';
delete from "public"."account_analytic_plan_line" where "id"='73';

# "account_analytic_plan_instance_line" ist mittels analytic_account_id mit "account_analytic_account" vebunden
delete from "public"."account_analytic_plan_instance_line" where "id"='613'; 
delete from "public"."account_analytic_account" where "id"='611';



Zusammenfassung:



update "public"."account_analytic_plan" set "name"='411000 Werbekosten Allgemein' where "id"='575' 

update "public"."account_analytic_plan" set "name"='411000 Werbekosten Allgemein' where "id"='575'