CREATE VIEW [dbo].[SIPARIS_GECMISI]
AS
SELECT 
FIS.FICHENO,
CAST(FIS.DATE_ AS DATETIME) AS DATE_,
ITM.CODE,
CMP.DEFINITION_,
PCD.PRODUCERCODE,
ORD.DURUM,
FCL.AMOUNT,
PRC.PRICE,
CASE WHEN PRC.CURRENCY = 1 THEN 'USD' WHEN PRC.CURRENCY = 13 THEN 'CNY' WHEN PRC.CURRENCY = 20 THEN 'EUR' WHEN PRC.CURRENCY = 160 THEN 'TL' ELSE 'USD' END AS PRCCURR
FROM
[IHR].[dbo].[FICHE_LINES] AS FCL LEFT OUTER JOIN
[IHR].[dbo].[ORDER_STATUS] AS ORD ON FCL.[STATUS] = ORD.REF LEFT OUTER JOIN
[IHR].[dbo].[PRCLIST] AS PRC ON FCL.PRICEREF = PRC.REF LEFT OUTER JOIN
[IHR].[dbo].[ITEMS] AS ITM ON FCL.ITEMREF = ITM.REF LEFT OUTER JOIN
[IHR].[dbo].[COMPANIES] AS CMP ON CMP.REF = FCL.COMPANYREF LEFT OUTER JOIN
[IHR].[dbo].[PRODUCERCODES] AS PCD ON PCD.REF=FCL.PRODREF LEFT OUTER JOIN
[IHR].[dbo].[FICHES] AS FIS ON FIS.REF=FCL.FICHEREF