Logo Teminat Bordroları Raporu / Sql Tablo İsimleri

Merhaba,Logo veritabanında, teminat bordroları ile ilgili tablolar aşağıdaki gibidir.

LG_XXX_XX_COLLCOMMPAYTR

LG_XXX_XX_COLLATRLTRAN

LG_XXX_XX_COLLATRLCARD

LG_XXX_XX_CLCOLLATRLRISK

LG_XXX_XX_COLLATRLROLL

Teminat bordroları ile ilgili örnek bir rapor sorgusu aşağıdaki gibidir. İhtiyacınıza göre ekstra alan ekleyebilir veya çıkarabilirsiniz.

SELECT     

BANKACC.DEFINITION_ AS [BANKA HESAP], 

COLLATRLROLL.GENEXP1 AS [KISA AÇIKLAMA], 

COLLATRLCARD.PORTFOYNO AS [MEKTUP NO],

CASE COLLATRLCARD.COLLUSETYPE WHEN 3 THEN 'KESİN' WHEN '2' THEN 'AVANS' WHEN 1 THEN 'GEÇİCİ' ELSE 'DİĞER' END AS [MEKTUP TÜR],

COLLATRLCARD.DEFINITION_ AS KONUSU, 

COLLATRLCARD.BEGDATE AS [VERİLİŞ TARİHİ], 

COLLATRLCARD.ENDDATE AS VADESİ,

COLLATRLCARD.AMOUNT AS TUTAR, CLCARD.DEFINITION_ AS [CARİ HESAP]

FROM LG_001_01_COLLATRLCARD COLLATRLCARD  

LEFT OUTER JOIN LG_001_01_COLLATRLROLL COLLATRLROLL ON COLLATRLCARD.LOGICALREF = COLLATRLROLL.LOGICALREF 

LEFT OUTER JOIN LG_048_BANKACC BANKACC ON COLLATRLCARD.BANKREF = BANKACC.LOGICALREF 

LEFT OUTER JOIN LG_048_CLCARD CLCARD ON COLLATRLCARD.CLCARDREF = CLCARD.LOGICALREF