Gemeinschaftspraxis Bocklemünd
Görlinger-Zentrum 5 - 7
50829 Köln
Tel.: +49 221 501349

Hausarzt Dr. med. Alexander Lang
Grevenbroicher Str. 25 
50829 Köln
Tel.: +49 221 508111

SELECT mass.DisplayText Assignment, mc.CustomerId, mc.ShortName, COUNT(mc.CustomerId) Counter
  FROM masCustomerAccumulation mca
       INNER JOIN masCustomer mc ON mc.CustomerId = mca.Customer_Id
       INNER JOIN masAccumulation macc ON macc.AccumulationId = mca.Accumulation_Id
       INNER JOIN masAssignment mass ON mass.AssignmentId = macc.Assignment_Id
 WHERE mass.DisplayText IN ('Food', 'Gas')
 GROUP BY mass.DisplayText, mc.CustomerId, mc.ShortName
 ORDER BY Assignment, Counter DESC, ShortName

Case "PROSKURNIN", "CAMES", "INTERTABAK", "MACK", "SZZ", "BRUECK"
    Filename = CreatingFilename(pRow("LocalFilePath").ToString, pRow("LocalFilePrefix").ToString, strTakeorderNumber, "CSV")
    Dim OutputFile As CSVFile = New CSVFile(Filename)
    If Organisation = "CAMES" Then
        OutputFile.ExportMode = "Plain"
        OutputFile.CustomerFields = {"KdNr beim Spediteur", "Name", "Bestellnummer", "Bestelldatum", "Bestellinfo", "Position", "Artikelnummer",
            "Menge", "Mengeneinheit", "GTIN", "Preislistenname", "Packungen pro Karton", "Inhalt", "Preis", "Preisliste"}
        OutputFile.Export(pRow, strTakeorderNumber, OriginOfOrder, relation)
    ElseIf Organisation = "SZZ" Then
        OutputFile.ExportSZZ(pRow, strTakeorderNumber, OriginOfOrder, relation)
    ElseIf Organisation = "BRUECK" Then
        OutputFile.ExportMode = "Excel"
        OutputFile.CustomerFields = {"Name", "Strasse", "PLZ", "Ort", "Bestellnummer", "Bestelldatum", "Bestellinfo", "Position", "Artikelnummer",
            "Menge", "Mengeneinheit", "Preislistenname", "Preis", "Preisliste", "Packungen pro Karton", "Inhalt"}
        OutputFile.Export(pRow, strTakeorderNumber, OriginOfOrder, relation)
    Else   ' PROSKURNIN, MACK und INTERTABAK
        OutputFile.ExportMode = "Excel"
        OutputFile.Export(pRow, strTakeorderNumber, OriginOfOrder, relation)
    End If

if (posibleCustomerIds.Count < 1)
{
    if (cust.DisplayName.Equals("TGV, Sindelfingen", StringComparison.OrdinalIgnoreCase))
    {
        posibleCustomerIds = await reader.CustomerIdGet(new FindCustomer("TGV Süd", "1003060", true));
    }
    else if (cust.DisplayName.Equals("Fütterer, St. Leon Rot", StringComparison.OrdinalIgnoreCase))
    {
        posibleCustomerIds = await reader.CustomerIdGet(new FindCustomer("Fütterer, Tabak", cust.CustomerNumber, true));
    } ...
}

<?xml version="1.0" encoding="iso-8859-15"?>
<Auftrag>
  <Kopf>
    <Order_Num>0000304362</Order_Num>
    <Order_Dat>20201211</Order_Dat>
    <Liefer_Datum_Wunsch />
    <JTI_GLN_Num>4032800000009</JTI_GLN_Num>
    <GH_GLN_Num>4399901095458</GH_GLN_Num>
    <Name1_WE>Schuller, Margot</Name1_WE>
    <Name2_WE>Lädle Tee &amp; Geschenke</Name2_WE>
    <Strasse_WE>Flamingoweg 1</Strasse_WE>
    <Ort_WE>Stuttgart</Ort_WE>
    <PLZ_WE>70378</PLZ_WE>
    <KdNr_WE_beim_Spediteur>10109</KdNr_WE_beim_Spediteur>
    <KdNr_WE_beim_Lieferant>0000802831</KdNr_WE_beim_Lieferant>
    <Order_Info>ä=ae; Ä=Ae, ö=oe; Ö=Oe; ü=ue; Ü=Ue; ß=sz</Order_Info>
  </Kopf>
  <Positionen>
    <Position>
      <ID>1</ID>
      <GTIN>4032800066821</GTIN>
      <JTI_ArtNr>PR_42150</JTI_ArtNr>
      <JTI_ArtText>WINSTON RED LONGS BP XXL</JTI_ArtText>
      <JTI_PricelistName>WINSTON RED LONGS BP XXL</JTI_PricelistName>
      <PacksPerCarton>8</PacksPerCarton>
      <Content>29</Content>
      <Price>8.0000</Price>
      <PriceList>Z079E</PriceList>
      <Menge>1</Menge>
      <MengenArt>CAR</MengenArt>
      <Position_Info />
    </Position>
    <Position>
      <ID>2</ID>
      <GTIN>4032800054736</GTIN>
      <JTI_ArtNr>PR_42135</JTI_ArtNr>
      <JTI_ArtText>WINSTON VOLUME RED GIANT BOX</JTI_ArtText>
      <JTI_PricelistName>WINSTON VOLUME RED GIANT BOX</JTI_PricelistName>
      <PacksPerCarton>1</PacksPerCarton>
      <Content>280</Content>
      <Price>49.9500</Price>
      <PriceList>F037E</PriceList>
      <Menge>1</Menge>
      <MengenArt>PAC</MengenArt>
      <Position_Info />
    </Position>
  </Positionen>
</Auftrag>

To: "G=MG1;S=MGATE;CN=MG1 MGATE;O=TESTAG;P=MGATE;A=VIAT;C=DE" <49603@viaT.de>
From: "G=ipm;S=tester;O=testag;A=viaT;C=de" <49637@viaT.de>
Message-ID: 614 07/11/13
X-MPDUID: 8B0663A011DCEC4417009682
Date: 13 Nov 2010 13:10:22 +0100
Subject: Test mit 3 Bodyparts
Disposition-Notification-To: "G=ipm;S=tester;O=testag;A=viaT;C=de"
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="MG_=_CA610D0211DC91E900007CAD_=_MG"
--MG_=_CA610D0211DC91E900007CAD_=_MG
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
Test äöüÄÖÜß
--MG_=_CA610D0211DC91E900007CAD_=_MG
Content-Type: application/octet-stream
Content-Disposition: attachment; filename="4d654d1d.zip