﻿
--drop table BS_EXPRESS_LANGUAGE
--drop table BS_EXPRESS_MESSAGE
--drop table BS_EXPRESS_WORKINFO
--drop table BS_EXPRESS_TEMPLATE

--Dil
CREATE TABLE BS_EXPRESS_LANGUAGE([ID] [int] IDENTITY(0,1) NOT NULL, [EXPLANATION] [nvarchar](30) NULL)

INSERT INTO [dbo].BS_EXPRESS_LANGUAGE ([EXPLANATION]) VALUES ('TURKISH')
INSERT INTO [dbo].BS_EXPRESS_LANGUAGE ([EXPLANATION]) VALUES ('ENGLISH')

--Yetkiler
CREATE TABLE BS_EXPRESS_TEMPLATE(
                        [ID] [int] IDENTITY(1,1) NOT NULL,
	                    [CODE] [smallint] NULL,
                        [EXPLANATION] [nvarchar](30) NULL,
                        [RIGHTS] [nvarchar](200) NULL,
                        [POSRIGHTS] [nvarchar](200) NULL,
						[POSITION_] [nvarchar](11) NULL)

INSERT INTO [dbo].[BS_EXPRESS_TEMPLATE] ([CODE],[EXPLANATION],[RIGHTS],[POSRIGHTS],[POSITION_] ) VALUES (0, 'SUPERVISOR', '??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????', '??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????','0' )
INSERT INTO [dbo].[BS_EXPRESS_TEMPLATE] ([CODE],[EXPLANATION],[RIGHTS],[POSRIGHTS],[POSITION_] ) VALUES (1, 'USER-1',  '??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????', '??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????','1' )
INSERT INTO [dbo].[BS_EXPRESS_TEMPLATE] ([CODE],[EXPLANATION],[RIGHTS],[POSRIGHTS],[POSITION_] ) VALUES (2, 'USER-2',  '??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????', '??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????','2' )

--Dil Mesajları 
CREATE TABLE BS_EXPRESS_MESSAGE(
						[ID] [int] IDENTITY(1,1) NOT NULL,
	                    [MESSAGE_ID] [nchar](15) NULL,
                        [MESSAGE_NUM] [smallint] NULL,
                        [MESSAGE_00] [nvarchar](100) NULL,
                        [MESSAGE_01] [nvarchar](100) NULL,
                        [MESSAGE_02] [nvarchar](100) NULL,
                        [MESSAGE_03] [nvarchar](100) NULL,
                        [MESSAGE_04] [nvarchar](100) NULL)

INSERT INTO [dbo].[BS_EXPRESS_MESSAGE] ([MESSAGE_ID] ,[MESSAGE_NUM] ,[MESSAGE_00] ,[MESSAGE_01] ,[MESSAGE_02] ,[MESSAGE_03] ,[MESSAGE_04])
VALUES ('WORKINFO', 0, 'Net indirim için uygulanabilecek en fazla oran','Maximum percentage applicable for Net Discount','','','' )

INSERT INTO [dbo].[BS_EXPRESS_MESSAGE] ([MESSAGE_ID] ,[MESSAGE_NUM] ,[MESSAGE_00] ,[MESSAGE_01] ,[MESSAGE_02] ,[MESSAGE_03] ,[MESSAGE_04])
VALUES ('WORKINFO', 1, 'E-Fatura Kullanılıyor','','','','' )

INSERT INTO [dbo].[BS_EXPRESS_MESSAGE] ([MESSAGE_ID] ,[MESSAGE_NUM] ,[MESSAGE_00] ,[MESSAGE_01] ,[MESSAGE_02] ,[MESSAGE_03] ,[MESSAGE_04])
VALUES ('WORKINFO', 2, 'E-Arşif Kullanılıyor','','','','' )

INSERT INTO [dbo].[BS_EXPRESS_MESSAGE] ([MESSAGE_ID] ,[MESSAGE_NUM] ,[MESSAGE_00] ,[MESSAGE_01] ,[MESSAGE_02] ,[MESSAGE_03] ,[MESSAGE_04])
VALUES ('WORKINFO', 3, 'Miktarlar Toplanacak','','','','' )

