CREATE TABLE General_SchedReportAccts
                              (SRA_Sequence integer Identity(1,1) NOT NULL,
                               SRA_SchedRepSequence Integer NOT NULL,
                               SRA_ClientAccountNumber VarChar(20) NOT NULL,
			       SRA_LastRunDateTime datetime NULL,
			       SRA_PrintRepStatus tinyint NULL,	
			       SRA_SaveRepStatus tinyint NULL,
			       SRA_EmailFaxRepStatus tinyint NULL,
			       SRA_SubAccountNum VarChar(20) NOT NULL,
                               CONSTRAINT PK_General_AcctGroupDetails PRIMARY KEY NONCLUSTERED (SRA_Sequence)
                              );


ALTER TABLE [dbo].[General_SchedReportAccts] ADD
	CONSTRAINT [FK_General_SchedReportAccts_General_ReportScheduling] FOREIGN KEY
	(
		[SRA_SchedRepSequence]
	) REFERENCES [dbo].[General_ReportScheduling] (
		[RSR_Sequence]
	) ON DELETE CASCADE  


ALTER TABLE [dbo].[General_SchedReportAccts] ADD
	CONSTRAINT [FK_General_SchedReportAccts_Account_Details] FOREIGN KEY
	(
		[SRA_ClientAccountNumber]
	) REFERENCES [dbo].[Account_Details] (
		[ADT_ClientAccountNumber]
	) ON UPDATE CASCADE
