assaq

{"Meta":{"href":"https://195.175.208.178:32002/api/v1/queries/unsafe/?tsql=SELECT ITM.LOGICALREF AS StokRef ,ITM.CODE AS StokKod, ITM.NAME AS Stok, ITM.SPECODE AS StokOzelKod,ITM.CARDTYPE AS StokKartType,ITM.CYPHCODE AS StokYetkiKod,ITM.VAT AS Kdv, ITM.CAPIBLOCK_CREADEDDATE as StokCreatedDate,ITM.CAPIBLOCK_MODIFIEDDATE as StokModifiedDate, BRCD.BARCODE AS StokBarkod,ISNULL(BRCD2.BARCODE,\'\') AS StokBarkod2, ORFL.LOGICALREF AS SiparisSatirRef,ORFL.STATUS AS SiparisSatirStatus, ORFL.LINETYPE AS SiparisSatirTipi,ORFL.LINENO_ AS SiparisSatirNo,ORFL.AMOUNT AS SiparisSatirAdet,ORFL.PRICE AS SiparisSatirFiyat, orfl.SHIPPEDAMOUNT AS SiparisSatirSevkEdilmisAdet,ORFL.LINENET AS SiparisSatirNetTutar,ORFL.RESERVEAMOUNT AS SiparisSatirRezerveAdet FROM MaviCizgiTiger.dbo.LG_120_04_ORFICHE AS ORF WITH(NOLOCK) INNER JOIN MaviCizgiTiger.dbo.LG_120_04_ORFLINE AS ORFL WITH(NOLOCK) ON ORF.LOGICALREF = ORFL.ORDFICHEREF LEFT OUTER JOIN MaviCizgiTiger.dbo.LG_120_SHIPINFO AS SHP WITH(NOLOCK) ON ORF.SHIPINFOREF = SHP.LOGICALREF INNER JOIN MaviCizgiTiger.dbo.LG_120_ITEMS AS ITM WITH(NOLOCK) ON ORFL.STOCKREF = ITM.LOGICALREF INNER JOIN MaviCizgiTiger.dbo.LG_120_CLCARD AS C WITH(NOLOCK) ON ORF.CLIENTREF = C.LOGICALREF LEFT OUTER JOIN MaviCizgiTiger.dbo.LG_120_UNITBARCODE AS BRCD WITH(NOLOCK) ON ITM.LOGICALREF = BRCD.ITEMREF and BRCD.LINENR = 1 LEFT OUTER JOIN MaviCizgiTiger.dbo.LG_120_UNITBARCODE AS BRCD2 WITH(NOLOCK) ON ITM.LOGICALREF = BRCD2.ITEMREF and BRCD2.LINENR = 2 WHERE ORF.TRCODE = 1 AND ORF.LOGICALREF = 37975 order by 2","mediaType":"application/json; charset=UTF-8","apiVersion":"v1"},"count":3,"items":[{"StokRef":135,"StokKod":".078021","Stok":"YAKLA\xc5\x9eIM DERG\xc4\xb0 304 /YAKLA\xc5\x9eIM","StokOzelKod":"YAKLA\xc5\x9eIM","StokKartType":1,"StokYetkiKod":"35","Kdv":0.0,"StokCreatedDate":"2020-02-17T16:38:12","StokModifiedDate":"2018-03-29T12:33:02","StokBarkod":null,"StokBarkod2":"","SiparisSatirRef":164659,"SiparisSatirStatus":4,"SiparisSatirTipi":4,"SiparisSatirNo":3,"SiparisSatirAdet":1.0,"SiparisSatirFiyat":14.92,"SiparisSatirSevkEdilmisAdet":0.0,"SiparisSatirNetTutar":14.92,"SiparisSatirRezerveAdet":0.0},{"StokRef":170651,"StokKod":".152963","Stok":"RUM\xc4\xb0N\xc4\xb0N K\xc4\xb0TABI/S.\xc3\x96ZKAN/ARTEM\xc4\xb0S","StokOzelKod":"0005","StokKartType":12,"StokYetkiKod":"ARTEM\xc4\xb0S","Kdv":0.0,"StokCreatedDate":"2020-02-19T13:29:55","StokModifiedDate":"2014-11-25T14:40:06","StokBarkod":"9786051425382","StokBarkod2":"","SiparisSatirRef":164658,"SiparisSatirStatus":4,"SiparisSatirTipi":0,"SiparisSatirNo":2,"SiparisSatirAdet":1.0,"SiparisSatirFiyat":0.0,"SiparisSatirSevkEdilmisAdet":0.0,"SiparisSatirNetTutar":0.0,"SiparisSatirRezerveAdet":0.0},{"StokRef":280230,"StokKod":".245142","Stok":"\xc4\xb0LK\xc3\x87A\xc4\x9e FELSEFE TAR\xc4\xb0H\xc4\xb0 SET/A.ARSLAN/ALFA","StokOzelKod":"0001","StokKartType":12,"StokYetkiKod":"ALFA","Kdv":0.0,"StokCreatedDate":"2023-03-14T10:57:20","StokModifiedDate":null,"StokBarkod":"9786254497438","StokBarkod2":"","SiparisSatirRef":164657,"SiparisSatirStatus":4,"SiparisSatirTipi":0,"SiparisSatirNo":1,"SiparisSatirAdet":1.0,"SiparisSatirFiyat":462.0,"SiparisSatirSevkEdilmisAdet":0.0,"SiparisSatirNetTutar":462.0,"SiparisSatirRezerveAdet":0.0}]}