264
Bearbeitungen
OmniShipping Internal:DHL API: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
OmniShipping Internal:DHL API (Quelltext anzeigen)
Version vom 2. März 2021, 20:22 Uhr
, 2. März 2021keine Bearbeitungszusammenfassung
BD (Diskussion | Beiträge) Keine Bearbeitungszusammenfassung |
BD (Diskussion | Beiträge) 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"><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 !!</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 !!</span>'''</p> | ||
| Zeile 35: | Zeile 35: | ||
[[File:DHL API5.png|RTENOTITLE]] | [[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. | 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"> <br/> ( <br/> [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/> [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/> [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/> [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/> [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"> [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/> '''<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/> '''<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/> </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/> '''<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/> '' '''<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/> <br/> <br/> </span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:green">-- select @MyMandant, @MyBelid</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">@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/> '' '''<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"> </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">= (</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/> </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"> </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/> </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/> '''<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/> '''<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/> [GepacktAm], [GepacktUm], [BelegAm], [BelegUm], [ImportAm], [ImportUm], [Storniert], [ExportErfolgt], [Abrechnungsnummer])<br/> <br/> </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"> </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/> '''<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"> <br/> </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/> </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/> '''<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>'' | '''<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"> <br/> ( <br/> [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/> [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/> [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/> [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/> [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"> [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/> '''<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/> '''<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/> </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/> '''<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/> '' '''<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/> <br/> <br/> </span></span></span></span>''<span style="font-size:9.5pt"><span style="line-height:107%"><span style="font-family:"><span style="color:green">-- select @MyMandant, @MyBelid</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">@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/> '' '''<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"> </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">= (</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/> </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"> </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/> </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/> '''<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/> '''<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/> [GepacktAm], [GepacktUm], [BelegAm], [BelegUm], [ImportAm], [ImportUm], [Storniert], [ExportErfolgt], [Abrechnungsnummer])<br/> <br/> </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"> </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/> '''<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"> <br/> </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/> </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/> '''<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> | </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. | 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> | <blockquote> | ||
| Zeile 106: | Zeile 110: | ||
Nun muss noch im DHL Geschäftskundenportal des Kunden gepürft werden ob der entsprechende Auftrag auch dort vorhanden ist. | 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> </div> | ||