SqlConnection conn = new SqlConnection(BMS_DLL.SQL.sqlConnectionSource.ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT TOP 1 * FROM BM_PDKS_PARAMETRELER WHERE TUR='CALISMASAATI'", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow dr in dt.Rows) {
SE_NS.EditValue = double.Parse( dr["NS"].ToString());
SE_HS.EditValue = double.Parse(dr["HS"].ToString());
}
Category: Sql
LOGO ERP SQL HAREKET GÖRMÜŞ MALZEMENİN BİRİMİNİ ÇEVİRME HAREKETLER DAHIL
/*MALZEME */SELECT LOGICALREF FROM dbo.LG_211_ITEMS WITH(NOLOCK) WHERE CODE='M-4299-04-CL-SP' /*MALZEMENIN LOGICALREFINI BULMAK ICIN=1367*/
/*BIRIM*/ SELECT LOGICALREF,UNITSETREF,CODE,NAME FROM LG_211_UNITSETL WITH(NOLOCK) WHERE MAINUNIT=1 AND NAME='ADET' /*HANGI MALZEME BIRIMI OLACAK LOGICALREF=55 UNITSETREF=6*/
/*GUNCELLEME ISLEMI*/
update LG_211_ITEMS set UNITSETREF = 6 /*BIRIMIN UNITSETREFI*/ where LOGICALREF = 1367 /*MALZEMENIN LOGICALREFI*/
update LG_211_ITMUNITA set UNITLINEREF = 55 /*BIRIMIN LOGICALREFI*/ where ITEMREF = 1367 /*MALZEMENIN LOGICALREFI*/
/*RISKLI:GERIYE DONUK HAREKETLERI GUNCELLEMEK ICIN (TALEP,SIPARIS VE IRSALIYE)*/
update LG_211_01_STLINE set UOMREF = 55 /*BIRIMIN LOGICALREFI*/ , USREF = 6 /*BIRIMIN UNITSETREFI*/ where Stockref = 1367 /*MALZEMENIN LOGICALREFI*/
update LG_211_01_ORFLINE set UOMREF = 55 /*BIRIMIN LOGICALREFI*/ , USREF = 6 /*BIRIMIN UNITSETREFI*/ where Stockref = 1367 /*MALZEMENIN LOGICALREFI*/
update LG_211_01_DEMANDLINE set UOMREF = 55 /*BIRIMIN LOGICALREFI*/ , USREF = 6 /*BIRIMIN UNITSETREFI*/ where Stockref = 1367 /*MALZEMENIN LOGICALREFI*/
LOGO MOBILESALES 262 VERSIYON GECISI YAPMADAN KURMAK VE VERSION GECISLI KURULUM
VERSION GECISLI KURULUM ICIN BILGISAYARDA BULUNAN VERSIONDAN SONRAKI BUTUN VERSIONLAR FTPDEN INDIRILIR SONRA BIR SONRAKI VERSION LOGO KLASORUNU ATILIR LBSLOADI VARSA ODA ATILIR VE LOGO CALISTIRILIR MOBILESALES GENEL TANIMLARA GIRILIR VERSION GECISI YAPILSIN EKRANI ACILIR BASLAT DENILIR. SONRA LOGO KAPATILIR VE BIR SONRAKI VERSIONDAN AYNI SEKILDE DEVAM EDILIR SON VERSIONA KADAR.
ILK KURULUM : KURMA ISLEMINDEN ONCE LOGO VERITABANINDA ASAGIDAKI SORGULAR CALISTIRILIR
USE [VERITABANIADI]
GO
/****** Object: Table [dbo].[WOR_ANDDEVICE] Script Date: 14.02.2020 13:02:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CABIN](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CODE] [nvarchar](50) NOT NULL,
[TYPE] [int] NOT NULL,
[BRAND] [nvarchar](50) NULL,
[MODEL] [nvarchar](50) NULL,
[BARCODE] [nvarchar](70) NOT NULL,
[LOCINFO] [int] NOT NULL,
[STATUS] [int] NOT NULL,
[CLIENTCODE] [nvarchar](50) NULL,
[SALESMANREF] [int] NULL,
[MODIFIEDDATE] [datetime] NULL,
[CREATEDDATE] [datetime] NOT NULL,
[FIRM] [nvarchar](30) NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
---------------------------------------
GO
/****** Object: Table [dbo].[WOR_CABINTRANS] Script Date: 24.10.2019 14:18:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CABINTRANS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CABINID] [int] NOT NULL,
[TRTYPE] [int] NOT NULL,
[TRFICHENO] [nvarchar](50) NULL,
[TRFICHEREF] [int] NULL,
[CLIENTCODE] [nvarchar](50) NULL,
[CLIENTREF] [int] NULL,
[DATE] [datetime] NULL,
[SALESMANREF] [int] NULL,
[TRCODE] [int] NULL,
[FIRM] [nvarchar](30) NULL,
[PERIOD] [nvarchar](30) NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
------------------------------------------------
GO
/****** Object: Table [dbo].[WOR_CABINTYPE] Script Date: 24.10.2019 14:18:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CABINTYPE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CABINTYPE] [nvarchar](30) NOT NULL,
[ITEMGROUP1] [nvarchar](30) NULL,
[ITEMGROUP2] [nvarchar](30) NULL,
[ITEMGROUP3] [nvarchar](30) NULL,
[ITEMGROUP4] [nvarchar](30) NULL,
[ITEMGROUP5] [nvarchar](30) NULL,
[CREATEDDATE] [datetime] NOT NULL,
[STATUS] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ANDDEVICE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[DEVICESERINO1] [nvarchar](50) NOT NULL,
[DEVICESERINO2] [nvarchar](50) NOT NULL,
[DEVICESERINO3] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_WOR_ANDDEVICE] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_ANDTRANSLOG] Script Date: 14.02.2020 13:02:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ANDTRANSLOG](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
[DATASTR] [ntext] NOT NULL,
[ANDFICHENO] [varchar](50) NOT NULL,
[FICHENO] [varchar](50) NOT NULL,
[FICHETYPE] [int] NOT NULL,
CONSTRAINT [PK_WOR_ANDTRANSLOG] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CASE] Script Date: 14.02.2020 13:02:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CASE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CTYPEID] [int] NOT NULL,
[CUSTOMERID] [int] NOT NULL,
[SERINO] [nvarchar](50) NOT NULL,
[SHIPREF] [int] NOT NULL,
[STATUS] [int] NOT NULL,
[WAREHOUSE] [int] NOT NULL,
[USERID] [int] NOT NULL,
[TEDKABULDATE] [datetime] NOT NULL,
[TEDIADEDATE] [datetime] NOT NULL,
[MUSCIKISDATE] [datetime] NOT NULL,
[MUSIADEDATE] [datetime] NOT NULL,
[KAYIPDATE] [datetime] NOT NULL,
[LASTREADDATE] [datetime] NOT NULL,
[SPECID] [int] NOT NULL,
[MODEL] [varchar](50) NOT NULL,
[REASONID] [int] NOT NULL,
[PRODUCERSERINO] [varchar](50) NOT NULL,
CONSTRAINT [PK_WOR_CASE_1] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CASELOG] Script Date: 14.02.2020 13:02:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CASELOG](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
[SERINO] [nvarchar](50) NOT NULL,
[FCUSTOMERID] [int] NOT NULL,
[SCUSTOMERID] [int] NOT NULL,
[DESC_] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_WOR_CASELOG] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CASEREASON] Script Date: 14.02.2020 13:02:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CASEREASON](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CODE] [nvarchar](50) NOT NULL,
[DESC_] [nvarchar](200) NOT NULL,
CONSTRAINT [PK_WOR_CASEREASONS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CASESPEC] Script Date: 14.02.2020 13:02:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CASESPEC](
[ID] [int] IDENTITY(1,1) NOT NULL,
[SPEC] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_WOR_CASESPEC] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CASETYPE] Script Date: 14.02.2020 13:02:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CASETYPE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ITEMID] [int] NOT NULL,
[CODE] [nvarchar](50) NOT NULL,
[NAME] [nvarchar](100) NOT NULL,
[SPECODE] [nvarchar](50) NOT NULL,
[MARK] [nvarchar](50) NOT NULL,
[MODEL] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_WOR_CASE] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CLCARDINFO] Script Date: 14.02.2020 13:02:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CLCARDINFO](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CLIENTREF] [int] NOT NULL,
[CLCODE] [nvarchar](100) NOT NULL,
[CLNAME] [nvarchar](100) NOT NULL,
[PHOTO] [image] NOT NULL,
CONSTRAINT [PK_WOR_CLCARDINFO] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_COLORS] Script Date: 14.02.2020 13:02:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_COLORS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CTYPE] [int] NOT NULL,
[COLOR] [nvarchar](50) NOT NULL,
[DESC_] [nvarchar](100) NOT NULL,
CONSTRAINT [PK_WOR_COLORS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CUSTGPSDATA] Script Date: 14.02.2020 13:02:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CUSTGPSDATA](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CLIENTCODE] [nvarchar](50) NOT NULL,
[USERID] [int] NOT NULL,
[LATITUDE] [nvarchar](50) NOT NULL,
[LONGITUDE] [nvarchar](50) NOT NULL,
[HDOP] [nvarchar](50) NOT NULL,
[SHIPADDRCODE] [varchar](50) NOT NULL,
[DATE_] [datetime] NOT NULL,
[SHIPADDRID] [int] NOT NULL,
CONSTRAINT [PK_WOR_CUSTGPSDATA] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CUSTGPSLOC] Script Date: 14.02.2020 13:02:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CUSTGPSLOC](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CLIENTREF] [int] NOT NULL,
[LATITUDE] [nvarchar](100) NOT NULL,
[LONGTITUDE] [nvarchar](100) NOT NULL,
[CLCODE] [varchar](100) NOT NULL,
[CLNAME] [varchar](100) NOT NULL,
CONSTRAINT [PK_WOR_CUSTOMERGPSLOCATION] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_DEFORDER] Script Date: 14.02.2020 13:02:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_DEFORDER](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[LINENO_] [int] NOT NULL,
[DEFINITION_] [nvarchar](30) NOT NULL,
[SPECODE] [nvarchar](11) NOT NULL,
[GROUPCODE] [nvarchar](750) NOT NULL,
[SLSMANREF] [int] NOT NULL,
[ISSHOWSTOC] [int] NOT NULL,
[WHOUSE] [int] NOT NULL,
[STYPE] [int] NOT NULL,
[TYPE] [int] NOT NULL,
[WRKTYPE] [int] NOT NULL,
[FORMGROUP] [nvarchar](50) NOT NULL,
[USEPENETRATION] [int] NOT NULL,
[PTYPE] [int] NOT NULL,
[ENTPRICE] [int] NOT NULL,
[PRODUCTCLASSREF] [int] NOT NULL,
[MINSTOCK] [varchar](50) NOT NULL,
[USEMINSTOCK] [int] NOT NULL,
[FIRMNR] [varchar](50) NOT NULL,
[DONEMNR] [varchar](50) NOT NULL,
[CREATEDDATE] [datetime] NULL,
[MODIFIEDDATE] [datetime] NULL,
[INNERSQL] [nvarchar](max) NOT NULL,
CONSTRAINT [PK_WOR_DEFORDER] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_DEFORDERDETAIL] Script Date: 14.02.2020 13:02:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_DEFORDERDETAIL](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[DEFORDERID] [int] NOT NULL,
[GROUP_] [nvarchar](20) NOT NULL,
[PRODUCTID] [int] NOT NULL,
[PCODE] [nvarchar](25) NOT NULL,
[MCODE] [nvarchar](50) NOT NULL,
[PNAME] [nvarchar](51) NOT NULL,
[MINAMOUNT] [nvarchar](53) NOT NULL,
[MAXAMOUNT] [nvarchar](53) NOT NULL,
[ISSLCTUNIT] [int] NOT NULL,
[UNIT] [int] NOT NULL,
[ISSHOWSTOCK] [int] NOT NULL,
[LINENO_] [int] NOT NULL,
[COLORID] [int] NOT NULL,
[UNITREF] [int] NOT NULL,
[LINETYPE] [int] NOT NULL,
CONSTRAINT [PK_DEFORDERDETAIL] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_DELETEDRECS] Script Date: 14.02.2020 13:02:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_DELETEDRECS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FIRMNR] [smallint] NOT NULL,
[PERIODNR] [smallint] NOT NULL,
[RECTYPE] [smallint] NOT NULL,
[LOGICALREF] [int] NOT NULL,
[DELETEDDATE] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_DESIGNS] Script Date: 14.02.2020 13:02:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_DESIGNS](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[FILENAME] [nvarchar](50) NOT NULL,
[TYPE] [int] NOT NULL,
[SECTORTYPE] [int] NOT NULL,
[SECTORNR] [int] NOT NULL,
[VALUE] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_WOR_DESIGNS] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_DESIGNSETTINGS] Script Date: 14.02.2020 13:02:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_DESIGNSETTINGS](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[TYPE] [int] NOT NULL,
[FILENAME] [nvarchar](50) NOT NULL,
[STARTY] [int] NOT NULL,
[DETAILCOUNT] [int] NOT NULL,
[TITLEHEIGHT] [int] NOT NULL,
[DETAILHEIGHT] [int] NOT NULL,
[PAGEENDHEIGHT] [int] NOT NULL,
[PRINTINGENDHEIGHT] [int] NOT NULL,
CONSTRAINT [PK_WOR_DESIGNSETTINGS] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_EMAILFORMS] Script Date: 14.02.2020 13:02:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_EMAILFORMS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FORMNAME] [nvarchar](100) NOT NULL,
[FORMTYPE] [int] NOT NULL,
[FORMCONTENT] [nvarchar](max) NOT NULL,
[FORMCONFIG] [nvarchar](max) NULL,
CONSTRAINT [PK_WOR_EMAILFORMS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_GPSDATA] Script Date: 14.02.2020 13:02:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_GPSDATA](
[GPSDATAID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
[LATITUDE] [nvarchar](30) NOT NULL,
[LONGTITUDE] [nvarchar](30) NOT NULL,
[SPEED] [float] NOT NULL,
[DISTANCE] [float] NOT NULL,
[TIMESPAN] [float] NOT NULL,
CONSTRAINT [PK_WOR_GPSDATA] PRIMARY KEY CLUSTERED
(
[GPSDATAID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_MARKETINGMESSAGE] Script Date: 14.02.2020 13:02:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_MARKETINGMESSAGE](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[DEFINITION_] [nvarchar](50) NOT NULL,
[BEGDATE] [datetime] NOT NULL,
[ENDDATE] [datetime] NOT NULL,
[GROUPCODE] [nvarchar](750) NOT NULL,
[TYPE] [int] NOT NULL,
[NOTE] [ntext] NOT NULL,
CONSTRAINT [PK_WOR_MARKETINGMESSAGE] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_MESSAGE] Script Date: 14.02.2020 13:02:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_MESSAGE](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[SENDER] [int] NOT NULL,
[RECIPIENT] [int] NOT NULL,
[NOTE] [nvarchar](501) NOT NULL,
[ISREAD] [int] NOT NULL,
[TYPE] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
CONSTRAINT [PK_WOR_MESSAGE] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PARAMETER] Script Date: 14.02.2020 13:02:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PARAMETER](
[Id] [int] NOT NULL,
[No] [nvarchar](1024) NOT NULL,
[Name] [nvarchar](1024) NOT NULL,
[CategoryId] [int] NOT NULL,
[CategoryName] [nvarchar](1024) NOT NULL,
CONSTRAINT [PK_WOR_PARAMETER] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PARAMROLE] Script Date: 14.02.2020 13:02:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PARAMROLE](
[RoleId] [int] NOT NULL,
[ParameterId] [int] NOT NULL,
[Value] [nvarchar](max) NULL,
CONSTRAINT [PK_WOR_PARAMROLE] PRIMARY KEY CLUSTERED
(
[RoleId] ASC,
[ParameterId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PARAMUSER] Script Date: 14.02.2020 13:02:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PARAMUSER](
[UserId] [int] NOT NULL,
[ParameterId] [int] NOT NULL,
[Value] [nvarchar](max) NULL,
[IsModified] [int] NOT NULL,
CONSTRAINT [PK_WOR_PARAMUSER] PRIMARY KEY CLUSTERED
(
[UserId] ASC,
[ParameterId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PENETRATION] Script Date: 14.02.2020 13:02:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PENETRATION](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[LINENO_] [int] NOT NULL,
[DEFINITION_] [nvarchar](30) NOT NULL,
[GROUPCODE] [nvarchar](750) NOT NULL,
[STYPE] [int] NOT NULL,
[PNTGROUP] [nvarchar](50) NOT NULL,
[PTYPE] [int] NOT NULL,
[ENTPRICE] [int] NOT NULL,
[COLRIGHT] [varchar](100) NOT NULL,
[DEFFIELD1] [varchar](100) NOT NULL,
[DEFFIELD2] [varchar](100) NOT NULL,
[DEFFIELD3] [varchar](100) NOT NULL,
[DEFFIELD4] [varchar](100) NOT NULL,
[DEFFIELD5] [varchar](100) NOT NULL,
[DEFFIELD6] [varchar](100) NOT NULL,
[DEFFIELD7] [varchar](100) NOT NULL,
[DEFFIELD8] [varchar](100) NOT NULL,
[DEFFIELD9] [varchar](100) NOT NULL,
[DEFFIELD10] [varchar](100) NOT NULL,
CONSTRAINT [PK_WOR_PENETRATION] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PENETRATIONDETAIL] Script Date: 14.02.2020 13:02:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PENETRATIONDETAIL](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[PNTID] [int] NOT NULL,
[PRTYPE] [nvarchar](50) NOT NULL,
[PRODUCTID] [int] NOT NULL,
[PCODE] [nvarchar](25) NOT NULL,
[PNAME] [nvarchar](51) NOT NULL,
[BARCODE] [nvarchar](30) NOT NULL,
[UNIT] [nvarchar](30) NOT NULL,
[LINENO_] [int] NOT NULL,
[PRTYPEINT] [int] NOT NULL,
CONSTRAINT [PK_WOR_PENETRATIONDETAIL] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PRINTDESIGNER] Script Date: 14.02.2020 13:02:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PRINTDESIGNER](
[ID] [int] IDENTITY(1,1) NOT NULL,
[NAME] [nvarchar](50) NULL,
[DESIGN] [nvarchar](max) NULL,
[REPORTTYPE] [nvarchar](50) NULL,
[FORMCONFIG] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PROCESS] Script Date: 14.02.2020 13:02:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PROCESS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DATE_] [datetime] NOT NULL,
[USERID] [int] NOT NULL,
[CLIENTREF] [int] NOT NULL,
[PTYPE] [int] NOT NULL,
[PREF] [int] NOT NULL,
[PDISTANCE] [float] NOT NULL,
[VREASON] [nvarchar](50) NOT NULL,
[VNOTE] [ntext] NOT NULL,
[ISPRINT] [int] NOT NULL,
[CLCODE] [varchar](60) NOT NULL,
[CLNAME] [varchar](120) NOT NULL,
[SHIPINFOREF] [int] NOT NULL,
[ENLEM] [varchar](50) NOT NULL,
[BOYLAM] [varchar](50) NOT NULL,
[FIRM] [int] NULL,
[USERTITLE] [int] NULL,
[VISITIMAGE] [varbinary](max) NULL,
[NTSSFICHENO] [varchar](max) NULL,
CONSTRAINT [PK_WOR_PROCESS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PROGMENU] Script Date: 14.02.2020 13:02:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PROGMENU](
[progmenuid] [int] IDENTITY(1,1) NOT NULL,
[mainmenu] [nvarchar](500) NULL,
[submenu1] [nvarchar](500) NULL,
[submenu2] [nvarchar](500) NULL,
[submenu3] [nvarchar](500) NULL,
[submenu4] [nvarchar](500) NULL,
[submenu5] [nvarchar](500) NULL,
[fno] [nvarchar](500) NULL,
[parentfno] [nvarchar](500) NULL,
[lineno_] [int] NULL,
[level_] [int] NULL,
[visible] [int] NULL,
[lang] [int] NULL,
[picturename] [nvarchar](500) NULL,
[url] [nvarchar](500) NULL,
[modul] [nvarchar](500) NULL,
CONSTRAINT [PK_WOR_PROGMENU] PRIMARY KEY CLUSTERED
(
[progmenuid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_QUOTA] Script Date: 14.02.2020 13:02:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_QUOTA](
[QUOTAID] [int] IDENTITY(1,1) NOT NULL,
[CODE] [nvarchar](50) NOT NULL,
[DESC_] [nvarchar](200) NOT NULL,
[GROUPCODE] [nvarchar](750) NOT NULL,
[BEGDATE] [datetime] NOT NULL,
[ENDDATE] [datetime] NOT NULL,
[AMOUNT] [float] NOT NULL,
[PTYPE] [int] NOT NULL,
[ALERTTYPE] [int] NOT NULL,
CONSTRAINT [PK_WOR_QUOTA] PRIMARY KEY CLUSTERED
(
[QUOTAID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_QUOTADETAIL] Script Date: 14.02.2020 13:02:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_QUOTADETAIL](
[ID] [int] IDENTITY(1,1) NOT NULL,
[QUOTAID] [int] NOT NULL,
[CODE] [varchar](50) NOT NULL,
CONSTRAINT [PK_WOR_QUOTADETAIL] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_REPORTS] Script Date: 14.02.2020 13:02:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_REPORTS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[REPINDEX] [int] NOT NULL,
[REPORTNAME] [nvarchar](50) NOT NULL,
[REPORTPATH] [nvarchar](500) NOT NULL,
[RTYPE] [int] NOT NULL,
[REPORTCONTENT] [varchar](max) NOT NULL,
CONSTRAINT [PK_WOR_REPORTS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_ROUTE] Script Date: 14.02.2020 13:02:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ROUTE](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[ROUTECODE] [nvarchar](20) NULL,
[ROUTEDEFINITION] [nvarchar](50) NULL,
[USERID] [int] NULL,
[CREATEDDATE] [date] NULL,
[PERIODSTARTDATE] [date] NULL,
PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_ROUTEDAY] Script Date: 14.02.2020 13:03:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ROUTEDAY](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[ROUTEID] [int] NULL,
[DAY] [int] NULL,
PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_ROUTEPLAN] Script Date: 14.02.2020 13:03:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ROUTEPLAN](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[ROUTEID] [int] NULL,
[CLIENTREF] [nvarchar](50) NULL,
[SHIPMENTREF] [nvarchar](50) NULL,
[SEQUENCE] [int] NULL,
PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_ROUTEPROCESS] Script Date: 14.02.2020 13:03:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ROUTEPROCESS](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[USERCUSTOMERID] [int] NULL,
[ROUTEPLANID] [int] NULL,
[ROUTEDAYID] [int] NULL,
[CREATEDDATE] [date] NULL,
[PROCESSREF] [nvarchar](50) NULL,
[FICHENO] [nvarchar](50) NULL,
[PROCESSTYPE] [int] NULL,
[CLIENTREF] [nvarchar](50) NULL,
[FIRM] [nvarchar](10) NULL,
[PSEQUENCE] [int] NULL,
[SEQUENCE] [int] NULL,
[USERID] [int] NULL,
[PROCESSDATE] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SERIAL] Script Date: 14.02.2020 13:03:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SERIAL](
[WDATA] [nvarchar](4000) NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SETTINGS] Script Date: 14.02.2020 13:03:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SETTINGS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PNAME] [nvarchar](50) NOT NULL,
[PVALUE] [nvarchar](1000) NOT NULL,
CONSTRAINT [PK_WOR_SETTINGS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEY] Script Date: 14.02.2020 13:03:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEY](
[SURVEYID] [int] IDENTITY(1,1) NOT NULL,
[SDATE] [datetime] NOT NULL,
[DESC_] [nvarchar](100) NOT NULL,
[STATUS] [int] NOT NULL,
[FIELD1] [nvarchar](50) NULL,
[FIELD2] [nvarchar](50) NULL,
[FIELD3] [nvarchar](50) NULL,
[FIELD4] [nvarchar](50) NULL,
[FIELD5] [nvarchar](50) NULL,
[FIELD6] [nvarchar](50) NULL,
[FIELD7] [nvarchar](50) NULL,
[FIELD8] [nvarchar](50) NULL,
[FIELD9] [nvarchar](50) NULL,
[FIELD10] [nvarchar](50) NULL,
[USECASE] [int] NOT NULL,
[MUSTDO] [int] NOT NULL,
[PERIOD] [int] NOT NULL,
CONSTRAINT [PK_WOR_SURVEY] PRIMARY KEY CLUSTERED
(
[SURVEYID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEYADETAIL] Script Date: 14.02.2020 13:03:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEYADETAIL](
[SADETAILID] [int] IDENTITY(1,1) NOT NULL,
[SURVEYID] [int] NOT NULL,
[SQDETAILID] [int] NOT NULL,
[ANSWER] [nvarchar](100) NOT NULL,
[POINT] [int] NOT NULL,
CONSTRAINT [PK_WOR_SURVEYADETAIL] PRIMARY KEY CLUSTERED
(
[SADETAILID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEYANSWERNEW] Script Date: 14.02.2020 13:03:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEYANSWERNEW](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[SID] [int] NULL,
[QID] [int] NULL,
[SUBJECT] [nvarchar](250) NULL,
CONSTRAINT [PK_WOR_SURVEYANSWERNEW] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEYNEW] Script Date: 14.02.2020 13:03:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEYNEW](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[BEGDATE] [datetime] NULL,
[ENDDATE] [datetime] NULL,
[STATUS] [int] NULL,
[SUBJECT] [nvarchar](250) NULL,
[CHOICEPROD] [int] NULL,
[ENTERPRODAMOUNT] [int] NULL,
[DEFPRODAMOUNT] [float] NULL,
CONSTRAINT [PK_WOR_SURVEYNEW] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEYQDETAIL] Script Date: 14.02.2020 13:03:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEYQDETAIL](
[SQDETAILID] [int] IDENTITY(1,1) NOT NULL,
[SURVEYID] [int] NOT NULL,
[QTYPE] [int] NOT NULL,
[QUESTION] [nvarchar](150) NOT NULL,
CONSTRAINT [PK_WOR_SURVEYDATIL] PRIMARY KEY CLUSTERED
(
[SQDETAILID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEYQUESTIONSNEW] Script Date: 14.02.2020 13:03:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEYQUESTIONSNEW](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[SID] [int] NULL,
[SUBJECT] [nvarchar](250) NULL,
[TYPE] [int] NULL,
[DTYPE] [int] NULL,
[DEFVAL] [nvarchar](250) NULL,
[ISMUST] [int] NULL,
CONSTRAINT [PK_WOR_SURVEYQUESTIONSNEW] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_TODO] Script Date: 14.02.2020 13:03:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_TODO](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[TODOUSERID] [int] NOT NULL,
[DESC_] [nvarchar](50) NOT NULL,
[BEGDATE] [datetime] NOT NULL,
[ENDDATE] [datetime] NOT NULL,
[PRIORITY] [int] NOT NULL,
[SENDEMAIL] [int] NOT NULL,
[EMAILADDR] [nvarchar](50) NOT NULL,
[NOTE] [ntext] NOT NULL,
[USERID] [int] NOT NULL,
[CUSTOMERID] [int] NOT NULL,
[USERNOTE] [nvarchar](500) NOT NULL,
[STATUS] [int] NOT NULL,
[DEFINITIONTIME] [datetime] NOT NULL,
[READTIME] [datetime] NOT NULL,
[COMPLATETIME] [datetime] NOT NULL,
[SALESMUST] [int] NOT NULL,
CONSTRAINT [PK_WOR_TODO] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_TRANSFERDATA] Script Date: 14.02.2020 13:03:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_TRANSFERDATA](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[SESSIONID] [nvarchar](100) NOT NULL,
[DATE_] [datetime] NOT NULL,
[DATASTR] [ntext] NOT NULL,
CONSTRAINT [PK_WOR_TRANSFERDATA] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_UNITSET] Script Date: 14.02.2020 13:03:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_UNITSET](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UNITSETREF] [int] NOT NULL,
[UNITREF] [int] NOT NULL,
[UNITCODE] [nvarchar](50) NOT NULL,
[CHOICEUNIT] [int] NOT NULL,
[CONVERTUNIT] [int] NOT NULL,
[RATIO] [float] NOT NULL,
[MAINUNIT] [int] NOT NULL,
CONSTRAINT [PK_WOR_UNITSET] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERANSWER] Script Date: 14.02.2020 13:03:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERANSWER](
[USERANSWID] [int] IDENTITY(1,1) NOT NULL,
[SLSCODE] [nvarchar](50) NOT NULL,
[SURVEYID] [int] NOT NULL,
[SQDETAILID] [int] NOT NULL,
[SADETAILID] [int] NOT NULL,
[CLIENTREF] [int] NOT NULL,
[CLIENTCODE] [nvarchar](50) NOT NULL,
[CLIENTNAME] [nvarchar](100) NOT NULL,
[FIELD1] [nvarchar](50) NOT NULL,
[FIELD2] [nvarchar](50) NOT NULL,
[FIELD3] [nvarchar](50) NOT NULL,
[FIELD4] [nvarchar](50) NOT NULL,
[FIELD5] [nvarchar](50) NOT NULL,
[FIELD6] [nvarchar](50) NOT NULL,
[FIELD7] [nvarchar](50) NOT NULL,
[FIELD8] [nvarchar](50) NOT NULL,
[FIELD9] [nvarchar](50) NOT NULL,
[FIELD10] [nvarchar](50) NOT NULL,
[CASEID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
CONSTRAINT [PK_WOR_USERANSWER] PRIMARY KEY CLUSTERED
(
[USERANSWID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERANSWERNEW] Script Date: 14.02.2020 13:03:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERANSWERNEW](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NULL,
[SID] [int] NULL,
[QID] [int] NULL,
[PID] [int] NULL,
[CID] [int] NULL,
[DATE_] [datetime] NULL,
[SUBJECT] [nvarchar](4000) NULL,
[AMOUNT] [float] NULL,
[CLCODE] [nvarchar](250) NULL,
[CLNAME] [nvarchar](250) NULL,
[PCODE] [nvarchar](250) NULL,
[PNAME] [nvarchar](250) NULL,
[UNIQUEVAL] [nvarchar](50) NULL,
CONSTRAINT [PK_WOR_USERANSWERNEW] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERCUSTOMERS] Script Date: 14.02.2020 13:03:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERCUSTOMERS](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NULL,
[CLIENTREF] [nvarchar](50) NULL,
[SHIPMENTREF] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERFIRMS] Script Date: 14.02.2020 13:03:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERFIRMS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[FIRMNR] [nvarchar](10) NOT NULL,
[PERIODNR] [nvarchar](10) NOT NULL,
CONSTRAINT [PK_WOR_FIRMS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERMENU] Script Date: 14.02.2020 13:03:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERMENU](
[usersmenuid] [int] IDENTITY(1,1) NOT NULL,
[usersid] [int] NULL,
[level_] [int] NULL,
[fno] [nvarchar](500) NULL,
[parentfno] [nvarchar](500) NULL,
[visible] [int] NULL,
CONSTRAINT [PK_WOR_USERMENU] PRIMARY KEY CLUSTERED
(
[usersmenuid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERORDERS] Script Date: 14.02.2020 13:03:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERORDERS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ORFICHEREF] [int] NOT NULL,
[SALESMANREF] [int] NOT NULL,
CONSTRAINT [PK_WOR_USERORDERS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERPENETRATION] Script Date: 14.02.2020 13:03:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERPENETRATION](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PNTID] [int] NOT NULL,
[PNTDETAILID] [int] NOT NULL,
[USERID] [int] NOT NULL,
[CLIENTID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
[VY] [int] NOT NULL,
[AMOUNT] [float] NOT NULL,
[PRICE] [float] NOT NULL,
[CURRENCY] [nvarchar](10) NOT NULL,
[SOURCETYPE] [int] NOT NULL,
[DEFFIELD1] [varchar](100) NOT NULL,
[DEFFIELD2] [varchar](100) NOT NULL,
[DEFFIELD3] [varchar](100) NOT NULL,
[DEFFIELD4] [varchar](100) NOT NULL,
[DEFFIELD5] [varchar](100) NOT NULL,
[DEFFIELD6] [varchar](100) NOT NULL,
[DEFFIELD7] [varchar](100) NOT NULL,
[DEFFIELD8] [varchar](100) NOT NULL,
[DEFFIELD9] [varchar](100) NOT NULL,
[DEFFIELD10] [varchar](100) NOT NULL,
[PIMAGE] [varbinary](max) NULL,
CONSTRAINT [PK_WOR_USERPENETRATION] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERQUOTA] Script Date: 14.02.2020 13:03:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERQUOTA](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[QUOTAID] [int] NOT NULL,
[AMOUNT] [float] NOT NULL,
CONSTRAINT [PK_WOR_USERQUOTA] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERROLE] Script Date: 14.02.2020 13:03:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERROLE](
[USERROLEID] [int] IDENTITY(1,1) NOT NULL,
[DESC_] [nvarchar](50) NULL,
CONSTRAINT [PK_WOR_USERROLE] PRIMARY KEY CLUSTERED
(
[USERROLEID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERROLERIGHT] Script Date: 14.02.2020 13:03:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERROLERIGHT](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERROLEID] [int] NOT NULL,
[PARAMNO] [nvarchar](50) NOT NULL,
[PARAMVALUE] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_WOR_USERROLERIGHT] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERS] Script Date: 14.02.2020 13:03:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERS](
[USERID] [int] IDENTITY(1,1) NOT NULL,
[USERNAME] [nvarchar](50) NOT NULL,
[PASSWORD] [nvarchar](50) NOT NULL,
[TYPE] [int] NOT NULL,
[CODE] [nvarchar](50) NOT NULL,
[NAME] [nvarchar](50) NOT NULL,
[GROUPCODE] [nvarchar](50) NOT NULL,
[FNAME] [nvarchar](50) NOT NULL,
[LNAME] [nvarchar](50) NOT NULL,
[EMAIL] [nvarchar](50) NOT NULL,
[WEB] [nvarchar](50) NOT NULL,
[SPECODE] [nvarchar](50) NOT NULL,
[ADMIN] [int] NOT NULL,
[LOGOVALUES] [nvarchar](50) NOT NULL,
[DOSHIP] [int] NOT NULL,
[LOGOUSER] [varchar](50) NOT NULL,
[LOGOPWD] [varchar](50) NOT NULL,
[WINUSERNAME] [varchar](50) NOT NULL,
[APPTYPE] [int] NOT NULL,
[USERROLEID] [int] NOT NULL,
[DISTVEHICLE] [nvarchar](50) NULL,
CONSTRAINT [PK_WOR_USERS] PRIMARY KEY CLUSTERED
(
[USERID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERSRIGHT] Script Date: 14.02.2020 13:03:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERSRIGHT](
[USERRIGHTID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[PARAMNO] [nvarchar](50) NOT NULL,
[PARAMVALUE] [nvarchar](4000) NULL,
CONSTRAINT [PK_WOR_USERRIGHT] PRIMARY KEY CLUSTERED
(
[USERRIGHTID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERSTARTINFO] Script Date: 14.02.2020 13:03:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERSTARTINFO](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
[PLAKA] [nvarchar](50) NOT NULL,
[STARTKM] [nvarchar](50) NOT NULL,
[ENDKM] [nvarchar](50) NOT NULL,
[NOTE] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_WOR_USERSTARTINFO] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_VERSION] Script Date: 14.02.2020 13:03:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_VERSION](
[MAJOR] [nvarchar](50) NOT NULL,
[MINOR] [nvarchar](50) NOT NULL,
[BUILD] [nvarchar](50) NOT NULL,
[REVISION] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_VISITINFO] Script Date: 14.02.2020 13:03:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_VISITINFO](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DESC_] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_WOR_VISITINFO] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WOR_ANDDEVICE] ADD CONSTRAINT [DF_WOR_ANDDEVICE_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_ANDDEVICE] ADD CONSTRAINT [DF_WOR_ANDDEVICE_DEVICESERINO1] DEFAULT ('') FOR [DEVICESERINO1]
GO
ALTER TABLE [dbo].[WOR_ANDDEVICE] ADD CONSTRAINT [DF_WOR_ANDDEVICE_DEVICESERINO2] DEFAULT ('') FOR [DEVICESERINO2]
GO
ALTER TABLE [dbo].[WOR_ANDDEVICE] ADD CONSTRAINT [DF_WOR_ANDDEVICE_DEVICESERINO3] DEFAULT ('') FOR [DEVICESERINO3]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD CONSTRAINT [DF_WOR_ANDTRANSLOG_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD CONSTRAINT [DF_WOR_ANDTRANSLOG_DATE_] DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD CONSTRAINT [DF_WOR_ANDTRANSLOG_DATASTR] DEFAULT ('') FOR [DATASTR]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD DEFAULT ('') FOR [ANDFICHENO]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD DEFAULT ('') FOR [FICHENO]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD DEFAULT ((0)) FOR [FICHETYPE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_CTYPEID] DEFAULT ((0)) FOR [CTYPEID]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_CUSTOMERID] DEFAULT ((0)) FOR [CUSTOMERID]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_SERINO] DEFAULT ('') FOR [SERINO]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_SHIPCODE] DEFAULT ((0)) FOR [SHIPREF]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_STATUS] DEFAULT ((0)) FOR [STATUS]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_WAREHOUSE] DEFAULT ((0)) FOR [WAREHOUSE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_KABULDATE] DEFAULT ('01.01.1900') FOR [TEDKABULDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_TEDIADEDATE] DEFAULT ('01.01.1900') FOR [TEDIADEDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_MUSTERICIKIS] DEFAULT ('01.01.1900') FOR [MUSCIKISDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_MUSIADEDATE] DEFAULT ('01.01.1900') FOR [MUSIADEDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_KAYIPDATE] DEFAULT ('01.01.1900') FOR [KAYIPDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_LASTREADDATE] DEFAULT ('01.01.1900') FOR [LASTREADDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD DEFAULT ((0)) FOR [SPECID]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD DEFAULT ('') FOR [MODEL]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD DEFAULT ((0)) FOR [REASONID]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD DEFAULT ('') FOR [PRODUCERSERINO]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_DATE_] DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_SERINO] DEFAULT ('') FOR [SERINO]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_FCUSTOMERID] DEFAULT ((0)) FOR [FCUSTOMERID]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_SCUSTOMERID] DEFAULT ('') FOR [SCUSTOMERID]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_DESC_] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_CASEREASON] ADD CONSTRAINT [DF_WOR_CASEREASONS_CODE] DEFAULT ('') FOR [CODE]
GO
ALTER TABLE [dbo].[WOR_CASEREASON] ADD CONSTRAINT [DF_WOR_CASEREASONS_DESC_] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_CASESPEC] ADD CONSTRAINT [DF_WOR_CASESPEC_SPEC] DEFAULT ('') FOR [SPEC]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_ITEMID] DEFAULT ((0)) FOR [ITEMID]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_CODE] DEFAULT ('') FOR [CODE]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_NAME] DEFAULT ('') FOR [NAME]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_SPECODE] DEFAULT ('') FOR [SPECODE]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_MARK] DEFAULT ('') FOR [MARK]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_MODEL] DEFAULT ('') FOR [MODEL]
GO
ALTER TABLE [dbo].[WOR_COLORS] ADD CONSTRAINT [DF_WOR_COLORS_CTYPE] DEFAULT (0) FOR [CTYPE]
GO
ALTER TABLE [dbo].[WOR_COLORS] ADD CONSTRAINT [DF_WOR_COLORS_COLOR] DEFAULT ('') FOR [COLOR]
GO
ALTER TABLE [dbo].[WOR_COLORS] ADD CONSTRAINT [DF_WOR_COLORS_DESC_] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD CONSTRAINT [DF_WOR_CUSTGPSDATA_CLIENTCODE] DEFAULT ('') FOR [CLIENTCODE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD CONSTRAINT [DF_WOR_CUSTGPSDATA_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD CONSTRAINT [DF_WOR_CUSTGPSDATA_LATITUDE] DEFAULT ('') FOR [LATITUDE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD CONSTRAINT [DF_WOR_CUSTGPSDATA_LONGITUDE] DEFAULT ('') FOR [LONGITUDE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD CONSTRAINT [DF_WOR_CUSTGPSDATA_HDOP] DEFAULT ('') FOR [HDOP]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD DEFAULT ('') FOR [SHIPADDRCODE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD DEFAULT ((0)) FOR [SHIPADDRID]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSLOC] ADD CONSTRAINT [DF_WOR_CUSTOMERGPSLOCATION_CLIENTREF] DEFAULT (0) FOR [CLIENTREF]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSLOC] ADD CONSTRAINT [DF_WOR_CUSTOMERGPSLOCATION_LATITUDE] DEFAULT ('') FOR [LATITUDE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSLOC] ADD CONSTRAINT [DF_WOR_CUSTOMERGPSLOCATION_LONGTITUDE] DEFAULT ('') FOR [LONGTITUDE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSLOC] ADD DEFAULT ('') FOR [CLCODE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSLOC] ADD DEFAULT ('') FOR [CLNAME]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_LINENO] DEFAULT (0) FOR [LINENO_]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_DESCRIPTION] DEFAULT ('') FOR [DEFINITION_]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_SPECODE] DEFAULT ('') FOR [SPECODE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_GROUPCODE] DEFAULT ('') FOR [GROUPCODE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_SLSMANREF] DEFAULT (0) FOR [SLSMANREF]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_ISSHOWSTOC] DEFAULT (0) FOR [ISSHOWSTOC]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_WHOUSE] DEFAULT (0) FOR [WHOUSE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_STYPE] DEFAULT (0) FOR [STYPE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_TYPE] DEFAULT (0) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_WRKTYPE] DEFAULT (0) FOR [WRKTYPE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_FORMGROUP] DEFAULT ('') FOR [FORMGROUP]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT (0) FOR [USEPENETRATION]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT (0) FOR [PTYPE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT (0) FOR [ENTPRICE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ((0)) FOR [PRODUCTCLASSREF]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ('0') FOR [MINSTOCK]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ((0)) FOR [USEMINSTOCK]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ('') FOR [FIRMNR]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ('') FOR [DONEMNR]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ('') FOR [INNERSQL]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_DEFORDERID] DEFAULT (0) FOR [DEFORDERID]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_GROUP] DEFAULT ('') FOR [GROUP_]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_WOR_DEFORDERDETAIL_PCODE] DEFAULT ('') FOR [PCODE]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_WOR_DEFORDERDETAIL_MCODE] DEFAULT ('') FOR [MCODE]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_WOR_DEFORDERDETAIL_PNAME] DEFAULT ('') FOR [PNAME]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_MINAMOUNT] DEFAULT (0) FOR [MINAMOUNT]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_MAXAMOUNT] DEFAULT (0) FOR [MAXAMOUNT]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_ISSLCTUNIT] DEFAULT (0) FOR [ISSLCTUNIT]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_UNIT] DEFAULT (0) FOR [UNIT]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_ISSHOWSTOCK] DEFAULT (0) FOR [ISSHOWSTOCK]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_WOR_DEFORDERDETAIL_LINENO_] DEFAULT (0) FOR [LINENO_]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD DEFAULT (0) FOR [COLORID]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD DEFAULT (0) FOR [UNITREF]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD DEFAULT ((0)) FOR [LINETYPE]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_FILENAME] DEFAULT ('') FOR [FILENAME]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_TYPE] DEFAULT ((0)) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_SECTORTYPE] DEFAULT ((0)) FOR [SECTORTYPE]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_SECTORNR] DEFAULT ((0)) FOR [SECTORNR]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_VALUE] DEFAULT ('') FOR [VALUE]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_TYPE] DEFAULT ((0)) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_FILENAME] DEFAULT ('') FOR [FILENAME]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_STARTY] DEFAULT ((0)) FOR [STARTY]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_DETAILCOUNT] DEFAULT ((0)) FOR [DETAILCOUNT]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_TITLEHEIGHT] DEFAULT ((0)) FOR [TITLEHEIGHT]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_DETAILHEIGHT] DEFAULT ((0)) FOR [DETAILHEIGHT]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_PAGEENDHEIGHT] DEFAULT ((0)) FOR [PAGEENDHEIGHT]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_PRINTINGENDHEIGHT] DEFAULT ((0)) FOR [PRINTINGENDHEIGHT]
GO
ALTER TABLE [dbo].[WOR_EMAILFORMS] ADD CONSTRAINT [DF_WOR_EMAILFORMS_FORMNAME] DEFAULT ((0)) FOR [FORMNAME]
GO
ALTER TABLE [dbo].[WOR_EMAILFORMS] ADD CONSTRAINT [DF_WOR_EMAILFORMS_FORMTYPE] DEFAULT ('') FOR [FORMTYPE]
GO
ALTER TABLE [dbo].[WOR_EMAILFORMS] ADD CONSTRAINT [DF_WOR_EMAILFORMS_FORMCONTENT] DEFAULT ('') FOR [FORMCONTENT]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_DATE_] DEFAULT ('01.01.1900') FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_LATITUDE] DEFAULT ('') FOR [LATITUDE]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_LONGTITUDE] DEFAULT ('') FOR [LONGTITUDE]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_SPEED] DEFAULT (0) FOR [SPEED]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_DISTANCE] DEFAULT (0) FOR [DISTANCE]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_TIMESPAN] DEFAULT (0) FOR [TIMESPAN]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_DESC_] DEFAULT ('') FOR [DEFINITION_]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_BEGDATE] DEFAULT ('01.01.1900') FOR [BEGDATE]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_ENDDATE] DEFAULT ('01.01.1900') FOR [ENDDATE]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_GROUPCODE] DEFAULT ('') FOR [GROUPCODE]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_VIEWTYPE] DEFAULT (0) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_NOTE] DEFAULT ('') FOR [NOTE]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD CONSTRAINT [DF_WOR_MESSAGE_SENDER] DEFAULT (0) FOR [SENDER]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD CONSTRAINT [DF_WOR_MESSAGE_RECIPENT] DEFAULT (0) FOR [RECIPIENT]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD CONSTRAINT [DF_WOR_MESSAGE_NOTE] DEFAULT ('') FOR [NOTE]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD CONSTRAINT [DF_WOR_MESSAGE_ISREAD] DEFAULT (0) FOR [ISREAD]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD CONSTRAINT [DF_WOR_MESSAGE_MSGTYPE] DEFAULT (0) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_LINENO_] DEFAULT (0) FOR [LINENO_]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_DESC_] DEFAULT ('') FOR [DEFINITION_]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_GROUPCODE] DEFAULT ('') FOR [GROUPCODE]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_STYPE] DEFAULT (0) FOR [STYPE]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_PNTGROUP] DEFAULT ('') FOR [PNTGROUP]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_PTYPE] DEFAULT (0) FOR [PTYPE]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_ENTPRICE] DEFAULT (0) FOR [ENTPRICE]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [COLRIGHT]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD1]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD2]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD3]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD4]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD5]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD6]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD7]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD8]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD9]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD10]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_PNTID] DEFAULT (0) FOR [PNTID]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_PRTYPE] DEFAULT ('') FOR [PRTYPE]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_PRODUCTID] DEFAULT (0) FOR [PRODUCTID]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_PCODE] DEFAULT ('') FOR [PCODE]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_PNAME] DEFAULT ('') FOR [PNAME]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_BARCODE] DEFAULT ('') FOR [BARCODE]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_UNIT] DEFAULT ('') FOR [UNIT]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_LINENO_] DEFAULT (0) FOR [LINENO_]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD DEFAULT ((0)) FOR [PRTYPEINT]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_DATE_] DEFAULT ('01.01.1900') FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_CLIENTREF] DEFAULT (0) FOR [CLIENTREF]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_PTYPE] DEFAULT (0) FOR [PTYPE]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_PREF] DEFAULT (0) FOR [PREF]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_PDISTANCE] DEFAULT (0) FOR [PDISTANCE]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_VREASON] DEFAULT ('') FOR [VREASON]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_VNOTE] DEFAULT ('') FOR [VNOTE]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT (0) FOR [ISPRINT]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT ('') FOR [CLCODE]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT ('') FOR [CLNAME]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT ((0)) FOR [SHIPINFOREF]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT ('') FOR [ENLEM]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT ('') FOR [BOYLAM]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_mainmenu] DEFAULT ('') FOR [mainmenu]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_submenu1] DEFAULT ('') FOR [submenu1]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_submenu2] DEFAULT ('') FOR [submenu2]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_submenu3] DEFAULT ('') FOR [submenu3]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_submenu4] DEFAULT ('') FOR [submenu4]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_submenu5] DEFAULT ('') FOR [submenu5]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_fno] DEFAULT ('') FOR [fno]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_parentfno] DEFAULT ('') FOR [parentfno]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_lineno_] DEFAULT (0) FOR [lineno_]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_level_] DEFAULT (0) FOR [level_]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_visible] DEFAULT (0) FOR [visible]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_lang] DEFAULT (0) FOR [lang]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_picturename] DEFAULT ('') FOR [picturename]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_url] DEFAULT ('') FOR [url]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_modul] DEFAULT ('') FOR [modul]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_CODE] DEFAULT ('') FOR [CODE]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_DESC_] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_GROUPCODE] DEFAULT ('') FOR [GROUPCODE]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_BEGDATE] DEFAULT ('01.01.1900') FOR [BEGDATE]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_ENDDATE] DEFAULT ('01.01.1900') FOR [ENDDATE]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_AMOUNT] DEFAULT (0) FOR [AMOUNT]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_PTYPE] DEFAULT (0) FOR [PTYPE]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_ALERTTYPE] DEFAULT (0) FOR [ALERTTYPE]
GO
ALTER TABLE [dbo].[WOR_QUOTADETAIL] ADD CONSTRAINT [DF_WOR_QUOTADETAIL_QUOTAID] DEFAULT (0) FOR [QUOTAID]
GO
ALTER TABLE [dbo].[WOR_QUOTADETAIL] ADD CONSTRAINT [DF_WOR_QUOTADETAIL_CODE] DEFAULT ('') FOR [CODE]
GO
ALTER TABLE [dbo].[WOR_REPORTS] ADD CONSTRAINT [DF_WOR_REPORTS_REPINDEX] DEFAULT ((0)) FOR [REPINDEX]
GO
ALTER TABLE [dbo].[WOR_REPORTS] ADD CONSTRAINT [DF_WOR_REPORTS_REPORTNAME] DEFAULT ('') FOR [REPORTNAME]
GO
ALTER TABLE [dbo].[WOR_REPORTS] ADD CONSTRAINT [DF_WOR_REPORTS_REPORTPATH] DEFAULT ('') FOR [REPORTPATH]
GO
ALTER TABLE [dbo].[WOR_REPORTS] ADD DEFAULT ((0)) FOR [RTYPE]
GO
ALTER TABLE [dbo].[WOR_REPORTS] ADD DEFAULT ('') FOR [REPORTCONTENT]
GO
ALTER TABLE [dbo].[WOR_SETTINGS] ADD CONSTRAINT [DF_WOR_SETTINGS_PNAME] DEFAULT ('') FOR [PNAME]
GO
ALTER TABLE [dbo].[WOR_SETTINGS] ADD CONSTRAINT [DF_WOR_SETTINGS_PVALUE] DEFAULT ('') FOR [PVALUE]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_DESC] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_STATUS] DEFAULT (0) FOR [STATUS]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD1] DEFAULT ('') FOR [FIELD1]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD2] DEFAULT ('') FOR [FIELD2]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD3] DEFAULT ('') FOR [FIELD3]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD4] DEFAULT ('') FOR [FIELD4]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD5] DEFAULT ('') FOR [FIELD5]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD6] DEFAULT ('') FOR [FIELD6]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD7] DEFAULT ('') FOR [FIELD7]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD8] DEFAULT ('') FOR [FIELD8]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD9] DEFAULT ('') FOR [FIELD9]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD10] DEFAULT ('') FOR [FIELD10]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD DEFAULT ((0)) FOR [USECASE]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD DEFAULT ((0)) FOR [MUSTDO]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD DEFAULT ((0)) FOR [PERIOD]
GO
ALTER TABLE [dbo].[WOR_SURVEYADETAIL] ADD CONSTRAINT [DF_SURVEYADETAIL_ANSWER] DEFAULT ('') FOR [ANSWER]
GO
ALTER TABLE [dbo].[WOR_SURVEYADETAIL] ADD CONSTRAINT [DF_SURVEYADETAIL_POINT] DEFAULT (0) FOR [POINT]
GO
ALTER TABLE [dbo].[WOR_SURVEYANSWERNEW] ADD CONSTRAINT [DF_WOR_SURVEYANSWERNEW_SID] DEFAULT ((0)) FOR [SID]
GO
ALTER TABLE [dbo].[WOR_SURVEYANSWERNEW] ADD CONSTRAINT [DF_WOR_SURVEYANSWERNEW_QID] DEFAULT ((0)) FOR [QID]
GO
ALTER TABLE [dbo].[WOR_SURVEYANSWERNEW] ADD CONSTRAINT [DF_WOR_SURVEYANSWERNEW_SUBJECT] DEFAULT ('') FOR [SUBJECT]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_BEGDATE] DEFAULT ('01.01.1900') FOR [BEGDATE]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_ENDDATE] DEFAULT ('01.01.1900') FOR [ENDDATE]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_STATUS] DEFAULT ((0)) FOR [STATUS]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_SUBJECT] DEFAULT ('') FOR [SUBJECT]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_CHOICEPROD] DEFAULT ((0)) FOR [CHOICEPROD]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_ENTERPRODAMOUNT] DEFAULT ((0)) FOR [ENTERPRODAMOUNT]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_DEFPRODAMOUNT] DEFAULT ((0)) FOR [DEFPRODAMOUNT]
GO
ALTER TABLE [dbo].[WOR_SURVEYQDETAIL] ADD CONSTRAINT [DF_SURVEYDETAIL_QTYPE] DEFAULT (0) FOR [QTYPE]
GO
ALTER TABLE [dbo].[WOR_SURVEYQDETAIL] ADD CONSTRAINT [DF_SURVEYDATIL_ANSWER] DEFAULT ('') FOR [QUESTION]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_SID] DEFAULT ((0)) FOR [SID]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_SUBJECT] DEFAULT ('') FOR [SUBJECT]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_TYPE] DEFAULT ((0)) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_DTYPE] DEFAULT ((0)) FOR [DTYPE]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_DEFVAL] DEFAULT ('') FOR [DEFVAL]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_ISMUST] DEFAULT ((0)) FOR [ISMUST]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_TODOUSERID] DEFAULT (0) FOR [TODOUSERID]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_DESC_] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_BEGDATE] DEFAULT ('01.01.1900') FOR [BEGDATE]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_ENDDATE] DEFAULT ('01.01.1900') FOR [ENDDATE]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_PRIORITY] DEFAULT (0) FOR [PRIORITY]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_SENDEMAIL] DEFAULT (0) FOR [SENDEMAIL]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_EMAILADDR] DEFAULT ('') FOR [EMAILADDR]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_NOTE] DEFAULT ('') FOR [NOTE]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_CUSTOMERID] DEFAULT (0) FOR [CUSTOMERID]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_USERNOTE] DEFAULT ('') FOR [USERNOTE]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_STATUS] DEFAULT (0) FOR [STATUS]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_DEFINITIONTIME] DEFAULT ('01.01.1900') FOR [DEFINITIONTIME]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_READTIME] DEFAULT ('01.01.1900') FOR [READTIME]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_COMPLATETIME] DEFAULT ('01.01.1900') FOR [COMPLATETIME]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD DEFAULT ((0)) FOR [SALESMUST]
GO
ALTER TABLE [dbo].[WOR_TRANSFERDATA] ADD CONSTRAINT [DF_WOR_TRANSFERDATA_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_TRANSFERDATA] ADD CONSTRAINT [DF_WOR_TRANSFERDATA_SESSIONID] DEFAULT ('') FOR [SESSIONID]
GO
ALTER TABLE [dbo].[WOR_TRANSFERDATA] ADD CONSTRAINT [DF_WOR_TRANSFERDATA_DATE_] DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_TRANSFERDATA] ADD CONSTRAINT [DF_WOR_TRANSFERDATA_DATASTR] DEFAULT ('') FOR [DATASTR]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_UNITSETREF] DEFAULT ((0)) FOR [UNITSETREF]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_UNITREF] DEFAULT ((0)) FOR [UNITREF]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_UNITCODE] DEFAULT ('') FOR [UNITCODE]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_CHOICEUNIT] DEFAULT ((0)) FOR [CHOICEUNIT]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_CONVERTUNIT] DEFAULT ((0)) FOR [CONVERTUNIT]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_RATIO] DEFAULT ((0)) FOR [RATIO]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_MAINUNIT] DEFAULT ((0)) FOR [MAINUNIT]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_WOR_USERANSWER_SLSCODE] DEFAULT ('') FOR [SLSCODE]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_WOR_USERANSWER_CLIENTREF] DEFAULT (0) FOR [CLIENTREF]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_WOR_USERANSWER_CLIENTCODE] DEFAULT ('') FOR [CLIENTCODE]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_WOR_USERANSWER_CLIENTNAME] DEFAULT ('') FOR [CLIENTNAME]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD1] DEFAULT ('') FOR [FIELD1]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD2] DEFAULT ('') FOR [FIELD2]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD3] DEFAULT ('') FOR [FIELD3]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD4] DEFAULT ('') FOR [FIELD4]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD5] DEFAULT ('') FOR [FIELD5]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD6] DEFAULT ('') FOR [FIELD6]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD7] DEFAULT ('') FOR [FIELD7]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD8] DEFAULT ('') FOR [FIELD8]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD9] DEFAULT ('') FOR [FIELD9]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD10] DEFAULT ('') FOR [FIELD10]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD DEFAULT ((0)) FOR [CASEID]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_SID] DEFAULT ((0)) FOR [SID]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_QID] DEFAULT ((0)) FOR [QID]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_PID] DEFAULT ((0)) FOR [PID]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_CID] DEFAULT ((0)) FOR [CID]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_DATE_] DEFAULT ('01.01.1900') FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_SUBJECT] DEFAULT ('') FOR [SUBJECT]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_AMOUNT] DEFAULT ((0)) FOR [AMOUNT]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_CLCODE] DEFAULT ('') FOR [CLCODE]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_CLNAME] DEFAULT ('') FOR [CLNAME]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_PCODE] DEFAULT ('') FOR [PCODE]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_PNAME] DEFAULT ('') FOR [PNAME]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_UNIQUEVAL] DEFAULT ('') FOR [UNIQUEVAL]
GO
ALTER TABLE [dbo].[WOR_USERFIRMS] ADD CONSTRAINT [DF_WOR_FIRMS_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_USERFIRMS] ADD CONSTRAINT [DF_WOR_FIRMS_FIRMNR] DEFAULT ('') FOR [FIRMNR]
GO
ALTER TABLE [dbo].[WOR_USERFIRMS] ADD CONSTRAINT [DF_WOR_FIRMS_PERIODNR] DEFAULT ('') FOR [PERIODNR]
GO
ALTER TABLE [dbo].[WOR_USERMENU] ADD CONSTRAINT [DF_WOR_USERMENU_usersid] DEFAULT (0) FOR [usersid]
GO
ALTER TABLE [dbo].[WOR_USERMENU] ADD CONSTRAINT [DF_WOR_USERMENU_level_] DEFAULT (0) FOR [level_]
GO
ALTER TABLE [dbo].[WOR_USERMENU] ADD CONSTRAINT [DF_WOR_USERMENU_fno] DEFAULT ('') FOR [fno]
GO
ALTER TABLE [dbo].[WOR_USERMENU] ADD CONSTRAINT [DF_WOR_USERMENU_parentfno] DEFAULT ('') FOR [parentfno]
GO
ALTER TABLE [dbo].[WOR_USERMENU] ADD CONSTRAINT [DF_WOR_USERMENU_visible] DEFAULT (0) FOR [visible]
GO
ALTER TABLE [dbo].[WOR_USERORDERS] ADD CONSTRAINT [DF_WOR_USERORDERS_ORFICHEREF] DEFAULT (0) FOR [ORFICHEREF]
GO
ALTER TABLE [dbo].[WOR_USERORDERS] ADD CONSTRAINT [DF_WOR_USERORDERS_SALESMANREF] DEFAULT (0) FOR [SALESMANREF]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_PNTIND] DEFAULT (0) FOR [PNTID]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_PNTDETAILID] DEFAULT (0) FOR [PNTDETAILID]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_CLIENTID] DEFAULT (0) FOR [CLIENTID]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_DATE_] DEFAULT ('01.01.1900') FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_VY] DEFAULT (0) FOR [VY]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_AMOUNT] DEFAULT (0) FOR [AMOUNT]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_PRICE] DEFAULT (0) FOR [PRICE]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_CURRENCY] DEFAULT ('') FOR [CURRENCY]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT (0) FOR [SOURCETYPE]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD1]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD2]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD3]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD4]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD5]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD6]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD7]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD8]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD9]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD10]
GO
ALTER TABLE [dbo].[WOR_USERQUOTA] ADD CONSTRAINT [DF_WOR_USERQUOTA_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_USERQUOTA] ADD CONSTRAINT [DF_WOR_USERQUOTA_QUOTAID] DEFAULT (0) FOR [QUOTAID]
GO
ALTER TABLE [dbo].[WOR_USERQUOTA] ADD CONSTRAINT [DF_WOR_USERQUOTA_AMOUNT] DEFAULT (0) FOR [AMOUNT]
GO
ALTER TABLE [dbo].[WOR_USERROLERIGHT] ADD CONSTRAINT [DF_WOR_USERSROLERIGHT_PARAMNO] DEFAULT ('') FOR [PARAMNO]
GO
ALTER TABLE [dbo].[WOR_USERROLERIGHT] ADD CONSTRAINT [DF_WOR_USERSROLERIGHT_PARAMVALUE] DEFAULT ('') FOR [PARAMVALUE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_USERNAME] DEFAULT ('') FOR [USERNAME]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_PASSWORD] DEFAULT ('') FOR [PASSWORD]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_TYPE] DEFAULT (0) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_CODE] DEFAULT ('') FOR [CODE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_NAME] DEFAULT ('') FOR [NAME]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_GROUPCODE] DEFAULT ('') FOR [GROUPCODE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_FNAME] DEFAULT ('') FOR [FNAME]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_LNAME] DEFAULT ('') FOR [LNAME]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_EMAIL] DEFAULT ('') FOR [EMAIL]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_WEB] DEFAULT ('') FOR [WEB]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_SPECODE] DEFAULT ('') FOR [SPECODE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_ADMIN] DEFAULT (0) FOR [ADMIN]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_LOGOVALUES] DEFAULT ('') FOR [LOGOVALUES]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF__WOR_USERS__DOSHI__181857E1] DEFAULT (0) FOR [DOSHIP]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD DEFAULT ('') FOR [LOGOUSER]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD DEFAULT ('') FOR [LOGOPWD]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD DEFAULT ('') FOR [WINUSERNAME]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD DEFAULT ((0)) FOR [APPTYPE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD DEFAULT ((0)) FOR [USERROLEID]
GO
ALTER TABLE [dbo].[WOR_USERSRIGHT] ADD CONSTRAINT [DF_WOR_USERRIGHT_PARAMNO] DEFAULT ('') FOR [PARAMNO]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_DATE_] DEFAULT ('01.01.1900') FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_PLAKA] DEFAULT ('') FOR [PLAKA]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_STARTKM] DEFAULT ('') FOR [STARTKM]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_ENDKM] DEFAULT ('') FOR [ENDKM]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_NOTE] DEFAULT ('') FOR [NOTE]
GO
ALTER TABLE [dbo].[WOR_VERSION] ADD CONSTRAINT [DF_WOR_VERSION_MAJOR] DEFAULT ('') FOR [MAJOR]
GO
ALTER TABLE [dbo].[WOR_VERSION] ADD CONSTRAINT [DF_WOR_VERSION_MINOR] DEFAULT ('') FOR [MINOR]
GO
ALTER TABLE [dbo].[WOR_VERSION] ADD CONSTRAINT [DF_WOR_VERSION_BUILD] DEFAULT ('') FOR [BUILD]
GO
ALTER TABLE [dbo].[WOR_VERSION] ADD CONSTRAINT [DF_WOR_VERSION_REVISION] DEFAULT ('') FOR [REVISION]
GO
ALTER TABLE [dbo].[WOR_VISITINFO] ADD CONSTRAINT [DF_WOR_VISITINFO_DESC_] DEFAULT ('') FOR [DESC_]
GO
LOGO SQL URETIM PLANLANAN
USE [X];
GO
/****** Object: View [dbo].[BM_211_URETIM_PLANLANAN] Script Date: 28.1.2020 14:34:41 ******/
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE VIEW [dbo].[BM_211_URETIM_PLANLANAN]
AS
SELECT *,
CASE
WHEN REPLACE(C.[Miktar Formülü], 'P1', [Uretim Miktar]) = 'P1' THEN
ISNULL(CONVERT(VARCHAR(20), C.[Uretim Miktar]), '0')
ELSE
ISNULL(REPLACE(C.[Miktar Formülü], 'P1', [Uretim Miktar]), '0')
END Formül
FROM
(
SELECT PL.LOGICALREF,
I.LOGICALREF LOGICALREFI,
STFICHE.FICHENO,
CASE
WHEN STFICHE.TRCODE = 11 THEN
'Fire Fişi'
WHEN STFICHE.TRCODE = 12 THEN
'Sarf Fişi'
WHEN STFICHE.TRCODE = 13 THEN
'Üretimden Giriş Fiişi'
ELSE
CONVERT(VARCHAR, STFICHE.TRCODE)
END [Fiş Türü],
CASE
WHEN YEAR(PO.DATE_) IS NULL THEN
YEAR(STFICHE.DATE_)
ELSE
YEAR(PO.DATE_)
END YIL,
CASE
WHEN YEAR(PO.DATE_) * 100 + MONTH(PO.DATE_) IS NULL THEN
YEAR(STFICHE.DATE_) * 100 + MONTH(STFICHE.DATE_)
ELSE
YEAR(PO.DATE_) * 100 + MONTH(PO.DATE_)
END AY,
CASE
WHEN PO.DATE_ IS NULL THEN
STFICHE.DATE_
ELSE
PO.DATE_
END Tarih,
CASE
WHEN PO.FICHENO IS NULL THEN
STFICHE.PORDERFICHENO
ELSE
PO.FICHENO
END [Üretim No],
STFICHE.BRANCH [İş Yeri Nr],
(
SELECT NAME
FROM L_CAPIDIV WITH (NOLOCK)
WHERE FIRMNR = 211
AND NR = STFICHE.BRANCH
) [İş Yeri Adı],
CASE
WHEN
(
PL.LINETYPE = '4'
OR PL.LINETYPE IS NULL
) THEN
'Ana Ürün'
WHEN PL.LINETYPE = '2' THEN
'Ek Ürün'
WHEN PL.LINETYPE = '3' THEN
'Yan Ürün'
WHEN PL.LINETYPE = '0' THEN
'Girdi'
ELSE
CONVERT(VARCHAR(3), PL.LINETYPE)
END [Satır Tipi],
I.CODE [Malzeme Kodu],
I.SPECODE [Malzeme Özel Kodu],
I.NAME [Malzeme Açıklaması],
(
SELECT CODE
FROM LG_211_UNITSETF WITH (NOLOCK)
WHERE LOGICALREF = I.UNITSETREF
) AS [Malzeme Birimi],
CASE
WHEN PL.FORMULA = '' THEN
'1'
ELSE
ISNULL(REPLACE(PL.FORMULA, ' ', ''), '0')
END [Miktar Formülü],
ISNULL(PL.FORMULA, '') [Formul Miktarı],
--CASE WHEN PL.LINETYPE=0 THEN (SELECT SUM(STL.AMOUNT) FROM LG_211_01_STLINE STL WITH (NOLOCK) WHERE STL.STOCKREF=PL.ITEMREF AND STL.POLINEREF=pl.LOGICALREF AND STL.TRCODE=12
--AND LPRODSTAT=0 AND YEAR(STL.DATE_)>2018)
--WHEN PL.LINETYPE=4 THEN (SELECT SUM(STL.AMOUNT) FROM LG_211_01_STLINE STL WITH (NOLOCK) WHERE STL.STOCKREF=PL.ITEMREF AND STL.POLINEREF=pl.LOGICALREF AND STL.TRCODE=13
--AND LPRODSTAT=0 AND YEAR(STL.DATE_)>2018
--) ELSE 0 END
STLINE.AMOUNT [Gerçekleşen Miktar],
ISNULL(PL.AMOUNT, '') [Planlanan Miktar],
ISNULL(
(
SELECT TOP 1
AMOUNT
FROM LG_211_POLINE pl2
WHERE pl2.PRODORDREF = PL.PRODORDREF
AND pl2.LINETYPE = 4
ORDER BY PL.LOGICALREF ASC
),
0
) [Uretim Miktar],
ISNULL(CONVERT(DECIMAL(10, 2), STLINE.AMOUNT - PL.AMOUNT), 0) Fark
FROM LG_211_01_STLINE STLINE
LEFT JOIN LG_211_01_STFICHE STFICHE
ON STFICHE.LOGICALREF = STLINE.STFICHEREF
LEFT JOIN LG_211_POLINE PL
ON PL.LOGICALREF = STLINE.POLINEREF /*ÜRETİM EMRİ SATIRLARI*/
LEFT JOIN LG_211_PRODORD PO
ON PO.LOGICALREF = PL.PRODORDREF /*ÜRETİM EMRİ FİŞLERİ*/
LEFT JOIN LG_211_ITEMS I
ON I.LOGICALREF = STLINE.STOCKREF
WHERE
--STFICHE.PORDERFICHENO='2019080010' AND
STLINE.LPRODSTAT = 0
AND STFICHE.PRODORDERREF <> 0
/*ORDER BY STFICHE.FICHENO*/
) AS C;
GO
USE [X];
GO
/****** Object: StoredProcedure [dbo].[BM_P_211_URETIM_PLANLANAN] Script Date: 28.1.2020 14:35:30 ******/
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE PROC [dbo].[BM_P_211_URETIM_PLANLANAN]
AS
DECLARE @sql NVARCHAR(MAX)
=
(
SELECT STUFF(
(
SELECT ' select ' + STR([LOGICALREF]) + ', ' + STR([LOGICALREFI]) + ', '
+ REPLACE(Formül, ',', '.') + ';'
FROM BM_211_URETIM_PLANLANAN t
FOR XML PATH('')
),
1,
1,
''
)
);
DECLARE @temp TABLE
(
[LOGICALREF] INT,
[LOGICALREFI] INT,
[Planlanan Miktar] FLOAT
);
INSERT @temp
EXEC (@sql);
SELECT
--STFICHENO,
--,PL2.LOGICALREF,
YIL,
AY,
Tarih,
[Üretim No],
[Fiş Türü],
FICHENO [Fiş No],
[İş Yeri Adı],
[Satır Tipi],
[Malzeme Kodu],
[Malzeme Özel Kodu],
[Malzeme Açıklaması],
[Malzeme Birimi],
Formül,
ISNULL(T.[Planlanan Miktar], 0) [Formul Miktarı],
[Gerçekleşen Miktar],
PL2.[Planlanan Miktar], /*,[Uretim Miktar]*/
CONVERT(DECIMAL(10, 2), [Gerçekleşen Miktar] - PL2.[Planlanan Miktar]) Fark
FROM BM_211_URETIM_PLANLANAN PL2
LEFT JOIN @temp T
ON T.LOGICALREF = PL2.LOGICALREF;
--GO
--EXEC [dbo].[BM_P_211_URETIM_PLANLANAN]
GO
SQL SERVER TABLES FIELDS DETAILED TO CONVERT C# CLASS
SELECT OBJECT_NAME(object_id) Table_Name, c.name Column_Name, t.name Field_Type,
t.name + CASE WHEN t.name IN ('char', 'varchar','nchar','nvarchar') THEN '('+
CASE WHEN c.max_length=-1 THEN 'MAX'
ELSE CONVERT(VARCHAR(4),
CASE WHEN t.name IN ('nchar','nvarchar') THEN c.max_length/2 ELSE c.max_length END ) END +')'
WHEN t.name IN ('decimal','numeric') THEN '('+ CONVERT(VARCHAR(4),c.precision)+',' + CONVERT(VARCHAR(4),c.Scale)+')' ELSE '' END AS Field_Type_Detail
FROM sys.columns c INNER JOIN sys.types t ON c.user_type_id = t.user_type_id
WHERE object_id = OBJECT_ID('LG_013_ITEMS') OR object_id = OBJECT_ID('L_CAPIDIV')
LOGO SQL SERVER VERITABANI INDEXLEME
INDEXLEME YAPMADAN ONCE VERITABANININ YEDEKLENMESI TAVSIYE EDILIR VE BUTUN KULLANICILAR LOGODAN CIKMALIDIR AĞ KONTROLUNDEN KONTROL EDİLİR
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"
spesifik tablo index:
ALTER INDEX ALL ON LG_XT1001_123 REBUILD;
ALTER INDEX ALL ON LG_123_ITEMS REBUILD;
LOGO SQL CARİ BAKİYELER
SELECT
(SELECT CODE FROM LG_119_CLCARD CL WHERE
CL.LOGICALREF= CLIENTREF) CODE ,
(SELECT DEFINITION_ FROM LG_119_CLCARD CL WHERE
CL.LOGICALREF= CLIENTREF) DEFINITION_,
ROUND(SUM(CASE WHEN SIGN=0 THEN AMOUNT ELSE 0-AMOUNT END),2) BALANCE,
CLIENTREF LOGICALREF
INTO BM_119_CH_BALANCE2
FROM LG_119_01_CLFLINE
GROUP BY CLIENTREF
HAVING ROUND(SUM(CASE WHEN SIGN=0 THEN AMOUNT ELSE 0-AMOUNT END),2)<>0
Blog of Sem 