USE [LABORATORY]
GO
/****** Object:  Table [dbo].[tbLabMarkUpOptions]    Script Date: 11/20/2017 16:09:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbLabMarkUpOptions](
	[HolidayRate] [float] NULL,
	[HolidayOperator] [varchar](1) NULL,
	[StatRate] [float] NULL,
	[StatOperator] [varchar](1) NULL,
	[ERRate] [float] NULL,
	[EROperator] [varchar](1) NULL,
	[BeyondRegHrsRate] [float] NULL,
	[BeyondRegHrsOperator] [varchar](1) NULL,
	[BRHStartTime] [varchar](20) NULL,
	[BRHEndTime] [varchar](20) NULL,
	[MarkUpLimitRate] [float] NULL,
	[MarkUpLimitOperator] [varchar](1) NULL,
	[Bonzi] [varchar](1) NULL,
	[ExStat] [varchar](1) NULL,
	[ExBeyond] [varchar](1) NULL,
	[ExER] [varchar](1) NULL,
	[ExHoliday] [varchar](1) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[tbLabMarkUpOptions] ([HolidayRate], [HolidayOperator], [StatRate], [StatOperator], [ERRate], [EROperator], [BeyondRegHrsRate], [BeyondRegHrsOperator], [BRHStartTime], [BRHEndTime], [MarkUpLimitRate], [MarkUpLimitOperator], [Bonzi], [ExStat], [ExBeyond], [ExER], [ExHoliday]) VALUES (0, N'', 0.15, N'*', 0, N'', 500, N'+', N'06:00:00 PM', N'12:00:00 AM', 0, N'', NULL, N'0', N'0', N'0', N'0')