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:19 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"> | ||
= '''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 81: | Zeile 81: | ||
'''<span style="color:red">ACHTUNG! Hier muss entsprechend der Mandant geprüft werden</span>''' | '''<span style="color:red">ACHTUNG! Hier muss entsprechend der Mandant geprüft werden</span>''' | ||
<blockquote> | <blockquote> | ||
' | |||
</blockquote> | </blockquote> | ||
Im Anschluss daran muss man in der dbo.vwHTKVersenden noch eine Anpassung durchführen. Hier muss im Statement an der Stelle " HIER MUSS DIE ABRECHNUNGSNUMMER REIN" die Abrechnungsnummer des Kunden des DHL-Geschäftskundenportal rein - falls die Kunden nicht wissen was das ist und wo man dies findet [https://dhl.support.netresearch.de/support/solutions/articles/12000024658-wie-werden-die-kundennummer-ekp-und-teilnahmenummern-eingerichtet- HIER] gut erklärt. | 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. | ||
| Zeile 89: | Zeile 89: | ||
SET QUOTED_IDENTIFIER ON<br/> GO | SET QUOTED_IDENTIFIER ON<br/> GO | ||
<br/> ALTER VIEW [dbo].[vWHTkVersenden] AS<br/> select <br/> bel.Mandant as [Mandant],<br/> bel.[BelID] as [BelId],<br/> bel.[Belegnummer] as [Belegnummer],<br/> bel.[Belegjahr] as [Belegjahr],<br/> ver.[Storniert] as [Storniert],<br/> ver.[ID] as [VersandDatenId],<br/> ver.[PaketId] as [PaketId],<br/> ver.[Paketnummer] as [Paketnummer],<br/> ver.[Versanddienstleister] as [Versanddienstleister],<br/> (select LieferStrasse from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperStreet],<br/> '' as [ShipperStreetNr],<br/> (select LieferOrt from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperCity],<br/> (select LieferPLZ from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperZip],<br/> (select LieferLand from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperCountryCode],<br/> '' as [ShipperEmail],<br/> (select Name1 from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperFirstName],<br/> (select Name2 from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperLastName],<br/> (select Name1 from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperCompanyName],<br/> (select [Telefon] from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperPhone],<br/> bel.[A1Strasse] as [ReceiverStreet],<br/> '' as [ReceiverStreetNr],<br/> bel.[A1Ort] as [ReceiverCity],<br/> bel.[A1PLZ] as [ReceiverZip],<br/> 'goods' as [Comment], | <br/> ALTER VIEW [dbo].[vWHTkVersenden] AS<br/> select <br/> bel.Mandant as [Mandant],<br/> bel.[BelID] as [BelId],<br/> bel.[Belegnummer] as [Belegnummer],<br/> bel.[Belegjahr] as [Belegjahr],<br/> ver.[Storniert] as [Storniert],<br/> ver.[ID] as [VersandDatenId],<br/> ver.[PaketId] as [PaketId],<br/> ver.[Paketnummer] as [Paketnummer],<br/> ver.[Versanddienstleister] as [Versanddienstleister],<br/> (select LieferStrasse from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperStreet],<br/> ''as [ShipperStreetNr],<br/> (select LieferOrt from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperCity],<br/> (select LieferPLZ from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperZip],<br/> (select LieferLand from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperCountryCode],<br/> '' as [ShipperEmail],<br/> (select Name1 from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperFirstName],<br/> (select Name2 from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperLastName],<br/> (select Name1 from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperCompanyName],<br/> (select [Telefon] from KHKAdressen where mandant = bel.Mandant and adresse = (select adresse from KHKAdressenverweise where mandant = [Mandant] and Verweis = 'Mandant' and Eigentuemer = -1)) as [ShipperPhone],<br/> bel.[A1Strasse] as [ReceiverStreet],<br/> ''as [ReceiverStreetNr],<br/> bel.[A1Ort] as [ReceiverCity],<br/> bel.[A1PLZ] as [ReceiverZip],<br/> 'goods' as [Comment],'' | ||
bel.[A1Land] as [ReceiverCountryCode],<br/> --'CH' as [ReceiverCountryCode],<br/> <br/> '' as [ReceiverEmail],<br/> bel.[A1Name1] as [ReceiverFirstName],<br/> bel.[A1Name2] as [ReceiverLastName],<br/> '' as [ReceiverCompanyName],<br/> '' as ReceiverAdditional,<br/> (select top 1 Telefon from khkadressen where adresse = (select A1AdressNr from khkvkbelege where belid = bel.[BelId])) as [ReceiverPhone],<br/> bel.Liefertermin as [ShippingDate], | bel.[A1Land] as [ReceiverCountryCode],<br/> --'CH' as [ReceiverCountryCode],<br/> <br/> ''as [ReceiverEmail],<br/> bel.[A1Name1] as [ReceiverFirstName],<br/> bel.[A1Name2] as [ReceiverLastName],<br/> '' as [ReceiverCompanyName],<br/> ''as ReceiverAdditional,<br/> (select top 1 Telefon from khkadressen where adresse = (select A1AdressNr from khkvkbelege where belid = bel.[BelId])) as [ReceiverPhone],<br/> bel.Liefertermin as [ShippingDate],'' | ||
(case when bel.[A1Land] <> 'DE' then<br/> 'V53WPAK'<br/> ELSE<br/> 'V01PAK' end) as [ProductCode],<br/> --'V53WPAK' as [ProductCode],<br/> <br/> --'22222222220104' as [BillingNumber], <br/> (case when bel.[A1Land] <> 'DE' then<br/> '<span style="background-color:#d35400;">HIER MUSS DIE ABRECHNUNGSNUMMER REIN</span>' + '5301'<br/> ELSE<br/> '<span style="background-color:#e74c3c;">HIER MUSS DIE ABRECHNUNGSNUMMER REIN</span>' + '0104' <br/> end) as [BillingNumber], | (case when bel.[A1Land] <> 'DE' then<br/> 'V53WPAK'<br/> ELSE<br/> 'V01PAK' end) as [ProductCode],<br/> --'V53WPAK' as [ProductCode],<br/> <br/> --'22222222220104' as [BillingNumber], <br/> (case when bel.[A1Land] <> 'DE' then<br/> '<span style="background-color:#d35400;">HIER MUSS DIE ABRECHNUNGSNUMMER REIN</span>' + '5301'<br/> ELSE<br/> '<span style="background-color:#e74c3c;">HIER MUSS DIE ABRECHNUNGSNUMMER REIN</span>' + '0104' <br/> end) as [BillingNumber], | ||
convert(varchar(255), bel.[Belegnummer]) as [CustomerReference],<br/> ver.[Gewicht] as [WeightInKG],<br/> '' as [LengthInCm],<br/> '' as [WidthInCm],<br/> '' as [HeightInCm],<br/> '' as [IdentFirstName],<br/> '' as [IdentLastName],<br/> '' as [IdentMinAge],<br/> '' as [IdentBirthday],<br/> USER_HTKVersandPackstationsnummer as [PackingstationNumber],<br/> USER_HTKVersandPostnummer as [Postnumber],<br/> USER_HTKVersandPostfilialnummer as [Postfilialnummer],<br/> USER_HTKVersandPacketshopnummer as [Packetshopnummer],<br/> --(select Zuschlag from KHKVKBelegeZuschlaege as z inner join KHKZuschlagsarten as zu on zu.Mandant = z.Mandant and zu.ZuschlagID = z.ZuschlagID where belid = bel.BelID and z.Mandant = bel.Mandant and zu.Zuschlagsart = 'Versand') + bel.Bruttobetrag + 2 as NachnahmeBetrag<br/> NULL as [NachnahmeBetrag]<br/> from KHKVKBelege as bel<br/> inner join [HTKBPM_Plugins_Versanddaten] as ver ON bel.mandant = ver.Mandant AND bel.BelID = ver.BelId<br/> where ver.Versanddienstleister = 'DHL (Versenden API)' and Convert(date ,bel.Liefertermin) = Convert(date, GETDATE())<br/> <br/> <br/> GO | convert(varchar(255), bel.[Belegnummer]) as [CustomerReference],<br/> ver.[Gewicht] as [WeightInKG],<br/> ''as [LengthInCm],<br/> '' as [WidthInCm],<br/> ''as [HeightInCm],<br/> '' as [IdentFirstName],<br/> ''as [IdentLastName],<br/> '' as [IdentMinAge],<br/> ''as [IdentBirthday],<br/> USER_HTKVersandPackstationsnummer as [PackingstationNumber],<br/> USER_HTKVersandPostnummer as [Postnumber],<br/> USER_HTKVersandPostfilialnummer as [Postfilialnummer],<br/> USER_HTKVersandPacketshopnummer as [Packetshopnummer],<br/> --(select Zuschlag from KHKVKBelegeZuschlaege as z inner join KHKZuschlagsarten as zu on zu.Mandant = z.Mandant and zu.ZuschlagID = z.ZuschlagID where belid = bel.BelID and z.Mandant = bel.Mandant and zu.Zuschlagsart = 'Versand') + bel.Bruttobetrag + 2 as NachnahmeBetrag<br/> NULL as [NachnahmeBetrag]<br/> from KHKVKBelege as bel<br/> inner join [HTKBPM_Plugins_Versanddaten] as ver ON bel.mandant = ver.Mandant AND bel.BelID = ver.BelId<br/> where ver.Versanddienstleister = 'DHL (Versenden API)' and Convert(date ,bel.Liefertermin) = Convert(date, GETDATE())<br/> <br/> <br/> GO'' | ||
<br/> | <br/> | ||
| Zeile 101: | Zeile 101: | ||
| | ||
Wenn das nun funktioniert hat und entsprechende Belege gefunden werden sollten in dem Root Verzeichnis des API Exports entsprechende .pdf Dateien generiert werden : | Wenn das nun funktioniert hat und entsprechende Belege gefunden werden sollten in dem Root Verzeichnis des API Exports entsprechende .pdf Dateien generiert werden : | ||
[[File:DHL API13.png]] | [[File:DHL API13.png|RTENOTITLE]] | ||
Nun muss | Nun muss | ||
</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> | ||