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:

Related articles

• Seite:
  First Steps with ownerp.io - Visual Code based on OpenVSCode
• Seite:
  Cheat Sheet für ownerp.io Shortcuts
• Seite:
  Cheat Sheet für Shell Shortcuts für Odoo Systeme basierend auf Docker
• Seite:
  Docker MyOdoo Public
• Seite:
  Cheat Sheet für VM Shell Shortcuts

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'