Logo Sipariş Satır Dövizli

SELECT
LOGO_ORFICHE.TRCODE,
LOGO_ORFICHE.FICHENO,
LOGO_ORFICHE.LOGICALREF,
LOGO_ORFICHE.DATE_,
STOCKREF,
AMOUNT,
PRICE AS TLFIYAT,
LOGO_ORFLINE.TRCURR,LOGO_ORFLINE.PRCURR,
LOGO_ORFLINE.TRRATE ,

CASE WHEN LOGO_ORFICHE.LINEEXCTYP =0 THEN CASE WHEN LOGO_ORFLINE.PRCURR IN (0,160) THEN LOGO_ORFLINE.PRICE ELSE ISNULL(LOGO_ORFLINE.PRICE /NULLIF( LOGO_ORFLINE.REPORTRATE,0),0) END

  WHEN  LOGO_ORFICHE.LINEEXCTYP =1  THEN CASE WHEN LOGO_ORFLINE.PRCURR IN (0,160) THEN LOGO_ORFLINE.PRICE  ELSE  ISNULL(LOGO_ORFLINE.PRICE /NULLIF( LOGO_ORFLINE.REPORTRATE,0),0) END  --OK

  WHEN  LOGO_ORFICHE.LINEEXCTYP =2  THEN CASE WHEN LOGO_ORFLINE.TRCURR IN (0,160) THEN LOGO_ORFLINE.PRICE  ELSE  ISNULL(LOGO_ORFLINE.PRICE /NULLIF( LOGO_ORFLINE.TRRATE,0),0)  END  -- OKK

  WHEN  LOGO_ORFICHE.LINEEXCTYP =3  THEN CASE WHEN LOGO_ORFLINE.PRCURR IN (0,160) THEN LOGO_ORFLINE.PRICE  ELSE  ISNULL(LOGO_ORFLINE.PRICE /NULLIF( LOGO_ORFLINE.REPORTRATE,0),0)  END  -- OKK

  WHEN  LOGO_ORFICHE.LINEEXCTYP =4  THEN CASE WHEN LOGO_ORFLINE.PRCURR IN (0,160) THEN LOGO_ORFLINE.PRICE  ELSE  ISNULL(LOGO_ORFLINE.PRICE /NULLIF( LOGO_ORFLINE.REPORTRATE,0),0) END --OKK
  ELSE ''

END AS [DOVIZ_FIYAT],

–CASE WHEN LOGO_ORFLINE.TRCURR IN (0,160) THEN 0 ELSE ISNULL(LOGO_ORFLINE.PRICE /NULLIF( LOGO_ORFLINE.TRRATE,0),0) END AS [DovizFiyat],
–LOGO_ORFLINE.PRPRICE,

CASE WHEN LOGO_ORFICHE.LINEEXCTYP =0 THEN ‘Yerel Para Birim’
WHEN LOGO_ORFICHE.LINEEXCTYP =1 THEN ‘Raporlama Dövizi’
WHEN LOGO_ORFICHE.LINEEXCTYP =2 THEN ‘İşlem Dövizi’
WHEN LOGO_ORFICHE.LINEEXCTYP =3 THEN ‘Euro’
WHEN LOGO_ORFICHE.LINEEXCTYP =4 THEN ‘Fiyatlandırma Dövizi’
ELSE ”
END AS [SiparisSatırParaBirim],

CASE WHEN LOGO_ORFICHE.LINEEXCTYP =0 THEN CASE
LOGO_ORFLINE.PRCURR
WHEN 0 THEN ‘TL’
WHEN 1 THEN ‘USD’
WHEN 20 THEN ‘EUR’
WHEN 160 THEN ‘TL’
ELSE ‘TANIMSIZ’ END
WHEN LOGO_ORFICHE.LINEEXCTYP =1 THEN CASE
LOGO_ORFLINE.PRCURR
WHEN 0 THEN ‘TL’
WHEN 1 THEN ‘USD’
WHEN 20 THEN ‘EUR’
WHEN 160 THEN ‘TL’
ELSE ‘TANIMSIZ’ END
WHEN LOGO_ORFICHE.LINEEXCTYP =2 THEN CASE
LOGO_ORFLINE.TRCURR
WHEN 0 THEN ‘TL’
WHEN 1 THEN ‘USD’
WHEN 20 THEN ‘EUR’
WHEN 160 THEN ‘TL’
ELSE ‘TANIMSIZ’ END
WHEN LOGO_ORFICHE.LINEEXCTYP =3 THEN CASE
LOGO_ORFLINE.PRCURR
WHEN 0 THEN ‘TL’
WHEN 1 THEN ‘USD’
WHEN 20 THEN ‘EUR’
WHEN 160 THEN ‘TL’
ELSE ‘TANIMSIZ’ END

  WHEN  LOGO_ORFICHE.LINEEXCTYP =4  THEN CASE 

LOGO_ORFLINE.PRCURR
WHEN 0 THEN ‘TL’
WHEN 1 THEN ‘USD’
WHEN 20 THEN ‘EUR’
WHEN 160 THEN ‘TL’
ELSE ‘TANIMSIZ’ END
ELSE ”
END AS [SATIR_dövizitipi]

FROM [dbo].LG_121_01_ORFLINE LOGO_ORFLINE
INNER JOIN LG_121_01_ORFICHE LOGO_ORFICHE ON LOGO_ORFICHE.LOGICALREF= LOGO_ORFLINE.ORDFICHEREF
WHERE LOGO_ORFICHE.TRCODE=1
–where LOGO_ORFICHE.FICHENO IN( ‘0000000000000185’)
–AND LOGO_ORFICHE.FICHENO IN(‘0000000000000021’, ‘0000000000001848’)