USE [build_file]
GO

/****** Object:  StoredProcedure [dbo].[spBuild_CanAddItems]    Script Date: 05/13/2011 12:19:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-->>To enable the BuildFile option in adding items to 
-->>the company, the class should be in the where condition
CREATE Procedure [dbo].[spBuild_CanAddItems]
@AccountNum varchar(10)

as

select Class from tbcocompany

where AccountNum = @AccountNum and Class in('HM')
go

Alter table Build_File..tbcorevenuecode
add GenericActive varchar(1) 

go

USE [Build_File]
/****** Object:  Table [dbo].[tbOPDUserSetting]    Script Date: 02/18/2011 11:56:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbGenericUserSetting](
	[EmployeeID] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[MenuID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Status] [bit] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
go

USE [Build_File]
GO

/****** Object:  Table [dbo].[tbGenericMenu]    Script Date: 05/13/2011 14:36:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbGenericMenu](
	[MenuID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Menu] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Status] [bit] NOT NULL,
	[MenuGroup] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[MainMenu] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
go

USE [Build_File]
GO

/****** Object:  Table [dbo].[tbGenericAccess]    Script Date: 05/13/2011 14:57:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING OFF
GO

CREATE TABLE [dbo].[tbGenericAccess](
	[UserID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[RevenueID] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[RevenueName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Status] [bit] NOT NULL,
	[RevTransSetting] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

go

Alter table tbcolabexam add
GSISPercentageRate varchar(4)
go

Alter table inventory..tbInvRentalItemsPrice add
RateI float null
go

Alter table patient_data..tbhospitalinfo add
isallowspecializedcompanyrate bit null

go