INSERT INTO [dbo].[BS_EXPRESS_MESSAGE] ([MESSAGE_ID] ,[MESSAGE_NUM] ,[MESSAGE_00] ,[MESSAGE_01] ,[MESSAGE_02] ,[MESSAGE_03] ,[MESSAGE_04])
VALUES ('WORKINFO', 4, 'Dövizli satışta kur zorunlu','','','','' )

--INSERT INTO [dbo].[BS_EXPRESS_MESSAGE] ([MESSAGE_ID] ,[MESSAGE_NUM] ,[MESSAGE_00] ,[MESSAGE_01] ,[MESSAGE_02] ,[MESSAGE_03] ,[MESSAGE_04])
--VALUES ('WORKINFO', 5, 'Satıcı sadece kendi raporlarını alabilsin','','','','' )

INSERT INTO [dbo].[BS_EXPRESS_MESSAGE] ([MESSAGE_ID] ,[MESSAGE_NUM] ,[MESSAGE_00] ,[MESSAGE_01] ,[MESSAGE_02] ,[MESSAGE_03] ,[MESSAGE_04])
VALUES ('WORKINFO', 6, 'Negatif Stok Kontrol','','','','' )

INSERT INTO [dbo].[BS_EXPRESS_MESSAGE] ([MESSAGE_ID] ,[MESSAGE_NUM] ,[MESSAGE_00] ,[MESSAGE_01] ,[MESSAGE_02] ,[MESSAGE_03] ,[MESSAGE_04])
VALUES ('WORKINFO', 7, 'Cari Prefix','','','','' )


--Çalışma Bilgileri
CREATE TABLE BS_EXPRESS_WORKINFO(
						[ID] [int] IDENTITY(1,1) NOT NULL,
                        [MESSAGE_ID] [nchar](15) NULL,
	                    [MESSAGE_NUM] [smallint] NULL,
                        [COMBOORTEXT] [nvarchar](100) NULL,
						[EXPLAIN] [nvarchar](255) NULL,
                        [WORKVALUE] [nvarchar](100) NULL,
                        [WORKVALUE2] [nvarchar](100) NULL,
                        [WORKVALUE3] [nvarchar](100) NULL)

INSERT INTO [dbo].[BS_EXPRESS_WORKINFO] ([MESSAGE_ID], [MESSAGE_NUM], [COMBOORTEXT] ,[EXPLAIN], [WORKVALUE], [WORKVALUE2], [WORKVALUE3] )
VALUES ('WORKINFO', 0, 'T','Net İndirim Max Oranı','10','','' )

INSERT INTO [dbo].[BS_EXPRESS_WORKINFO] ([MESSAGE_ID], [MESSAGE_NUM], [COMBOORTEXT] ,[EXPLAIN], [WORKVALUE], [WORKVALUE2], [WORKVALUE3] )
VALUES ('WORKINFO', 1, 'C','E-Fatura','HAYIR','','' )

INSERT INTO [dbo].[BS_EXPRESS_WORKINFO] ([MESSAGE_ID], [MESSAGE_NUM], [COMBOORTEXT] ,[EXPLAIN], [WORKVALUE], [WORKVALUE2], [WORKVALUE3] )
VALUES ('WORKINFO', 2, 'C','E-Arşiv','HAYIR','','' )

INSERT INTO [dbo].[BS_EXPRESS_WORKINFO] ([MESSAGE_ID], [MESSAGE_NUM], [COMBOORTEXT] ,[EXPLAIN], [WORKVALUE], [WORKVALUE2], [WORKVALUE3] )
VALUES ('WORKINFO', 3, 'C','Miktarlar Toplanacak','HAYIR','','' )

INSERT INTO [dbo].[BS_EXPRESS_WORKINFO] ([MESSAGE_ID], [MESSAGE_NUM], [COMBOORTEXT] ,[EXPLAIN], [WORKVALUE], [WORKVALUE2], [WORKVALUE3] )
VALUES ('WORKINFO', 4, 'C','Dövizli satışta kur zorunlu','HAYIR','','' )

--INSERT INTO [dbo].[BS_EXPRESS_WORKINFO] ([MESSAGE_ID], [MESSAGE_NUM], [COMBOORTEXT] ,[EXPLAIN], [WORKVALUE], [WORKVALUE2], [WORKVALUE3] )
--VALUES ('WORKINFO', 5, 'C','Satıcı sadece kendi raporlarını alabilsin','HAYIR','','' )

