/*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*/
Category: LOGO ERP
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
LOGODA AMBAR STOKLARI SIFIRLAMA (VARYANT DAHIL)
Logoda ambar stoklarını sıfırlamak için;
MALZEME YÖNETİMİ -> İŞLEMLER ->AMBAR SAYIMI
Çıkan ekranda sayım tarihi ve geçerli filtreler belirlenir tamama basılır (örnek hangi ambar sıfırlanacak filtreden seçilir)
Tamama bastıktan sonra karşınıza malzemelerin listesi ve stok miktarları gelir(malzeme fareket ve sayısına göre bu ekranın geliş süresi değişmektedir beklemeniz tavsiye edilir) burda dikkat edilmesi gereken Sayım miktarını her satır ve ambar için 0 yapmanız gerektiğidir fakat çok ürününüz varsa eğer bir excel yada notepad açıp minimum urun sayısı kadar satıra 0 yazıp kopyalayıp en yukarıdaki sayım miktarı kısmına yapıştırırsanız logo tek tek satırları 0 yapacaktır.
Sayım miktarlarını 0 yaptıktan sonra sağ alttan fiş oluştura basılır ve işlem tamamlanır…
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
LOGO OLMAPI32.DLL Hatası çözümü
sys ve logoyu açınca bu hata alınırsa
bu iki dosyanın sonuna alt çizgi koy mail göndermek için kullanılan dlldir göndermeyeceklerse gereksiz
Blog of Sem 