OmniShipping Internal:DHL API: Unterschied zwischen den Versionen

Zur Navigation springen Zur Suche springen
keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 1: Zeile 1:
<div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output">
<div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output">
= '''ShippingConnect DHL API Versenden einrichten''' =
= '''ShippingConnect DHL API Versenden einrichten''' =
<p style="text-align: center;">'''<span style="background-color:#d35400;">!! DIES IST EINE INTERNE ANLEITUNG UND NUR INNERHALB DER HTK GmbH & Co. KG zu nutzen&nbsp;!!</span>'''</p>  
<p style="text-align: center;">'''<span style="background-color:#d35400;">!! DIES IST EINE INTERNE ANLEITUNG UND NUR INNERHALB DER HTK GmbH & Co. KG zu nutzen&nbsp;!!</span>'''</p>  
Zeile 46: Zeile 46:
Sich kopieren und in dem Sage Shared Ordner in HTKData unter den Addins reinkopieren. Des Weiteren müssen diese Files auch noch in HTKBPM – Plugins Ordner reinkopiert werden. Ebenso wie in den Shared Ordner der Sage Installation direkt. Sprich an 3 Stellen müssen die Files vorhanden sein.
Sich kopieren und in dem Sage Shared Ordner in HTKData unter den Addins reinkopieren. Des Weiteren müssen diese Files auch noch in HTKBPM – Plugins Ordner reinkopiert werden. Ebenso wie in den Shared Ordner der Sage Installation direkt. Sprich an 3 Stellen müssen die Files vorhanden sein.


<span style="font-size:11.0pt"><span style="line-height:107%"><span style="font-family:" calibri",sans-serif"="">Nun muss man die .dll.xml der Versenden API</span></span></span>
<span style="font-size:11.0pt"><span style="line-height:107%"><span style="font-family:">Nun muss man die .dll.xml der Versenden API</span></span></span>


<span style="font-size:11.0pt"><span style="line-height:107%"><span style="font-family:" calibri",sans-serif"="">[[File:DHL API7.png]]</span></span></span>
<span style="font-size:11.0pt"><span style="line-height:107%"><span style="font-family:">[[File:DHL API7.png|RTENOTITLE]]</span></span></span>


In ein Ordner eines anderen Addins legen um diese zu „installieren“ und noch umbenennen wie das entsprechende Addin des Ordners – entweder dann den Dienst neu starten oder die .xml mit einem .update versehen. Hier im Beispiel HTKVersendenApi.dll.xml umbenannt zu HTKFTP.dll.xml und in das Addinverzeichnis des FTP Addins gelegt.
In ein Ordner eines anderen Addins legen um diese zu „installieren“ und noch umbenennen wie das entsprechende Addin des Ordners – entweder dann den Dienst neu starten oder die .xml mit einem .update versehen. Hier im Beispiel HTKVersendenApi.dll.xml umbenannt zu HTKFTP.dll.xml und in das Addinverzeichnis des FTP Addins gelegt.


[[File:API DHL8.png]]
[[File:API DHL8.png|RTENOTITLE]]


Im Anschluss den Dienst starten und das Logbuch analysieren ob hier Fehler auftauchen. Kontrollieren kann man auch ob die DHL Versenden API Pluginfiles korrekt geladen wurden in dem man im Logbuch entsprechend.
Im Anschluss den Dienst starten und das Logbuch analysieren ob hier Fehler auftauchen. Kontrollieren kann man auch ob die DHL Versenden API Pluginfiles korrekt geladen wurden in dem man im Logbuch entsprechend.
Zeile 58: Zeile 58:
Nach dem nun das Addin erfolgreich geladen wurde kann man dies als Job hinzufügen:
Nach dem nun das Addin erfolgreich geladen wurde kann man dies als Job hinzufügen:


[[File:DHL API9.png]]
[[File:DHL API9.png|RTENOTITLE]]


Als Konfiguration sollte in den DHL Einstellungen die
Als Konfiguration sollte in den DHL Einstellungen die


*<span style="font-size:10.5pt"><span style="line-height:107%"><span style="font-family:" segoe="" ui",sans-serif"="">'''ApplikationsID''': HTKShippingConnectDHL_1</span></span></span>  
*<span style="font-size:10.5pt"><span style="line-height:107%"><span style="font-family:">'''ApplikationsID''': HTKShippingConnectDHL_1</span></span></span>  
*<span style="font-size:10.5pt"><span style="line-height:107%"><span style="font-family:" segoe="" ui",sans-serif"="">'''Token''': xeUuqatLqTVfvtSr9OgYCsQieONPGu</span></span></span>  
*<span style="font-size:10.5pt"><span style="line-height:107%"><span style="font-family:">'''Token''': xeUuqatLqTVfvtSr9OgYCsQieONPGu</span></span></span>  


