Create Table Account_TaxRates(
                ATX_Sequence integer Identity(1,1) NOT NULL,
	        ATX_RepId varchar(20) Not Null,
		ATX_TaxRateClass varchar(20) Not Null,
    		ATX_Date datetime Not Null,
    		ATX_SecType VarChar(4)Null,
                ATX_OrdFedRate real null,
                ATX_OrdStateRate real null,
 	        ATX_OrdLocalRate real null,
		ATX_STGainsRate real null,
		ATX_LTGainsHoldMons smallint Null,
  		ATX_LTGainsRate real null,
		ATX_VLTGainsHoldMons smallint Null,
		ATX_VLTGainsRate real null,
		ATX_ULTGainsHoldMons smallint Null,
		ATX_ULTGainsRate real null,
		ATX_WashLossDays real null,
		ATX_MaxLossDeduction real null,
		ATX_DivTaxRate real null,
		ATX_QualifDivHoldDays real null,
		ATX_QualifDivTaxRate real null,
		ATX_IntTaxRate real null,
		ATX_OrdIncTacSet int null,
		ATX_GainsTacSet int null,
		ATX_DivTacSet int null,
		ATX_IntTacSet int null,
		ATX_ZeroTaxTacSet int null,
		ATX_CrossDeductions tinyint null default 0,
		ATX_UseCPIndex bit null default 0,
		ATX_CPIndexSymbol VarChar(15) null,
		ATX_MinCPIndexHold smallint null default 0,
		ATX_NotesKeywords VarChar(120) null,   		
                ATX_TempRecord bit null default 0,
    		ATX_IsFrozen bit null default 0,
                CONSTRAINT PK_Account_TaxRates PRIMARY KEY CLUSTERED (ATX_Sequence)
                );

ALTER TABLE [dbo].[Account_TaxRates] ADD
	CONSTRAINT [FK_Account_TaxRates_General_UserInfo] FOREIGN KEY
	(
		[ATX_RepId]
	) REFERENCES [dbo].[General_UserInfo] (
		[CUC_LoginName]
	) ON UPDATE CASCADE

