Logo ERP Veritabanı Tabloları Rehberi

-- Tablo adı yapısı:
LG_FİRMANO_DÖNEMNO_TABLOADIBASE
LG_FİRMANO_TABLOADIBASE   -- Döneme bağlı olmayan tablolar

-- Örnek: 001 numaralı firma, 01 dönemi, fatura tablosu
LG_001_01_INVOICE

-- Örnek: 001 numaralı firma, cari kart tablosu
LG_001_CLCARD

SELECT CODE, DEFINITION_, TAXNR, TELNRS1,
    CASE CARDTYPE
        WHEN 1 THEN 'Alıcı'
        WHEN 2 THEN 'Satıcı'
        WHEN 3 THEN 'Alıcı+Satıcı'
    END AS KartTipi
FROM LG_001_CLCARD
WHERE ACTIVE = 0
ORDER BY CODE;

SELECT I.FICHENO, I.DATE_, I.CLIENTCODE,
       C.DEFINITION_, I.GROSSTOTAL, I.TOTALVAT, I.NETTOTAL
FROM LG_001_01_INVOICE I
JOIN LG_001_CLCARD C ON C.LOGICALREF = I.CLIENTREF
WHERE I.TRCODE IN (2, 3)
  AND I.DATE_ BETWEEN '2026-01-01' AND '2026-03-31'
ORDER BY I.DATE_ DESC;

SELECT S.ITEMCODE, S.ITEMNAME,
       SUM(S.AMOUNT) AS ToplamMiktar,
       SUM(S.LINENET) AS ToplamCiro
FROM LG_001_01_STLINE S
JOIN LG_001_01_INVOICE I ON I.LOGICALREF = S.INVOICEREF
WHERE I.TRCODE IN (2, 3)
GROUP BY S.ITEMCODE, S.ITEMNAME
ORDER BY ToplamCiro DESC;