Broken/OmniShipping Internal:DHL API: Unterschied zwischen den Versionen

← Zum vorherigen Versionsunterschied

VisuellWikitext

@@ 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"><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''' =
 <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 35: / Zeile 35: @@
 [[File:DHL API5.png|RTENOTITLE]]
+=== BPM Konfiguration ===
 Sind die Tabellen etc. alle entsprechend angelegt worden sollte man nun im ersten Schritt die Datenbankverbindung im HTK Service hinterlegen.
@@ Zeile 83: / Zeile 85: @@
 '''<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&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">KHKVKBelege&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">WITH&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">Versand&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">IN&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">Belegkennzeichen&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">IN&nbsp;</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&nbsp;</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&nbsp;</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&nbsp;</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&nbsp;</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&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&nbsp;</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]&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">IN&nbsp;</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]&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">from&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">WITH&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">(NOLOCK)&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">WHERE&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">BelId&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">IN&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[BelId]&nbsp;</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&nbsp;</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&nbsp;</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&nbsp;</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&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">NEXT&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">FROM&nbsp;</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&nbsp;</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&nbsp;</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">(*)&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">from&nbsp;</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&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">from&nbsp;</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">)&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">where&nbsp;</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&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">NEXT&nbsp;</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&nbsp;</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&nbsp;</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&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[KHKVKBelege]&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&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[BelID]&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:blue">in&nbsp;</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&nbsp;</span></span></span></span>'''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:#2a2c36">[BelID]&nbsp;</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>
+==== Anpassung der dbo.vwHTKVersenden ====
 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>
@@ Zeile 105: / Zeile 109: @@
 [[File:DHL API13.png|RTENOTITLE]]
-Nun muss&nbsp;
+Nun muss noch im DHL Geschäftskundenportal des Kunden gepürft werden ob der entsprechende Auftrag auch dort vorhanden ist.
-</div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div>
+</div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div>