Logo (Tiger 3 / Wings / GO 3 / Netsis)

-- Cari kartlar → complete { counterparties: [...] }
SELECT CODE        AS external_id,
       DEFINITION_ AS name,
       TAXNR       AS tax_number,
       EMAILADDR   AS email
FROM   LG_001_CLCARD
WHERE  ACTIVE = 0;

-- Cari hareketleri → …/statement/rows (parça parça) + complete { statement: { total_parts } }  (@cariRef ve dönem talepten gelir)
SELECT TRANNO                                   AS reference_no,
       CONVERT(varchar(10), DATE_, 23)           AS date,
       LINEEXP                                   AS description,
       CASE WHEN SIGN = 0 THEN AMOUNT ELSE -AMOUNT END AS amount,
       'TRY'                                     AS currency
FROM   LG_001_01_CLFLINE
WHERE  CLIENTREF = @cariRef AND CANCELLED = 0
ORDER  BY DATE_;