CREATE TABLE [dbo].[shTaxExceptions]
(
[ExceptionCodeID] [int] NOT NULL IDENTITY(1, 1),
[ExceptionCode] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ExceptionDescription] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_shTaxExceptions_ExceptionDescription] DEFAULT (''),
[ProcName] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExceptionType] [int] NOT NULL,
[State] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_shTaxExceptions_State] DEFAULT (''),
[TaxAuthorityFlag] [int] NOT NULL CONSTRAINT [DF_shTaxExceptions_TaxAuthorityFlag] DEFAULT ((0)),
[TaxFlag] [int] NOT NULL CONSTRAINT [DF_shTaxExceptions_TaxFlag] DEFAULT ((0)),
[LimitType] [int] NULL,
[TaxLimit] [money] NULL,
[BasisRangeBegin] [money] NULL,
[BasisRangeEnd] [money] NULL,
[UsesProc] [bit] NOT NULL CONSTRAINT [DF_shTaxExceptions_UsesProc] DEFAULT ((0)),
[Active] [bit] NOT NULL CONSTRAINT [DF_shTaxExceptions_Active] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[shTaxExceptions] ADD CONSTRAINT [PK__shTaxExc__C22B5C3E29B45A70] PRIMARY KEY CLUSTERED ([ExceptionCodeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[shTaxExceptions] ADD CONSTRAINT [IX_shTaxExceptions_ExceptionCode] UNIQUE NONCLUSTERED ([ExceptionCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[shTaxExceptions] ADD CONSTRAINT [UQ__shTaxExc__F46A89A4DC0144CA] UNIQUE NONCLUSTERED ([ExceptionCode]) ON [PRIMARY]
GO