SELECT 
  
  BSL.FIS_TIP, 
  BSL.FIS_NO,
  BSL.TARIH, 
  BSL.ACIKLAMA1,
  SATIR.BELGE_TARIH, 
  SATIR.BELGE_TUR, 
  SATIR.BELGE_NO,
  SATIR.ACIKLAMA,
  SATIR.BORC_MIKTARI,
  SATIR.ALACAK_MIKTARI,
  SATIR.BORC_TUTARI,
  SATIR.ALACAK_TUTARI,
  HESAP.KOD,
  HESAP.HESAP_ADI,
 
  CASE 
    WHEN BSL.FIS_TIP = 'DA46BCD3-AC3C-40D1-8485-8EF988E78B56' THEN '1'
 WHEN BSL.FIS_TIP = 'F5B9E66D-8EFC-491B-A618-24948F3F83F8' THEN '4'
 WHEN BSL.FIS_TIP = '2D606046-EF37-4823-AAE1-6DBFDAF7196F' THEN '4'
 WHEN BSL.FIS_TIP = '50DCF09A-C85A-4A43-B8EB-3EDBFF3C5820' THEN '4'
 WHEN BSL.FIS_TIP = '5303A215-949E-4C47-80E0-25FED770E0BE' THEN '6'
  END AS fistip,
  
  BSL.FIS_NO as fisno,
  BSL.TARIH as fistarih,
  BSL.ACIKLAMA1 AS fisaciklama,
  SATIR.BELGE_TARIH AS belgetarih,
  
  CASE 
    WHEN SATIR.BELGE_TUR = '91DE264F-01CD-4f57-BFA5-782985B47879' THEN '20'
    WHEN SATIR.BELGE_TUR = '4164379E-BC29-4b4d-9FED-995D648C3865' THEN '7'
    WHEN SATIR.BELGE_TUR = 'C2A941C0-078D-43a3-9370-D053D019AB4B' THEN '20'
    WHEN SATIR.BELGE_TUR = '4496E337-A81F-460b-B4BF-72CC11D09060' THEN '414'
    WHEN SATIR.BELGE_TUR = '53352E3F-EBD4-4460-9BA3-2A6CDBF947FB' THEN '416'
    WHEN SATIR.BELGE_TUR = 'BF55F734-F3AD-4820-8F46-94B6D58D6912' THEN '89'
    WHEN SATIR.BELGE_TUR = '492862AE-8EFC-4D07-838D-A50807ABD034' THEN '88'
    WHEN SATIR.BELGE_TUR = 'A76C856F-2456-4589-8765-1CAD45A8EBA1' THEN '97'
    WHEN SATIR.BELGE_TUR = '99D603BF-2FA0-4F78-8956-618820E57FCD' THEN '95'
    WHEN SATIR.BELGE_TUR = '6A7375C9-B771-4A6B-9F42-FDB6D3BC122B' THEN '35'
    WHEN SATIR.BELGE_TUR = 'BA3EF528-8F29-4DB6-981B-55D70AAC1D31' THEN '34'
    WHEN SATIR.BELGE_TUR = '76563DDC-A67A-4A51-A3C5-ED4857858F2E' THEN '96'
    WHEN SATIR.BELGE_TUR = '5AC7F0E2-A18E-4B3C-AD0F-567D44E336B4' THEN '45'
    WHEN SATIR.BELGE_TUR = '2065E605-9609-4DF1-A627-E3A69D5ACE30' THEN '414'
    WHEN SATIR.BELGE_TUR = '4C1EA22F-B0AF-464D-B25D-95C8BA7DDBD2' THEN '414'
    WHEN SATIR.BELGE_TUR = 'D3BF0835-AAFD-4DE5-AAE0-8A84AEEAE4D2' THEN '46'
    WHEN SATIR.BELGE_TUR = '345575AD-4DD5-4FA0-A4C7-3CFDF99D4DD9' THEN '55'
    WHEN SATIR.BELGE_TUR = 'A9A94EE3-E22B-4AE4-B99C-77530FC3913F' THEN '54'
    WHEN SATIR.BELGE_TUR = 'C10C63DE-CEDE-4478-8D9A-3864923376AD' THEN '413'
    WHEN SATIR.BELGE_TUR = 'BE9B528F-C8D1-43FC-B2CB-EA0BC42A8F10' THEN '414'
    WHEN SATIR.BELGE_TUR = 'DE6C2A46-B739-4299-B34E-B858D716D13F' THEN '20'
    WHEN SATIR.BELGE_TUR = '0C7732FF-71E9-46D3-BE88-8D0DAB7CFE64' THEN '20'
    WHEN SATIR.BELGE_TUR = '5D1948B7-3632-40F0-B823-513AEDA1354C' THEN '97'
    WHEN SATIR.BELGE_TUR = 'B74D208A-1D38-4EEF-9E71-032EC58318A2' THEN '20'
    WHEN SATIR.BELGE_TUR = 'CFD6AFD6-B0D2-413F-9414-D870FD7EBFF5' THEN '55'
    WHEN SATIR.BELGE_TUR = '5C57DA80-B8AD-4A8B-9790-05939D2FA9FB' THEN '99'
    WHEN SATIR.BELGE_TUR = '521E3C16-8C9E-4010-8016-7D03623F23CE' THEN '99'
    WHEN SATIR.BELGE_TUR = '3D6837F8-6566-422B-A843-58C01FB0A380' THEN '55'
    WHEN SATIR.BELGE_TUR = 'EB4D5A61-CC40-4C39-9F15-C217D4C90047' THEN '35'
    WHEN SATIR.BELGE_TUR = '455D9B57-BD19-4128-A534-2820BD45388F' THEN '414'
    WHEN SATIR.BELGE_TUR = 'DAB004AF-F05F-48A4-935A-9BD9BF3076D5' THEN '57'
    WHEN SATIR.BELGE_TUR = '58467D4E-79C2-4679-8E67-1B5D85A2B2CC' THEN '34'
    ELSE '414'  -- Varsayılan değer
  END AS belgetipi,
  
  SATIR.BELGE_NO  AS belgeserino,
  SATIR.BELGE_NO AS belgeno,
  SATIR.ACIKLAMA AS aciklama,
  SATIR.BORC_MIKTARI AS miktar,
  SATIR.ALACAK_MIKTARI AS miktar,
  SATIR.BORC_TUTARI AS borctutar,
  SATIR.ALACAK_TUTARI AS alactutar,
  
  REPLACE(REPLACE(CASE WHEN LEN(HESAP.KOD)=3 THEN HESAP.KOD + ' 999'   ELSE HESAP.KOD END,'.',' '),'-',' ') AS hesapkodu_01,
  HESAP.HESAP_ADI AS hesapadi_01
  
  
