{"id":2077,"date":"2024-01-31T18:47:35","date_gmt":"2024-01-31T18:47:35","guid":{"rendered":"https:\/\/flace.de\/?p=2077"},"modified":"2024-04-22T16:45:49","modified_gmt":"2024-04-22T16:45:49","slug":"eingangsrechnungsbuch-kost1-kstktr-fuellen","status":"publish","type":"post","link":"https:\/\/flace.de\/?p=2077","title":{"rendered":"Eingangsrechnungsbuch Kost1 und Kost2 f\u00fcllen neues WW2"},"content":{"rendered":"\n<p>Vorgang in rebbuchung &#8211; Diese Felder werden mit dem Wert gef\u00fcllt<br>0 = Projekt                                               f\u00fcllt  fkprojnr<br>2 = Regie                                                   f\u00fcllt  Vorgangsnr<br>4 = Bestell    f\u00fcllt                                    f\u00fcllt  fkBestellnr<br>5 = Wartungsauftrag                          f\u00fcllt  Vorgangsnr<br>9 = Sonstiges                                          NULL <\/p>\n\n\n\n<p class=\"has-vivid-cyan-blue-color has-text-color\">Auf Basis der Checkliste sollten die Informationen zur\u00fcckkommen, wie im Eingangsrechnungsbuch bei der Datev Schnittstelle die Felder Kost1 und Kost2 gef\u00fcllt werden sollen.<br><br><\/p>\n\n\n\n<p>select re.id,re.Bezeichnung, rb.fkKonto, rb.fkBestellNr, rb.fkProjNr, rb.vorgang, rb.VorgangsNr, rb.KstKtr,Projekt.ProjNr as pnr,Regie.ProjNr as rnr,<br>projekt.AbtNr, regie.AbtNr, regie.AnlagenNummer, bestellung.VorgangsNr, bestellung.VorgangsNr2,<br>case<br>when rb.vorgang = 0 and rb.fkBestellNr is null then rb.fkProjNr<br>when rb.Vorgang = 2 and rb.fkBestellNr is null and rb.fkProjNr is null then rb.VorgangsNr<br>when rB.vorgang = 4 and rb.fkBestellNr is not null then Bestellung.VorgangsNr<br>when rb.Vorgang = 5 and rB.fkBestellNr is null and rb.fkProjNr is null then rb.VorgangsNr<br>end as Kostentraeger,<br>case<br>when cast(rB.vorgang as nvarchar) = 0 and cast(rb.fkBestellNr as nvarchar) is null then cast(projekt.AbtNr as nvarchar)<br>when cast(rB.vorgang as nvarchar) = 2 and cast(rb.fkBestellNr as nvarchar) is null and cast(rb.fkProjNr as nvarchar) is null then cast(regie.AbtNr as nvarchar)<br>when cast(rB.vorgang as nvarchar) = 4 and cast(rb.fkBestellNr as nvarchar) is not null then cast(Bestellung.AbteilungsNr as nvarchar)<br>&#8211;when rb.Vorgang = 5 then regie.AnlagenNummer<br>when rb.Vorgang = 5 then regie.AbtNr<\/p>\n\n\n\n<p>end as Kost<\/p>\n\n\n\n<p>FROM Bestellung RIGHT OUTER JOIN rebEinRechnung as re RIGHT OUTER JOIN rebBuchung as rb<br>on re.pkER = rb.fkER LEFT OUTER JOIN Projekt ON rb.fkProjNr = Projekt.ProjNr LEFT OUTER JOIN Regie ON rB.VorgangsNr =<br>Regie.ProjNr ON Bestellung.BestellNr = rb.fkBestellNr where REDatum > &#8218;01.04.2024&#8216;<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"147\" src=\"https:\/\/flace.de\/wp-content\/uploads\/2024\/04\/image-1-1024x147.png\" alt=\"\" class=\"wp-image-2093\" srcset=\"https:\/\/flace.de\/wp-content\/uploads\/2024\/04\/image-1-1024x147.png 1024w, https:\/\/flace.de\/wp-content\/uploads\/2024\/04\/image-1-300x43.png 300w, https:\/\/flace.de\/wp-content\/uploads\/2024\/04\/image-1-768x110.png 768w, https:\/\/flace.de\/wp-content\/uploads\/2024\/04\/image-1.png 1238w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/figure>\n\n\n\n<p class=\"has-vivid-cyan-blue-color has-text-color\"><br><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vorgang in rebbuchung &#8211; Diese Felder werden mit dem Wert gef\u00fcllt0 = Projekt f\u00fcllt fkprojnr2 = Regie f\u00fcllt Vorgangsnr4 = Bestell f\u00fcllt f\u00fcllt fkBestellnr5 = Wartungsauftrag f\u00fcllt Vorgangsnr9 = Sonstiges NULL Auf Basis der Checkliste sollten die Informationen zur\u00fcckkommen, wie im Eingangsrechnungsbuch bei der Datev Schnittstelle die Felder Kost1 und Kost2 gef\u00fcllt werden sollen. select &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/flace.de\/?p=2077\" class=\"more-link\"><span class=\"screen-reader-text\">\u201eEingangsrechnungsbuch Kost1 und Kost2 f\u00fcllen neues WW2\u201c<\/span> weiterlesen<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,16],"tags":[],"class_list":["post-2077","post","type-post","status-publish","format-standard","hentry","category-infos-zur-datev-schnittstelle","category-sql"],"_links":{"self":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/2077","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2077"}],"version-history":[{"count":4,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/2077\/revisions"}],"predecessor-version":[{"id":2091,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/2077\/revisions\/2091"}],"wp:attachment":[{"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}