Logo Go3, Tiger3 ve Tiger3 Enterprise programlarında tanımlanan cari hesaba ait tüm bilgiler, aşağıdaki sorgu yardımı ile rapor olarak alınabilir. Rapordaki firma numarası alanını değiştirmeniz yeterlidir.
SELECT
CLC.CODE AS KODU,
CLC.DEFINITION_ AS UNVANI,
CLC.SPECODE AS OZEL_KOD,
ADDR1 AS ADRES_1,
ADDR2 AS ADRES_2,
TOWN AS ILCE,
CITY AS IL,
POSTCODE AS POSTA_KODU,
TELCODES1 AS TEL1_ALAN_KODU,
TELNRS1 AS TELEFON_1,
TELEXTNUMS1 AS DAHİLİ_1,
TELCODES2 AS TEL2_ALAN_KODU,
TELNRS2 AS TELEFON_2,
TELEXTNUMS2 AS DAHİLİ_2,
FAXCODE AS FAX_ALAN_KODU,
FAXNR AS FAX_NO,
CASE
WHEN CLC.ISPERSCOMP=0 THEN CLC.TAXNR
WHEN CLC.ISPERSCOMP=1 THEN CLC.TCKNO
END AS VERGİ_KİMLİK_NO,
TAXOFFICE AS VERGİ_DAİRESİ,
TAXOFFCODE AS VERGİ_DAİRESİ_KODU,
INCHARGE AS İLGİLİ,
INCHARGE2 AS İLGİLİ_2,
INCHARGE3 AS İLGİLİ_3,
EMAILADDR AS EPOSTA_ADRESİ,
CLC.CYPHCODE AS YETKİ_KODU,
CLC.SPECODE3 AS OZEL_KOD3,
CLC.SPECODE4 AS OZEL_KOD4,
CLC.SPECODE5 AS OZEL_KOD5,
EMU.CODE AS MUHASEBE_KODU,
COUNTRYCODE AS ÜLKE_KODU,
CITYCODE AS IL_KODU,
TOWNCODE AS ILCE_KODU,
DISTRICTCODE AS SEMT_KODU,
EMAILADDR2 AS EPOSTA_ADRESI_2,
EMAILADDR3 AS EPOSTA_ADRESI_3,
PYP.CODE AS ODEME_PLANI,
PYP.DEFINITION_ AS ODEME_PLANI_ACIKLAMASI,
SURNAME AS SOYADI,
NAME AS ADI,
LTRSENDEMAILADDR AS MEKTUP,
FBSSENDEMAILADDR AS FBS_MUTABAKAT,
FBASENDEMAILADDR AS FBA_MUTABAKAT,
EXTSENDEMAILADDR AS EKSTRE,
CASE CLC.CCURRENCY
WHEN 0 THEN 'TL'
WHEN 1 THEN 'USD'
WHEN 20 THEN 'EUR'
END AS DOVIZ_TURU
FROM LG_002_CLCARD CLC
LEFT JOIN LG_002_PAYPLANS PYP ON PYP.LOGICALREF=CLC.PAYMENTREF
LEFT JOIN LG_002_CRDACREF CRD ON CRD.CARDREF=CLC.LOGICALREF AND CRD.TRCODE=5
LEFT JOIN LG_002_EMUHACC EMU ON EMU.LOGICALREF=CRD.ACCOUNTREF
WHERE CLC.CODE<>'ÿ' AND CLC.ACTIVE=0