FROM 
    [dbo].[F0001_2024_T_BIL_FIS_BSL] AS BSL
INNER JOIN 
    [dbo].[F0001_2024_T_BIL_FIS_SATIR] AS SATIR ON BSL.ID = SATIR.FIS_ID
INNER JOIN 
    [dbo].[F0001_2024_T_BIL_HESAP_PLAN] AS HESAP ON SATIR.HESAP_KODU = HESAP.ID;

SELECT 
  Fistar as fistarih
 ,Fisno as fisno
 ,MUHASEBE_FISLERI.Aciklama AS aciklama
 ,REPLACE(REPLACE(CASE WHEN LEN(Gmkod)=3 THEN Gmkod + ' 999'   ELSE Gmkod END,'.',' '),'-',' ') AS hesapkodu_01
 ,CASE WHEN Belge_Turu='8' THEN '413'ELSE '' END as belgetipi
 ,CASE WHEN Fistur = '0' THEN '1' WHEN Fistur = '3' THEN '4' ELSE '4' END fistip
 ,pln.Aciklama AS hesapadi_01
 ,Evrakno  AS belgeserino
 ,Evrakno  AS belgeno
 ,Borclu   AS borctutar
 ,Alacakli AS alactutar 
FROM [dbo].[yevmiye] AS MUHASEBE_FISLERI
LEFT JOIN hesplan AS pln ON MUHASEBE_FISLERI.Gmkod=pln.Kod
 
WHERE 1=1 
 and CONVERT(DATETIME, MUHASEBE_FISLERI.fistar, 103) >= CONVERT(DATETIME,  Orka_Param_BaslangicTarihi , 103)  
 and CONVERT(DATETIME, MUHASEBE_FISLERI.fistar, 103) <  CONVERT(DATETIME,  Orka_Param_BitisTarihi , 103)  
 --and MUHASEBE_FISLERI.Evrakno >= 'Orka_Param_BaslangicBelgeNo'
 --and MUHASEBE_FISLERI.Evrakno <= 'Orka_Param_BitisBelgeNo' 
ORDER BY fistarih

SELECT 
 mfis_tip as fistip,
 mfis_sira as fisno,
 mfis_yevmiye_no as fisno,
 mfis_aciklama as fisaciklama,
 mfis_hes_kod as hesapkodu_01,
 mfis_belge_tarihi as belgetarih,
 mfis_belge_no as belgeno,
 mfis_hes_aciklama as aciklama,
 mfis_borc as borctutar,
 mfis_alacak as alactutar
FROM PW_Orka_Param_FirmaKodu_Orka_Param_DonemKodu_MFIS