—2014—

USE [TIGERPLUS]
GO
/****** Object:  View [dbo].[LV_001_SATIS_IRSALIYE_SATIRLARI]    Script Date: 09/24/2014 20:21:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[LV_001_SATIS_IRSALIYE_SATIRLARI]
AS
SELECT     S.DATE_ AS TARIH, F.FICHENO AS IRSALIYE_NO, C.CODE AS CARI_KODU, C.DEFINITION_ AS CARI_ADI, I.CODE AS STOK_KODU, I.NAME AS STOK_ADI,
                      S.AMOUNT AS MIKTAR, F.CAPIBLOCK_MODIFIEDDATE AS SON_GUNCELLEME_TARIHI, F.CAPIBLOCK_CREADEDDATE AS ILK_KAYIT_TARIHI
FROM         dbo.LG_001_01_STLINE AS S INNER JOIN
                      dbo.LG_001_01_STFICHE AS F ON S.STFICHEREF = F.LOGICALREF INNER JOIN
                      dbo.LG_001_CLCARD AS C ON C.LOGICALREF = S.CLIENTREF INNER JOIN
                      dbo.LG_001_ITEMS AS I ON I.LOGICALREF = S.STOCKREF
WHERE     (S.TRCODE = 8)

—2014+2025—

USE [TIGERPLUS]
GO
/****** Object:  View [dbo].[LV_001_SATIS_IRSALIYE_SATIRLARI]    Script Date: 03/23/2015 09:15:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[LV_001_SATIS_IRSALIYE_SATIRLARI]
AS
SELECT     S.DATE_ AS TARIH, F.FICHENO AS IRSALIYE_NO, C.CODE AS CARI_KODU, C.DEFINITION_ AS CARI_ADI, I.CODE AS STOK_KODU, I.NAME AS STOK_ADI,
                      S.AMOUNT AS MIKTAR, F.CAPIBLOCK_MODIFIEDDATE AS SON_GUNCELLEME_TARIHI, F.CAPIBLOCK_CREADEDDATE AS ILK_KAYIT_TARIHI
FROM         dbo.LG_001_01_STLINE AS S INNER JOIN
                      dbo.LG_001_01_STFICHE AS F ON S.STFICHEREF = F.LOGICALREF INNER JOIN
                      dbo.LG_001_CLCARD AS C ON C.LOGICALREF = S.CLIENTREF INNER JOIN
                      dbo.LG_001_ITEMS AS I ON I.LOGICALREF = S.STOCKREF
WHERE     (S.TRCODE = 8)
UNION ALL
SELECT     S.DATE_ AS TARIH, F.FICHENO AS IRSALIYE_NO, C.CODE AS CARI_KODU, C.DEFINITION_ AS CARI_ADI, I.CODE AS STOK_KODU, I.NAME AS STOK_ADI,
                      S.AMOUNT AS MIKTAR, F.CAPIBLOCK_MODIFIEDDATE AS SON_GUNCELLEME_TARIHI, F.CAPIBLOCK_CREADEDDATE AS ILK_KAYIT_TARIHI
FROM         dbo.LG_002_01_STLINE AS S INNER JOIN
                      dbo.LG_002_01_STFICHE AS F ON S.STFICHEREF = F.LOGICALREF INNER JOIN
                      dbo.LG_002_CLCARD AS C ON C.LOGICALREF = S.CLIENTREF INNER JOIN
                      dbo.LG_002_ITEMS AS I ON I.LOGICALREF = S.STOCKREF
WHERE     (S.TRCODE = 8)