| 12345678910111213 |
- 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
|
