select distinct T1."document_type" as "Document Type",
	   T1."nominal_account_number" as "Nominal Account Number",
	   T1."customer_contra_account" as "Customer Contra Account",
	   T1."invoice_number" as "Invoice Number",
	   T1."skr51_branch" as "Skr51 Branch",
	   '1' as "Rechtseinheit",
	   '0' + ((convert(varchar(50), T1."skr51_branch"))) as "Betrieb",
	   '1' as "Mandant",
	   '1' as "Hauptbetrieb",
	   ('0' + ((convert(varchar(50), T1."skr51_branch")))) as "Standort"
from "journal_accountings" T1
where (((T1."nominal_account_number" IN (8520)) and (T1."document_type" = 'R')) and (T1."invoice_date" >= convert(date, '2016-01-01')))
-- order by "Invoice Number" asc,"Nominal Account Number" asc