# Auswahl Debitoren, Kreditoren vorher anlegen

SELECT "party_party"."name", "account_statement_line"."move", "account_statement_line"."invoice", "account_statement_line"."date", "account_statement_line"."description" FROM "public"."account_statement_line" "account_statement_line" LEFT OUTER JOIN "public"."party_party" "party_party" ON "account_statement_line"."party" = "party_party"."id" ORDER BY "account_statement_line"."move" DESC

# Auswahl Journal inkl. Debitor und Kreditor

SELECT "account_move_line"."move", "account_move"."date", "account_move_line"."debit" "debit", "account_move_line"."credit" "credit", "party_party"."name", "account_move_line"."description" "description", "account_account"."code", "account_account"."name", "account_invoice"."number", "account_move_line"."reconciliation", "account_invoice"."reference", "DebKred"."name" FROM "public"."account_move_line" "account_move_line" LEFT OUTER JOIN "public"."account_invoice" "account_invoice" ON "account_move_line"."move" = "account_invoice"."move" LEFT OUTER JOIN "public"."party_party" "party_party" ON "account_invoice"."party" = "party_party"."id" LEFT OUTER JOIN "public"."account_account" "account_account" ON "account_move_line"."account" = "account_account"."id" LEFT OUTER JOIN "DebKred" ON "account_move_line"."move" = "DebKred"."move", "public"."account_move" "account_move" WHERE "account_move"."id" = "account_move_line"."move" ORDER BY "account_move_line"."move" DESC