Tables [dbo].[shTaxExceptions]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:44 AM Thursday, March 21, 2019
Last Modified1:16:20 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__shTaxExc__C22B5C3E29B45A70: ExceptionCodeIDExceptionCodeIDint4
False
1 - 1
Indexes IX_shTaxExceptions_ExceptionCode
UQ__shTaxExc__F46A89A4DC0144CA(2)ExceptionCodevarchar(40)40
False
ExceptionDescriptionvarchar(256)256
False
('')
ProcNamevarchar(256)256
True
ExceptionTypeint4
False
Statevarchar(10)10
False
('')
TaxAuthorityFlagint4
False
((0))
TaxFlagint4
False
((0))
LimitTypeint4
True
TaxLimitmoney8
True
BasisRangeBeginmoney8
True
BasisRangeEndmoney8
True
UsesProcbit1
False
((0))
Activebit1
False
((1))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__shTaxExc__C22B5C3E29B45A70: ExceptionCodeIDPK__shTaxExc__C22B5C3E29B45A70ExceptionCodeID
True
80
IX_shTaxExceptions_ExceptionCodeExceptionCode
True
80
UQ__shTaxExc__F46A89A4DC0144CAExceptionCode
True
80
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