Quelltext anzeigen

<!--  **************************************  -->  
<!--  ********  Auftrag versendet   ********  -->
<!--  **************************************  -->  
  <PARM>
    <PATH>\\192.168.5.8\SAP\Datentransfer\ShopAbo-Transfer\WebOut\order_sap</PATH>  
    <GROUP>VOLL</GROUP>
    <ACTIVE>*YES</ACTIVE>
    <FILENRKOBJ></FILENRKOBJ>
    <FILE>01_{DATE}_{JobTime}_shop3_orderstatus.xml</FILE>
    <SQL>
           
       select
          ODLN.NumAtCard AS 'order_number',
          'S' AS 'order_status',
          ODLN.Comments AS 'order_smm_note',
          ODLN.U_BOB_TrackNr AS 'tracking_id'
       from ODLN
       where 	ODLN.U_ddsbestellart = '01' and ODLN.U_BOB_UebertragenWeb = 'N' 

       union all

       select
          OINV.NumAtCard AS 'order_number',
          'S' AS 'order_status',
          OINV.Comments AS 'order_smm_note',
          OINV.U_BOB_TrackNr AS 'tracking_id'
       from OINV
       where 	OINV.U_ddsbestellart = '01' and OINV.U_BOB_UebertragenWeb = 'N'
	 --Kennzeichen das Rückgemeldet wurde setzten
       update ODLN 
	 set U_BOB_UebertragenWeb  = 'Y'
	 where ODLN.U_ddsbestellart = '01' and ODLN.U_BOB_UebertragenWeb  = 'N'
	 update OINV 
	 set U_BOB_UebertragenWeb = 'Y' 
	 where OINV.U_ddsbestellart = '01' and OINV.U_BOB_UebertragenWeb = 'N'


    </SQL>
    
    <FMT>*XML</FMT>
    <OVERWRITE>*YES</OVERWRITE>
    <XMLROOT>shop3_order</XMLROOT>

</PARM>