if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@ctdItemM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[W@ctdItemM]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[W@cthPTenantTItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[W@cthPTenantTItem]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ctdItemM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ctdItemM]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cthPTenantTItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[cthPTenantTItem]
GO

CREATE TABLE [dbo].[W@ctdItemM] (
	[PracticeCode] [varchar] (8) NOT NULL ,
	[ItemCode] [varchar] (4) NOT NULL ,
	[ItemName] [varchar] (40) NULL ,
	[ItemType] [varchar] (20) NULL ,
	[ItemImage] [varchar] (100) NULL ,
	[StandardPrice] [money] NULL ,
	[SellsPrice] [money] NULL ,
	[ConsumptionTax] [real] NULL ,
	[TransportPrice] [money] NULL ,
	[Remarks] [varchar] (40) NULL ,
	[RegistrationType] [smallint] NULL ,
	[SGroupCode] [varchar] (12) NULL ,
	[AddDate] [datetime] NULL ,
	[UpdDate] [datetime] NULL ,
	[AddProc] [varchar] (20) NULL ,
	[UpdProc] [varchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[W@cthPTenantTItem] (
	[PracticeCode] [varchar] (8) NOT NULL ,
	[TenantCode] [varchar] (12) NOT NULL ,
	[ItemCode] [varchar] (4) NOT NULL ,
	[ItemName] [varchar] (40) NULL ,
	[StockPrice] [money] NULL ,
	[StandardPrice] [money] NULL ,
	[SellsPrice] [money] NULL ,
	[ConsumptionTax] [real] NULL ,
	[TransportPrice] [money] NULL ,
	[Remarks] [varchar] (40) NULL ,
	[RegistrationType] [smallint] NULL ,
	[F] [varchar] (1) NULL ,
	[DisplayFlag] [smallint] NULL ,
	[DisplaySeq] [smallint] NULL ,
	[Remarks2] [varchar] (200) NULL ,
	[Remarks3] [varchar] (200) NULL ,
	[Remarks4] [varchar] (200) NULL ,
	[ItemImage] [varchar] (100) NULL ,
	[SalesImage1] [varchar] (100) NULL ,
	[SalesImage2] [varchar] (100) NULL ,
	[SalesImage3] [varchar] (100) NULL ,
	[SalesImage4] [varchar] (100) NULL ,
	[SalesImage5] [varchar] (100) NULL ,
	[AddDate] [datetime] NULL ,
	[UpdDate] [datetime] NULL ,
	[AddProc] [varchar] (20) NULL ,
	[UpdProc] [varchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ctdItemM] (
	[PracticeCode] [varchar] (8) NOT NULL ,
	[ItemCode] [varchar] (4) NOT NULL ,
	[ItemName] [varchar] (40) NULL ,
	[ItemType] [varchar] (20) NULL ,
	[ItemImage] [varchar] (100) NULL ,
	[StandardPrice] [money] NULL ,
	[SellsPrice] [money] NULL ,
	[ConsumptionTax] [real] NULL ,
	[TransportPrice] [money] NULL ,
	[Remarks] [varchar] (40) NULL ,
	[RegistrationType] [smallint] NULL ,
	[SGroupCode] [varchar] (12) NULL ,
	[AddDate] [datetime] NULL ,
	[UpdDate] [datetime] NULL ,
	[AddProc] [varchar] (20) NULL ,
	[UpdProc] [varchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cthPTenantTItem] (
	[PracticeCode] [varchar] (8) NOT NULL ,
	[TenantCode] [varchar] (12) NOT NULL ,
	[ItemCode] [varchar] (4) NOT NULL ,
	[ItemName] [varchar] (40) NULL ,
	[StockPrice] [money] NULL ,
	[StandardPrice] [money] NULL ,
	[SellsPrice] [money] NULL ,
	[ConsumptionTax] [real] NULL ,
	[TransportPrice] [money] NULL ,
	[Remarks] [varchar] (40) NULL ,
	[RegistrationType] [smallint] NULL ,
	[F] [varchar] (1) NULL ,
	[DisplayFlag] [smallint] NULL ,
	[DisplaySeq] [smallint] NULL ,
	[Remarks2] [varchar] (200) NULL ,
	[Remarks3] [varchar] (200) NULL ,
	[Remarks4] [varchar] (200) NULL ,
	[ItemImage] [varchar] (100) NULL ,
	[SalesImage1] [varchar] (100) NULL ,
	[SalesImage2] [varchar] (100) NULL ,
	[SalesImage3] [varchar] (100) NULL ,
	[SalesImage4] [varchar] (100) NULL ,
	[SalesImage5] [varchar] (100) NULL ,
	[AddDate] [datetime] NULL ,
	[UpdDate] [datetime] NULL ,
	[AddProc] [varchar] (20) NULL ,
	[UpdProc] [varchar] (20) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[W@ctdItemM] ADD 
	CONSTRAINT [DF_W@ctdItemM_StandardPrice] DEFAULT (0) FOR [StandardPrice],
	CONSTRAINT [DF_W@ctdItemM_SellsPrice] DEFAULT (0) FOR [SellsPrice],
	CONSTRAINT [DF_W@ctdItemM_TransportPrice] DEFAULT (0) FOR [TransportPrice],
	CONSTRAINT [DF_W@ctdItemM_RegistrationType] DEFAULT (0) FOR [RegistrationType],
	CONSTRAINT [DF_W@ctdItemM_SGroupCode] DEFAULT ('') FOR [SGroupCode],
	CONSTRAINT [PK_W@ctdItemM] PRIMARY KEY  CLUSTERED 
	(
		[PracticeCode],
		[ItemCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[W@cthPTenantTItem] ADD 
	CONSTRAINT [DF_W@cthPTenantTItem_StockPrice] DEFAULT (0) FOR [StockPrice],
	CONSTRAINT [DF_W@cthPTenantTItem_StandardPrice] DEFAULT (0) FOR [StandardPrice],
	CONSTRAINT [DF_W@cthPTenantTItem_SellsPrice] DEFAULT (0) FOR [SellsPrice],
	CONSTRAINT [DF_W@cthPTenantTItem_TransportPrice] DEFAULT (0) FOR [TransportPrice],
	CONSTRAINT [DF_W@cthPTenantTItem_RegistrationType] DEFAULT (0) FOR [RegistrationType],
	CONSTRAINT [DF_W@cthPTenantTItem_DisplayFlag] DEFAULT (0) FOR [DisplayFlag],
	CONSTRAINT [DF_W@cthPTenantTItem_DisplaySeq] DEFAULT (0) FOR [DisplaySeq],
	CONSTRAINT [PK_W@cthPTenantTItem] PRIMARY KEY  CLUSTERED 
	(
		[PracticeCode],
		[TenantCode],
		[ItemCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ctdItemM] ADD 
	CONSTRAINT [DF_ctdItemM_StandardPrice] DEFAULT (0) FOR [StandardPrice],
	CONSTRAINT [DF_ctdItemM_SellsPrice] DEFAULT (0) FOR [SellsPrice],
	CONSTRAINT [DF_ctdItemM_TransportPrice] DEFAULT (0) FOR [TransportPrice],
	CONSTRAINT [DF_ctdItemM_RegistrationType] DEFAULT (0) FOR [RegistrationType],
	CONSTRAINT [DF_ctdItemM_SGroupCode] DEFAULT ('') FOR [SGroupCode],
	CONSTRAINT [PK_ctdItemM] PRIMARY KEY  CLUSTERED 
	(
		[PracticeCode],
		[ItemCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cthPTenantTItem] ADD 
	CONSTRAINT [DF_cthPTenantTItem_StockPrice] DEFAULT (0) FOR [StockPrice],
	CONSTRAINT [DF_cthPTenantTItem_StandardPrice] DEFAULT (0) FOR [StandardPrice],
	CONSTRAINT [DF_cthPTenantTItem_SellsPrice] DEFAULT (0) FOR [SellsPrice],
	CONSTRAINT [DF_cthPTenantTItem_TransportPrice] DEFAULT (0) FOR [TransportPrice],
	CONSTRAINT [DF_cthPTenantTItem_RegistrationType] DEFAULT (0) FOR [RegistrationType],
	CONSTRAINT [DF_cthPTenantTItem_DisplayFlag] DEFAULT (0) FOR [DisplayFlag],
	CONSTRAINT [DF_cthPTenantTItem_DisplaySeq] DEFAULT (0) FOR [DisplaySeq],
	CONSTRAINT [PK_cthPTenantTItem] PRIMARY KEY  CLUSTERED 
	(
		[PracticeCode],
		[TenantCode],
		[ItemCode]
	)  ON [PRIMARY] 
GO