<span style="font-size:10.5pt"><span style="line-height:107%"><span style="font-family:" segoe="" ui",sans-serif"="">hinterlegt werden. Dies sind die von DHL freigegebenen Daten für uns.</span></span></span>
<span style="font-size:10.5pt"><span style="line-height:107%"><span style="font-family:">hinterlegt werden. Dies sind die von DHL freigegebenen Daten für uns.</span></span></span>


<span style="font-size:10.5pt"><span style="line-height:107%"><span style="font-family:" segoe="" ui",sans-serif"="">[[File:DHL API10.png]]</span></span></span>
<span style="font-size:10.5pt"><span style="line-height:107%"><span style="font-family:">[[File:DHL API10.png|RTENOTITLE]]</span></span></span>


In den Addin-Grundeinstellungen wird lediglich die Pfade sowie die SQL Abfrage für die Stornierung hinterlegt sowie ob die Sendungsnummer an OL übermittelt werden soll.
In den Addin-Grundeinstellungen wird lediglich die Pfade sowie die SQL Abfrage für die Stornierung hinterlegt sowie ob die Sendungsnummer an OL übermittelt werden soll.


[[File:DHL API11.png]]
[[File:DHL API11.png|RTENOTITLE]]


Dann wird noch ein weiterer Job im BPM benötigt die sogenannte „Datenbank Analyse“ was nur eine SQL Abfrage ist die je nach Kunde eventuell etwas angepasst werden muss.
Dann wird noch ein weiterer Job im BPM benötigt die sogenannte „Datenbank Analyse“ was nur eine SQL Abfrage ist die je nach Kunde eventuell etwas angepasst werden muss.


[[File:DHL API12.png]]
[[File:DHL API12.png|RTENOTITLE]]


Als SQL Statement kann man hier folgendes hinterlegen :
Als SQL Statement kann man hier folgendes hinterlegen&nbsp;:


