dbo.GS_TrackerTaxRateResultsTaxTable Table

Properties

Creation Date	9/25/2015 3:11 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	0
Data Space Used	0.00 KB
Index Space Used	0.00 KB

Columns

Column Name	Datatype	Length
ResultTaxTableID	int	4
TrackerTaxRatesResultsID	int	4
SequenceNumber	int	4
TaxBracketUpperLimit	decimal	9 (19,5)
TaxBracketAmount	decimal	9 (19,5)
TaxBracketRate	decimal	9 (19,5)
TaxBracketExcessWages	decimal	9 (19,5)

Relationships

Relationship	Description
FK__GS_Tracke__Track__634730BE

Objects that dbo.GS_TrackerTaxRateResultsTaxTable depends on

	Database Object	Object Type	Description	Dep Level
	dbo.GS_TrackerTaxRatesResults	Table		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[GS_TrackerTaxRateResultsTaxTable](
	[ResultTaxTableID] [int] IDENTITY(1,1) NOT NULL,
	[TrackerTaxRatesResultsID] [int] NULL,
	[SequenceNumber] [int] NOT NULL,
	[TaxBracketUpperLimit] [decimal](19, 5) NOT NULL,
	[TaxBracketAmount] [decimal](19, 5) NOT NULL,
	[TaxBracketRate] [decimal](19, 5) NOT NULL,
	[TaxBracketExcessWages] [decimal](19, 5) NOT NULL
) ON [PRIMARY]

ALTER TABLE [dbo].[GS_TrackerTaxRateResultsTaxTable]  WITH CHECK ADD FOREIGN KEY([TrackerTaxRatesResultsID])
REFERENCES [dbo].[GS_TrackerTaxRatesResults] ([TrackerTaxRatesResultsID])

Related Objects

dbo Schema
SQL Objects Database