


GO  


GRANT SELECT ON DATABASE::poke TO rinascente;   


USE [TPSimphonyDB]
GO

/****** Object:  Table [m_it].[SimphonySalesData]    Script Date: 04/10/2018 11:13:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING OFF
GO

CREATE TABLE [m_it].[SimphonySalesData](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[BusinessDate] [datetime] NULL,
	[PropertyId] [int] NULL,
	[PropertyObjNum] [int] NULL,
	[PropertyName] [nvarchar](max) NULL,
	[RVCId] [int] NULL,
	[RVCObjNum] [int] NULL,
	[RVCName] [nvarchar](max) NULL,
	[CheckId] [int] NULL,
	[CheckNumber] [int] NULL,
	[DtlTyp] [char](1) NULL,
	[DtlID] [int] NULL CONSTRAINT [DF_SimphonySalesData_DtlID]  DEFAULT ((0)),
	[DtlIdx] [int] NULL,
	[DtlTypObjNum] [int] NULL,
	[DtlTypName] [nvarchar](max) NULL,
	[MajGrpId] [int] NULL,
	[MajGrpIdMajGrpId] [int] NULL,
	[MajGrpName] [nvarchar](max) NULL,
	[FamGrpId] [int] NULL,
	[FamGrpObjNum] [int] NULL,
	[FamGrpName] [nvarchar](max) NULL,
	[Count] [int] NULL CONSTRAINT [DF_SimphonySalesData_Count]  DEFAULT ((0)),
	[Weight] [decimal](19, 6) NULL CONSTRAINT [DF_SimphonySalesData_Weight]  DEFAULT ((0)),
	[Total] [decimal](19, 6) NULL CONSTRAINT [DF_SimphonySalesData_Total]  DEFAULT ((0)),
	[TAXPerc] [decimal](19, 6) NULL,
	[VAT] [decimal](19, 6) NULL,
	[VAT_Ext] [decimal](19, 6) NULL,
	[DscTTL] [nchar](10) NULL,
	[OrderTypeId] [int] NULL,
	[Covers] [int] NULL,
	[CheckOpen] [datetime] NULL,
	[CheckClose] [datetime] NULL,
	[IDTAGLI] [nvarchar](max) NULL,
	[Reference] [nvarchar](max) NULL,
	[Status] [int] NULL,
	[WSID] [int] NOT NULL,
	[LastChangeDate] [datetime] NULL,
	[AddRef1] [nvarchar](max) NULL,
	[AddRef2] [nvarchar](max) NULL,
	[AddRef3] [nvarchar](max) NULL,
	[TipoTransazione] [nvarchar](1) NULL,
	[CheckNumber_VOID] [int] NULL,
	[CheckOpen_VOID] [datetime] NULL,
	[WsId_VOID] [int] NULL,
 CONSTRAINT [PK_SimphonySalesData] 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

SET ANSI_PADDING OFF
GO