'''<span style="color:red">ACHTUNG! Hier muss entsprechend der Mandant geprüft werden und die Besonderheit hier in dem Statement das wenn kein Gewicht im Artikel existiert im Beleg 1 KG eingetragen wird da ansonsten ein Fehler kommt und der Beleg nicht erzeugt werden kann.</span>'''
'''<span style="color:red">ACHTUNG! Hier muss entsprechend der Mandant geprüft werden</span>'''
<blockquote>
'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">DECLARE</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyData</span></span></span></span> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">TABLE</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">&nbsp;<br/> (&nbsp;<br/> &nbsp;&nbsp;&nbsp; [Mandant]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">SMALLINT</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">, [BelId]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">INT</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">, [Benutzer]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">VARCHAR</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">128</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">), [PaketId]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">BIGINT</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,<br/> &nbsp;&nbsp;&nbsp; [Gewicht]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">MONEY</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">, [Paketnummer]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">VARCHAR</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">MAX</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">), [Versanddienstleister]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">VARCHAR</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">MAX</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">), [GepacktAm]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">VARCHAR</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">20</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">),<br/> &nbsp;&nbsp;&nbsp; [GepacktUm]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">VARCHAR</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">7</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">), [BelegAm]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">VARCHAR</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">20</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">), [BelegUm]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">VARCHAR</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">7</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">), [ImportAm]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">VARCHAR</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">20</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">),<br/> &nbsp;&nbsp;&nbsp; [ImportUm]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">VARCHAR</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">7</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">), [Storniert]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">SMALLINT</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">, [ExportErfolgt]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">SMALLINT</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">, [Abrechnungsnummer]</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">VARCHAR</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">max</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)<br/> )</span></span></span></span><br/> <br/> <br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">INSERT</span></span></span></span>''' '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">INTO</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyData</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">([Mandant], [BelId], [Benutzer], [PaketId], [Gewicht], [Paketnummer], [Versanddienstleister],<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [GepacktAm], [GepacktUm], [BelegAm], [BelegUm], [ImportAm], [ImportUm], [Storniert], [ExportErfolgt], [Abrechnungsnummer])</span></span></span></span><br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">SELECT</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">Mandant, BelId, Bearbeiter,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">1</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">, Gewicht,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:red">'DHL (Versenden API)'</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">0</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">0</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">FROM</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">KHKVKBelege</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">WITH</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(NOLOCK)</span></span></span></span><br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">WHERE</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">Versand</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">IN</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:red">'DHL'</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)</span></span></span></span><br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">AND</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">Belegkennzeichen</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">IN</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:red">'VLL'</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:red">'VSL'</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:red">'VSD'</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)</span></span></span></span><br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">AND</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">Belegdatum >=</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:red">'25.09.2020'</span></span></span></span> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">AND</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">ISNULL</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(USER_HTKVersandExported,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">0</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">) =</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">0</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)</span></span></span></span><br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">AND</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">Mandant=</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:red">'2'</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">;</span></span></span></span><br/> <br/> <br/> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:green">--select * from @MyData</span></span></span></span>''<br/> <br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">UPDATE</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">HTKBPM_Plugins_Versanddaten</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">SET</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[Storniert] = -</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">1</span></span></span></span> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">WHERE</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">&nbsp; [Paketnummer] <></span></span></span></span>'''''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">AND</span></span></span></span>'''<br/> <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[BelId]</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">IN</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">SELECT</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[BelId]</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">from</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">HTKBPM_Plugins_Versanddaten</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">WITH</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(NOLOCK)</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">WHERE</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">BelId</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">IN</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">SELECT</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[BelId]</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">FROM</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyData</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">))</span></span></span></span><br/> <br/> <br/> <br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">DECLARE</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyMandant</span></span></span></span> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">varchar</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">max</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)</span></span></span></span><br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">DECLARE</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyBelid</span></span></span></span> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">varchar</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">max</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)</span></span></span></span><br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">DECLARE</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@User</span></span></span></span> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">varchar</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">max</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)</span></span></span></span><br/> <br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">DECLARE</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">contacts_cursor</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">CURSOR</span></span></span></span>''' '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">FOR<br/> SELECT</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">Mandant, BelId, Benutzer</span></span></span></span><br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">FROM</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyData</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">;</span></span></span></span><br/> <br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">OPEN</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">contacts_cursor;</span></span></span></span><br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">FETCH</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">NEXT</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">FROM</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">contacts_cursor</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">INTO</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyMandant</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyBelid</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@User</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">;</span></span></span></span><br/> <br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">WHILE</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@@FETCH_STATUS</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">=</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">0</span></span></span></span><br/> &nbsp;&nbsp; '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">BEGIN</span></span></span></span>'''<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">if</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyBelid</span></span></span></span> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">is</span></span></span></span>''' '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">not</span></span></span></span>''' '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">null</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">begin</span></span></span></span>'''<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">DECLARE</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@PackageId</span></span></span></span> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">int</span></span></span></span><br/> ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">DECLARE</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@PackageWeight</span></span></span></span> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">decimal</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">36</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">2</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/> <br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:green">--&nbsp; select @MyMandant, @MyBelid</span></span></span></span><br/> ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">declare</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@counter</span></span></span></span> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">int</span></span></span></span><br/> ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">Declare</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@tableCount</span></span></span></span> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:brown">int</span></span></span></span><br/> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">set</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@tableCount</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">=&nbsp;&nbsp; (</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">select</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">count</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(*)</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">from</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">fnHTKShippingCalculatePackages (</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyBelid</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyMandant</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">))<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">set</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@counter</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">=</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">1</span></span></span></span><br/> <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">While</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@counter</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36"><=</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@tableCount</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">begin</span></span></span></span>'''<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">select</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@PackageId</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">= PackageId,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@PackageWeight</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">= PackageWeight</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">from</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">fnHTKShippingCalculatePackages (</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyBelid</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyMandant</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">where</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">PackageId =</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@counter</span></span></span></span><br/> <br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">INSERT</span></span></span></span>''' '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">INTO</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">HTKBPM_Plugins_Versanddaten ([Mandant], [BelId], [Benutzer], [PaketId], [Gewicht], [Paketnummer], [Versanddienstleister],<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [GepacktAm], [GepacktUm], [BelegAm], [BelegUm], [ImportAm], [ImportUm], [Storniert], [ExportErfolgt], [Abrechnungsnummer])<br/> <br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">SELECT</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyMandant</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyBelid</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@User</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@PackageId</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@PackageWeight</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:red">'DHL (Versenden API)'</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">0</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">0</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><br/> <br/> ''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">set</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@counter</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">=</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@counter</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">+</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">1</span></span></span></span><br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">end</span></span></span></span>'''<br/> <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">FETCH</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">NEXT</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">FROM</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">contacts_cursor</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">INTO</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyMandant</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyBelid</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">,</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@User</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">;<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">end</span></span></span></span>'''<br/> &nbsp;&nbsp; '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">END</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">;</span></span></span></span><br/> <br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">CLOSE</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">contacts_cursor;</span></span></span></span><br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">DEALLOCATE</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">contacts_cursor;</span></span></span></span><br/> <br/> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">UPDATE</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[KHKVKBelege]</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">SET</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[USER_HTKVersandExported] =</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:fuchsia">1</span></span></span></span> '''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">WHERE</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[BelID]</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">in</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">SELECT</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[BelID]</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">FROM</span></span></span></span>''' <span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:maroon">@MyData</span></span></span></span><span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">)</span></span></span></span>''
</blockquote>
Im Anschluss daran muss man in der dbo.vwHTKVersenden noch eine Anpassung durchführen. Hier muss im Statement an der Stelle " HIER MUSS DIE ABRECHNUNGSNUMMER REIN" die Abrechnungsnummer des Kunden des DHL-Geschäftskundenportal rein - falls die Kunden nicht wissen was das ist und wo man dies findet [https://dhl.support.netresearch.de/support/solutions/articles/12000024658-wie-werden-die-kundennummer-ekp-und-teilnahmenummern-eingerichtet- HIER] gut erklärt.
<blockquote>
/****** Object: &nbsp;View [dbo].[vWHTkVersenden] &nbsp; &nbsp;Script Date: 02.03.2021 14:35:40 ******/<br/> SET ANSI_NULLS ON<br/> GO


SET QUOTED_IDENTIFIER ON<br/> GO
<br/> &nbsp;&nbsp; &nbsp;ALTER VIEW [dbo].[vWHTkVersenden] AS<br/> &nbsp;&nbsp; &nbsp; select&nbsp;<br/> &nbsp;&nbsp; &nbsp; bel.Mandant as [Mandant],<br/> &nbsp;&nbsp; &nbsp; bel.[BelID] as [BelId],<br/> &nbsp;&nbsp; &nbsp; bel.[Belegnummer] as [Belegnummer],<br/> &nbsp;&nbsp; &nbsp; bel.[Belegjahr] as [Belegjahr],<br/> &nbsp;&nbsp; &nbsp; ver.[Storniert] as [Storniert],<br/> &nbsp;&nbsp; &nbsp; ver.[ID] as [VersandDatenId],<br/> &nbsp;&nbsp; &nbsp; ver.[PaketId] as [PaketId],<br/> &nbsp;&nbsp; &nbsp; ver.[Paketnummer] as [Paketnummer],<br/> &nbsp;&nbsp; &nbsp; ver.[Versanddienstleister] as [Versanddienstleister],<br/> &nbsp;&nbsp; &nbsp; (select LieferStrasse from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperStreet],<br/> &nbsp;&nbsp; &nbsp; '' as [ShipperStreetNr],<br/> &nbsp;&nbsp; &nbsp; (select LieferOrt from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperCity],<br/> &nbsp;&nbsp; &nbsp; (select LieferPLZ from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperZip],<br/> &nbsp;&nbsp; &nbsp; (select LieferLand from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperCountryCode],<br/> &nbsp;&nbsp; &nbsp; '' as [ShipperEmail],<br/> &nbsp;&nbsp; &nbsp; (select Name1 from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperFirstName],<br/> &nbsp;&nbsp; &nbsp; (select Name2 from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperLastName],<br/> &nbsp;&nbsp; &nbsp; (select Name1 from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperCompanyName],<br/> &nbsp;&nbsp; &nbsp; (select [Telefon] from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperPhone],<br/> &nbsp;&nbsp; &nbsp; bel.[A1Strasse] as [ReceiverStreet],<br/> &nbsp;&nbsp; &nbsp; '' as [ReceiverStreetNr],<br/> &nbsp;&nbsp; &nbsp; bel.[A1Ort] as [ReceiverCity],<br/> &nbsp;&nbsp; &nbsp; bel.[A1PLZ] as [ReceiverZip],<br/> &nbsp;&nbsp; &nbsp; 'goods' as [Comment],
&nbsp;&nbsp; &nbsp; bel.[A1Land] as [ReceiverCountryCode],<br/> &nbsp;&nbsp; &nbsp; --'CH' as [ReceiverCountryCode],<br/> &nbsp;<br/> &nbsp;&nbsp; &nbsp; '' as [ReceiverEmail],<br/> &nbsp;&nbsp; &nbsp; bel.[A1Name1] as [ReceiverFirstName],<br/> &nbsp;&nbsp; &nbsp; bel.[A1Name2] as [ReceiverLastName],<br/> &nbsp;&nbsp; &nbsp; '' as [ReceiverCompanyName],<br/> &nbsp;&nbsp; &nbsp; '' as ReceiverAdditional,<br/> &nbsp;&nbsp; &nbsp; (select top 1 Telefon from khkadressen where adresse = (select A1AdressNr from khkvkbelege where belid = bel.[BelId])) as [ReceiverPhone],<br/> &nbsp;&nbsp; &nbsp; bel.Liefertermin as [ShippingDate],
&nbsp;&nbsp; &nbsp; (case when bel.[A1Land] <> 'DE' then<br/> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;'V53WPAK'<br/> &nbsp;&nbsp; &nbsp; ELSE<br/> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;'V01PAK' end) as [ProductCode],<br/> &nbsp;&nbsp; &nbsp; --'V53WPAK' as [ProductCode],<br/> &nbsp;<br/> &nbsp;&nbsp; &nbsp; --'22222222220104' as [BillingNumber],&nbsp;<br/> &nbsp;&nbsp; &nbsp;(case when bel.[A1Land] <> 'DE' then<br/> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;'<span style="background-color:#d35400;">HIER MUSS DIE ABRECHNUNGSNUMMER REIN</span>' + '5301'<br/> &nbsp;&nbsp; &nbsp;ELSE<br/> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;'<span style="background-color:#e74c3c;">HIER MUSS DIE ABRECHNUNGSNUMMER REIN</span>' + '0104'&nbsp;<br/> &nbsp;&nbsp; &nbsp;end) as [BillingNumber],
&nbsp;&nbsp; &nbsp; convert(varchar(255), bel.[Belegnummer]) as [CustomerReference],<br/> &nbsp;&nbsp; &nbsp; ver.[Gewicht] as [WeightInKG],<br/> &nbsp;&nbsp; &nbsp; '' as [LengthInCm],<br/> &nbsp;&nbsp; &nbsp; '' as [WidthInCm],<br/> &nbsp;&nbsp; &nbsp; '' as [HeightInCm],<br/> &nbsp;&nbsp; &nbsp; '' as [IdentFirstName],<br/> &nbsp;&nbsp; &nbsp; '' as [IdentLastName],<br/> &nbsp;&nbsp; &nbsp; '' as [IdentMinAge],<br/> &nbsp;&nbsp; &nbsp; '' as [IdentBirthday],<br/> &nbsp;&nbsp; &nbsp; USER_HTKVersandPackstationsnummer as [PackingstationNumber],<br/> &nbsp;&nbsp; &nbsp; USER_HTKVersandPostnummer as [Postnumber],<br/> &nbsp;&nbsp; &nbsp; USER_HTKVersandPostfilialnummer as [Postfilialnummer],<br/> &nbsp;&nbsp; &nbsp; USER_HTKVersandPacketshopnummer as [Packetshopnummer],<br/> &nbsp;&nbsp; &nbsp; --(select Zuschlag from KHKVKBelegeZuschlaege as z inner join KHKZuschlagsarten as zu on zu.Mandant = z.Mandant and zu.ZuschlagID = z.ZuschlagID where belid = bel.BelID and z.Mandant = bel.Mandant and zu.Zuschlagsart = 'Versand') + bel.Bruttobetrag + 2 as NachnahmeBetrag<br/> &nbsp;&nbsp; &nbsp; NULL as [NachnahmeBetrag]<br/> &nbsp;&nbsp; &nbsp; from KHKVKBelege as bel<br/> &nbsp;&nbsp; &nbsp; inner join [HTKBPM_Plugins_Versanddaten] as ver ON bel.mandant = ver.Mandant AND bel.BelID = ver.BelId<br/> &nbsp;&nbsp; &nbsp; where ver.Versanddienstleister = 'DHL (Versenden API)' and Convert(date ,bel.Liefertermin) = Convert(date, GETDATE())<br/> &nbsp;&nbsp; &nbsp;&nbsp;<br/> &nbsp;&nbsp; &nbsp;&nbsp;<br/> GO
<br/> &nbsp;
</blockquote>
&nbsp;
&nbsp;


&nbsp;
Wenn das nun funktioniert hat und entsprechende Belege gefunden werden sollten in dem Root Verzeichnis des API Exports entsprechende .pdf Dateien generiert werden :
</div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div>
 
[[File:DHL API13.png]]
 
Nun muss&nbsp;
</div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div>
264

Bearbeitungen

Navigationsmenü