sql den istediğim bir cari kodun cari hesap ekstresini nasıl alabilirim.
bu sorgudan bir şey çıkarmı?
yardımcı olurmusunuz.
SELECT * FROM
(SELECT
CLNTC.CODE "Cari Kodu", CLNTC.DEFINITION_ "Cari Açıklaması",
CTRNS.DATE_ "C.Hareket Tarihi",
CTRNS.TRANNO "C.Hareket Fiş No", CTRNS.LINEEXP "C.Hareket Satır Açıklaması",
CTRNS.AMOUNT "C.Hareket Tutarı",
CLFIC.LOGICALREF CLFIC_LOGICALREF, CLFIC.FICHENO "C.Fiş No", CLFIC.DATE_ "C.Fiş Tarihi", CLFIC.DOCODE "C.Fiş Belge No",
CLFIC.TRCODE "C.Fiş Türü", CLFIC.SPECCODE "C.Fiş Özel Kodu", CLFIC.DEBIT "C.Fiş Borç",
CLFIC.CREDIT "C.Fiş Alacak",
INVFC.LOGICALREF "Fatura Ref", INVFC.GRPCODE "Fatura Grup Kodu", INVFC.TRCODE "Fatura Türü",
INVFC.FICHENO "Fatura Fiş No", INVFC.DATE_ "Fatura Tarihi", INVFC.TIME_ "Fatura Zamanı", INVFC.DOCODE "Fatura Belge No",
INVFC.SPECODE "Fatura Özel Kod", INVFC.CYPHCODE "Fatura Yetki Kodu", INVFC.CLIENTREF INVFC_CLIENTREF,
INVFC.RECVREF INVFC_RECVREF, INVFC.CENTERREF INVFC_CENTERREF, INVFC.ACCOUNTREF INVFC_ACCOUNTREF,
INVFC.SOURCEINDEX "Fatura Ambar No", INVFC.SOURCECOSTGRP "Fatura Maliyet Grubu", INVFC.CANCELLED "Fatura İptal Durumu",
INVFC.ACCOUNTED "Fat. Muhasebeleşmiş", INVFC.PAIDINCASH "Fat.Peşin", INVFC.FROMKASA "Fat.Kasadan",
INVFC.ENTEGSET INVFC_ENTEGSET, INVFC.VAT "Fatura KDV Oranı", INVFC.ADDDISCOUNTS "Fatura Genel İndirimler",
INVFC.TOTALDISCOUNTS "Fatura Toplam İndirim", INVFC.TOTALDISCOUNTED "Fat.Hesaplanmış İskonto",
INVFC.ADDEXPENSES "Fatura Genel Masraflar", INVFC.TOTALEXPENSES "Fatura Toplam Masraf",
INVFC.DISTEXPENSE "Fatura Masraf", INVFC.TOTALDEPOZITO "Fatura Toplam Depozito",
INVFC.TOTALPROMOTIONS "Fatura Toplam Promosyon", INVFC.VATINCGROSS "Fatura KDV Matrahı", INVFC.TOTALVAT "Fatura Toplam KDV",
INVFC.GROSSTOTAL "Fatura Bürüt Toplam", INVFC.NETTOTAL "Fatura Net Toplamı", INVFC.GENEXP1 "Fatura Genel Açıklama 1",
INVFC.GENEXP2 "Fatura Genel Açıklama 2", INVFC.GENEXP3 "Fatura Genel Açıklama 3", INVFC.GENEXP4 "Fatura Genel Açıklama 4",
INVFC.INTERESTAPP INVFC_INTERESTAPP, INVFC.TRCURR "Fatura İD Türü", INVFC.TRRATE "Fatura İD Kuru",
INVFC.TRNET "Fatura İD Tutarı", INVFC.REPORTRATE "Fatura RD Kuru", INVFC.REPORTNET "Fatura RD Tutarı",
INVFC.ONLYONEPAYLINE INVFC_ONLYONEPAYLINE, INVFC.KASTRANSREF INVFC_KASTRANSREF, INVFC.PAYDEFREF INVFC_PAYDEFREF,
INVFC.PRINTCNT INVFC_PRINTCNT, INVFC.GVATINC INVFC_GVATINC, INVFC.BRANCH "Fatura İşyeri No",
INVFC.DEPARTMENT "Fatura Bölüm No", INVFC.ACCFICHEREF INVFC_ACCFICHEREF, INVFC.ADDEXPACCREF INVFC_ADDEXPACCREF,
INVFC.ADDEXPCENTREF INVFC_ADDEXPCENTREF, INVFC.DECPRDIFF INVFC_DECPRDIFF,
INVFC.SALESMANREF INVFC_SALESMANREF,
INVFC.CANCELLEDACC "Fatura Muh Fiş İptali", INVFC.SHPTYPCOD "Fatura Teslim Şekli", INVFC.SHPAGNCOD "Fatura Taşıyıcı Firmalar",
INVFC.TRACKNR "Fatura Takip No", INVFC.GENEXCTYP INVFC_GENEXCTYP, INVFC.LINEEXCTYP INVFC_LINEEXCTYP,
INVFC.TRADINGGRP "Fatura Ticari İşlem Grubu", INVFC.TEXTINC INVFC_TEXTINC, INVFC.SITEID INVFC_SITEID,
INVFC.RECSTATUS INVFC_RECSTATUS, INVFC.ORGLOGICREF INVFC_ORGLOGICREF, INVFC.FACTORYNR "Fatura Fabrika No",
INVFC.WFSTATUS INVFC_WFSTATUS, INVFC.SHIPINFOREF INVFC_SHIPINFOREF, INVFC.DISTORDERREF INVFC_DISTORDERREF,
INVFC.SENDCNT INVFC_SENDCNT, INVFC.DLVCLIENT INVFC_DLVCLIENT, INVFC.COSTOFSALEFCREF INVFC_COSTOFSALEFCREF,
INVFC.OPSTAT INVFC_OPSTAT, INVFC.DOCTRACKINGNR "Fatura Doküman İzl.No", INVFC.TOTALADDTAX "Fatura Toplam ÖTV",
INVFC.PAYMENTTYPE "Fatura Ödeme Tipi", INVFC.INFIDX "Fatura Enflasyon Endeksi", INVFC.ACCOUNTEDCNT INVFC_ACCOUNTEDCNT,
INVFC.ORGLOGOID INVFC_ORGLOGOID, INVFC.FROMEXIM INVFC_FROMEXIM, INVFC.FRGTYPCOD INVFC_FRGTYPCOD,
INVFC.EXIMFCTYPE "Fatura Dış Ticaret Tipi", INVFC.FROMORDWITHPAY INVFC_FROMORDWITHPAY
FROM LG_012_02_CLFLINE CTRNS LEFT OUTER JOIN
LG_012_CLCARD CLNTC ON CTRNS.CLIENTREF = CLNTC.LOGICALREF LEFT OUTER JOIN
LG_012_PAYPLANS PAYPL ON CTRNS.PAYDEFREF = PAYPL.LOGICALREF LEFT OUTER JOIN
LG_012_02_CLFICHE CLFIC ON CTRNS.SOURCEFREF = CLFIC.LOGICALREF LEFT OUTER JOIN
LG_012_02_INVOICE INVFC ON CTRNS.SOURCEFREF = INVFC.LOGICALREF LEFT OUTER JOIN
LG_012_02_CSROLL RLFIC ON CTRNS.SOURCEFREF = RLFIC.LOGICALREF LEFT OUTER JOIN
LG_012_02_EMFICHE EMFIC ON CTRNS.ACCFICHEREF = EMFIC.LOGICALREF LEFT OUTER JOIN
LG_SLSMAN SLSM ON INVFC.SALESMANREF = SLSM.LOGICALREF
WHERE
(CTRNS.CANCELLED <> 1)) AS DYNMQRY
WHERE
((DYNMQRY.[Cari Kodu] >= '335.01.01') AND (DYNMQRY.[Cari Kodu] <= '335.01.01'))
ORDER BY DYNMQRY.[Cari Kodu] ASC, DYNMQRY.[C.Hareket Tarihi] ASC
