USE [LOGODB]
GO
/****** Object: View [dbo].[VW_ZENPOS_TERAZI_DOSYASI_EXCELI_HAZIRLA_CAS] Script Date: 30.11.2021 12:29:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VW_ZENPOS_TERAZI_DOSYASI_EXCELI_HAZIRLA_CAS] AS
SELECT
[ID] AS PLUNo
,[KOD] AS ItemCode
,[ACIKLAMA] AS Name1
,[ACIKLAMA2] AS Name2
,[BIRIMLIBARKOD],[GRUPKOD] AS GCode
,[TERAZIKODU]
,REPLACE(CONVERT(VARCHAR, [FIYAT]),'.','') AS UPrice
,[DARA] AS Tare
FROM [LOGODB].[dbo].[VW_ZENPOS_TERAZI_DOSYASI_EXCELI_HAZIRLA]
GO