INSERT INTO [dbo].[BS_EXPRESS_WORKINFO] ([MESSAGE_ID], [MESSAGE_NUM], [COMBOORTEXT] ,[EXPLAIN], [WORKVALUE], [WORKVALUE2], [WORKVALUE3] )
VALUES ('WORKINFO', 6, 'C','Negatif Stok Kontrol','HAYIR','','' )

INSERT INTO [dbo].[BS_EXPRESS_WORKINFO] ([MESSAGE_ID], [MESSAGE_NUM], [COMBOORTEXT] ,[EXPLAIN], [WORKVALUE], [WORKVALUE2], [WORKVALUE3] )
VALUES ('WORKINFO', 7, 'T','Cari Prefix','','','' )

--Restaurant için
CREATE TABLE [dbo].[BS_EXPRESS_SALES](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[STOCKREF] [int] NOT NULL,
	[LINETYPE] [smallint] NOT NULL,
	[SALESMANREF] [int] NOT NULL,
	[AMOUNT] [float] NOT NULL,
	[PRICE] [float] NOT NULL,
	[TOTAL] [float] NOT NULL,
	[UOMREF] [int] NOT NULL,
	[USREF] [int] NOT NULL,
	[UINFO1] [float] NOT NULL,
	[UINFO2] [float] NOT NULL,
	[VATINC] [smallint] NOT NULL,
	[VAT] [float] NOT NULL,
	[VATAMNT] [float] NOT NULL,
	[VATMATRAH] [float] NOT NULL,
	[LINEEXP] [varchar](81) NULL,
	[PRINTEDQUANTITY] [float] NOT  NULL,
	[TERMNR] [int] NOT NULL,
	[DESKREF] [int] NOT NULL,
	[SCORE] [float] NOT NULL,
	[CLIENTCOUNT] [int] NOT NULL,
	[TRACKTYPE] [smallint] NOT NULL,
	[DISTCOST] [float] NOT NULL,
	[DISCPER] [float] NOT NULL,
	[GLOBTRANS] [smallint] NOT NULL,
	[CALCTYPE] [smallint] NOT NULL,
	[LINENET] [float] NOT NULL,
	[PARENTLNREF] [int] NOT NULL,
	[NETDISCFLAG] [smallint] NOT NULL,
	[NETDISCAMNT] [float] NOT NULL,
	[CANCELLED] [smallint] NOT NULL,
	[PRPRICE] [float] NOT NULL
) 

--silinen satırların tutulduğu tablo
CREATE TABLE [dbo].[BS_EXPRESS_DELETEDSALES](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[DATE_] [Datetime] NOT NULL,
	[STOCKREF] [int] NOT NULL,
	[LINETYPE] [smallint] NOT NULL,
	[SALESMANREF] [int] NOT NULL,
	[AMOUNT] [float] NOT NULL,
	[PRICE] [float] NOT NULL,
	[TOTAL] [float] NOT NULL,
	[UOMREF] [int] NOT NULL,
	[USREF] [int] NOT NULL,
	[UINFO1] [float] NOT NULL,
	[UINFO2] [float] NOT NULL,
	[VATINC] [smallint] NOT NULL,
	[VAT] [float] NOT NULL,
	[VATAMNT] [float] NOT NULL,
	[VATMATRAH] [float] NOT NULL,
	[LINEEXP] [varchar](81) NULL,
	[PRINTEDQUANTITY] [float] NOT  NULL,
	[TERMNR] [int] NOT NULL,
	[DESKREF] [int] NOT NULL,
	[SCORE] [float] NOT NULL,
	[CLIENTCOUNT] [int] NOT NULL,
	[TRACKTYPE] [smallint] NOT NULL,
	[DISTCOST] [float] NOT NULL,
	[DISCPER] [float] NOT NULL,
	[GLOBTRANS] [smallint] NOT NULL,
	[CALCTYPE] [smallint] NOT NULL,
	[LINENET] [float] NOT NULL,
	[PARENTLNREF] [int] NOT NULL,
	[NETDISCFLAG] [smallint] NOT NULL,
	[NETDISCAMNT] [float] NOT NULL,
	[CANCELLED] [smallint] NOT NULL,
	[PRPRICE] [float] NOT NULL
) 
