Logo Stok Muhasebe Bağlantı Kodları Raporu

Aşağıda paylaştığım sorguyu çalıştırarak stok kartı içindeki Muhasebe Bağlantıları sekmesinde tanımlı olan tüm muhasebe hesap kodlarını ve açıklamalarını listeleyebilirsiniz.

SELECT
I.CODE MalzemeKodu,
I.NAME MalzemeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=1 AND CARDREF = I.LOGICALREF)),'') AS AlımMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=1 AND CARDREF = I.LOGICALREF)),'') AS AlımMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=2 AND CARDREF = I.LOGICALREF)),'') AS DigerGirislerMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=2 AND CARDREF = I.LOGICALREF)),'') AS DigerGirislerMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=3 AND CARDREF = I.LOGICALREF)),'') AS SatışMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=3 AND CARDREF = I.LOGICALREF)),'') AS SatışMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=4 AND CARDREF = I.LOGICALREF)),'') AS DiğerÇıkışlarMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=4 AND CARDREF = I.LOGICALREF)),'') AS DiğerÇıkışlarMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=5 AND CARDREF = I.LOGICALREF)),'') AS SarfMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=5 AND CARDREF = I.LOGICALREF)),'') AS SarfMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=6 AND CARDREF = I.LOGICALREF)),'') AS FireMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=6 AND CARDREF = I.LOGICALREF)),'') AS FireMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=7 AND CARDREF = I.LOGICALREF)),'') AS ÜretimMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=7 AND CARDREF = I.LOGICALREF)),'') AS ÜretimMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=8 AND CARDREF = I.LOGICALREF)),'') AS KullanıcıTanımlı1MuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=8 AND CARDREF = I.LOGICALREF)),'') AS KullanıcıTanımlı1MuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=9 AND CARDREF = I.LOGICALREF)),'') AS KullanıcıTanımlı2MuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=9 AND CARDREF = I.LOGICALREF)),'') AS KullanıcıTanımlı2MuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=10 AND CARDREF = I.LOGICALREF)),'') AS AlımİadeMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=10 AND CARDREF = I.LOGICALREF)),'') AS AlımİadeMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=11 AND CARDREF = I.LOGICALREF)),'') AS SatışİadeMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=11 AND CARDREF = I.LOGICALREF)),'') AS SatışİadeMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=12 AND CARDREF = I.LOGICALREF)),'') AS SatınAlmaİndirimMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=12 AND CARDREF = I.LOGICALREF)),'') AS SatınAlmaİndirimMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=13 AND CARDREF = I.LOGICALREF)),'') AS SatışİndirimMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=13 AND CARDREF = I.LOGICALREF)),'') AS SatışİndirimMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=14 AND CARDREF = I.LOGICALREF)),'') AS SatınalmaMasraflarıMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=14 AND CARDREF = I.LOGICALREF)),'') AS SatınalmaMasraflarıMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=15 AND CARDREF = I.LOGICALREF)),'') AS SatışMasraflarıMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=15 AND CARDREF = I.LOGICALREF)),'') AS SatışMasraflarıMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=16 AND CARDREF = I.LOGICALREF)),'') AS AlınanPromosyonlarMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=16 AND CARDREF = I.LOGICALREF)),'') AS AlınanPromosyonlarMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=17 AND CARDREF = I.LOGICALREF)),'') AS VerilenPromosyonlarMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=17 AND CARDREF = I.LOGICALREF)),'') AS VerilenPromosyonlarMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=18 AND CARDREF = I.LOGICALREF)),'') AS PromosyonKdvGiderleriMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=18 AND CARDREF = I.LOGICALREF)),'') AS PromosyonKdvGiderleriMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=95 AND CARDREF = I.LOGICALREF)),'') AS SayımFazlasıMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=95 AND CARDREF = I.LOGICALREF)),'') AS SayımFazlasıMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=96 AND CARDREF = I.LOGICALREF)),'') AS SayımEksiğiMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=96 AND CARDREF = I.LOGICALREF)),'') AS SayımEksiğiMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=99 AND CARDREF = I.LOGICALREF)),'') AS SMMMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=99 AND CARDREF = I.LOGICALREF)),'') AS SMMMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=110 AND CARDREF = I.LOGICALREF)),'') AS FiyatFarkıMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=110 AND CARDREF = I.LOGICALREF)),'') AS FiyatFarkıMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=111 AND CARDREF = I.LOGICALREF)),'') AS MiktarFarkıMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=111 AND CARDREF = I.LOGICALREF)),'') AS MiktarFarkıMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=119 AND CARDREF = I.LOGICALREF)),'') AS YansıtmaMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=119 AND CARDREF = I.LOGICALREF)),'') AS YansıtmaMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=135 AND CARDREF = I.LOGICALREF)),'') AS İndirilenEkVergiMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=135 AND CARDREF = I.LOGICALREF)),'') AS İndirilenEkVergiMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=136 AND CARDREF = I.LOGICALREF)),'') AS SatınAlmaFiyatFarkıMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=136 AND CARDREF = I.LOGICALREF)),'') AS SatınAlmaFiyatFarkıMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=137 AND CARDREF = I.LOGICALREF)),'') AS SatışFiyatFarkıMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=137 AND CARDREF = I.LOGICALREF)),'') AS SatışFiyatFarkıMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=143 AND CARDREF = I.LOGICALREF)),'') AS YurtDışıSatışlarMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=143 AND CARDREF = I.LOGICALREF)),'') AS YurtDışıSatışlarMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=162 AND CARDREF = I.LOGICALREF)),'') AS İhraçKayıtlıSatışlarMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=162 AND CARDREF = I.LOGICALREF)),'') AS İhraçKayıtlıSatışlarMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=172 AND CARDREF = I.LOGICALREF)),'') AS İhraçKayıtlıAlımlarMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=172 AND CARDREF = I.LOGICALREF)),'') AS İhraçKayıtlıAlımlarMuhasebeAdı,
ISNULL((SELECT CODE FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=199 AND CARDREF = I.LOGICALREF)),'') AS SMMTFRSMuhasebeKodu,
ISNULL((SELECT DEFINITION_ FROM LG_001_EMUHACC WHERE LOGICALREF = (SELECT ACCOUNTREF FROM LG_001_CRDACREF WHERE TRCODE=1 AND TYP=199 AND CARDREF = I.LOGICALREF)),'') AS SMMTFRSMuhasebeAdı

FROM LG_001_ITEMS I

WHERE I.CARDTYPE NOT IN (20,21,22) --AND I.CODE='000006'